Search found 106 matches

by Drg
Wed May 29, 2019 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 538

Re: Getting all the children of an element

To add to my previous question how to use this MDX from TI to iterate through all the elements in the subset {TM1DRILLDOWNMEMBER( {[Dimension].[Element]}, ALL, RECURSIVE )} Thanks Best solution to create dynamic subset: MDX='your mdx'; vLastDim='DimensionName'; vSubset='randomName'; SubsetCreate(vL...
by Drg
Mon May 27, 2019 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: File is open in IBM Cognos TM1 Server
Replies: 3
Views: 133

Re: File is open in IBM Cognos TM1 Server

Yes, this problem is also found at 10.2.2 fp 7, there is still no solution except restarting.
by Drg
Fri May 17, 2019 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RulesOverwriteCellsOnLoad is NOT working
Replies: 10
Views: 331

Re: RulesOverwriteCellsOnLoad is NOT working

Yes today we update to 2.0.7 Other configs. [TM1S] ServerLogging=F SecurityPackageName=Kerberos IntegratedSecurityMode=1 UseSSL=T ServerName=HauptAbu1 DataBaseDirectory=D:\PAModels\HauptAbu1 AdminHost= PortNumber= ClientMessagePortNumber= Savetime= Downtime= LicenseMetricTime= ProgressMessage=True A...
by Drg
Fri May 17, 2019 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RulesOverwriteCellsOnLoad is NOT working
Replies: 10
Views: 331

Re: RulesOverwriteCellsOnLoad is NOT working

I have read the documentation and I understand its name as shown in the picture below. Another question that I found an interesting feature is that it is marked with the third option. I suppose this is updated with the update of the cube and in combat situations it will lead you according to the doc...
by Drg
Wed May 08, 2019 6:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 799

Re: RunProcess and threads

Why having both? To make support more intellectually stimulating? :-) How do you do check for task completion via cubes, do a runTI that reads the cube contents? What happens if this 'check' process itself fails, would you be able to differentiate between it running successfully or failing silently...
by Drg
Tue May 07, 2019 1:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and SAP HANA Integration
Replies: 5
Views: 1136

Re: TM1 and SAP HANA Integration

hi deepakjain2020 we have the development but to upload the data from tm1 to SAP HANA where we use the JDBC driver. Loading data bypassing ODBC looks very dangerous, with timeouts of data types and all the rest .... Perhaps it makes sense for you to upload data from HANA to files and then upload the...
by Drg
Tue May 07, 2019 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StrToMember MDX function causing a server crash
Replies: 7
Views: 291

Re: StrToMember MDX function causing a server crash

Yes, the server crash is unacceptably cruel. But you can use the workaround using the union of two members and take only one upper one, then if the first one is empty, you can take the default one. But this is terrible in terms of finding bugs.
by Drg
Tue May 07, 2019 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Name on TI Process
Replies: 14
Views: 6382

Re: Server Name on TI Process

There is a free solution from me.

just put this process on startupchore in the config.

after exec you get a dimension sys_ServerParameters with attributes cube where places all params in pParamsList variable.
by Drg
Tue May 07, 2019 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StrToMember MDX function causing a server crash
Replies: 7
Views: 291

Re: StrToMember MDX function causing a server crash

you tried to put more curly braces???

Code: Select all

{GENERATE( {FILTER( TM1SUBSETALL( [Account] ),
	LEN([mycube].([Version].[Active1], [Measure].[myMeasure])) > 0)}
	, {StrToMember("[Account].[" + [mycube].([Version].[Active1], [Measure].[RollupAccount]) + "]")})}
by Drg
Tue May 07, 2019 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RulesOverwriteCellsOnLoad is NOT working
Replies: 10
Views: 331

Re: RulesOverwriteCellsOnLoad is NOT working

TM1SERVER_APP_version=TM1SERVER_APP-AW64-ML-RTM-11.0.6.71-0



WORKED FINE.
write some data in cube. append on this slice rule savedataall restart.

RulesOverwriteCellsOnLoad=F data save after disable rule
RulesOverwriteCellsOnLoad=T data loss after disable rule
by Drg
Tue May 07, 2019 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Link unable to access remotely
Replies: 3
Views: 222

Re: PAW Link unable to access remotely

maybe you network do not trust tm1.

try http://10.131.151.141:5895
10.131.151.141 is tm1 adminhost services
by Drg
Tue May 07, 2019 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel data loads and TM1runTI, Hustle
Replies: 11
Views: 1491

Re: Parallel data loads and TM1runTI, Hustle

our security service limits us in possible means therefore we have 2 processes of the parallel queue manager, one based on the flag files, the second based on the cube of the queue with the priorities of the chot processes allows building complex orchestrations, this option looks more reliable but i...
by Drg
Tue May 07, 2019 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 799

Re: RunProcess and threads

As I said, process A and B would have their own transaction sets, so would not see the changes made by the other process. The process that finishes last commits its changes last. Thank you very much for confirming this. To get back to Yuri's point about controlling or orchestrating batch processes....
by Drg
Tue Apr 16, 2019 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOCKS on subset and views wheen mtq > 0
Replies: 3
Views: 464

Re: LOCKS on subset and views wheen mtq > 0

Hi, You code is showing a subset creation procedure, MTQ is applicable for data reads under following conditions: Queries exceeding 10,000 cell visits. Creation of TM1 ‘stargate’ vew. Views containing the results of rule derived calculations. Sorry, what do you mean by Parallel Unloading? Thanks ET...
by Drg
Tue Apr 16, 2019 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM SSO not working in Tm1web on Client machine
Replies: 2
Views: 390

Re: IBM SSO not working in Tm1web on Client machine

We fix it.

You need to double-check(refresh) all the settings of IIS.
there are suspicions that some of the paratmers have been updated for them, which leads to colisees
by Drg
Thu Mar 28, 2019 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOCKS on subset and views wheen mtq > 0
Replies: 3
Views: 464

LOCKS on subset and views wheen mtq > 0

Hi to all. Someone noticed a drop in the performance of parallel(runti) processes if mtq is greater than 1. I caught it when I produced parallel unloading from the model and used the same subsets to form views. a piece of code that forms subsets based on a custom user subset: vLastDim=param1; vSub=p...
by Drg
Tue Mar 26, 2019 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA Extension
Replies: 5
Views: 893

Re: JAVA Extension

Hi Mate, As far as I know this has been depreciated in PA. Based on your profile you are on 10.2.2, but given its going out of support in the near future, I would not be investing my time into Java Extensions. Rest API is the way forward. There are open-source Python wrappers available online that ...
by Drg
Tue Mar 05, 2019 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web- Cell Background Color Change
Replies: 5
Views: 875

Re: TM1 Web- Cell Background Color Change

if we talk abaut tm1 web you can change color directly in
C:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\scripts\tm1web\themes\flat\flat.css
if you use this theme checked in browser in develop mode (f12)