Search found 53 matches

by Rtel
Thu Jan 09, 2020 8:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: most stable version for PA upgrade
Replies: 3
Views: 289

most stable version for PA upgrade

Hello, we are planning to upgrade to PA on Windows from Tm1 10.2.2 on AIX

Which is the most stable version of PA that we can upgrade to. As we all know 2.0.9 is the latest we have.

Thanks

Rtel
by Rtel
Thu Dec 05, 2019 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: passing variable as parameters to TM1runti
Replies: 4
Views: 468

Re: passing variable as parameters to TM1runti

Hi Wim, I missed the expand function in the code

It's working now !

Thank you very much

Rtel
by Rtel
Thu Dec 05, 2019 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: passing variable as parameters to TM1runti
Replies: 4
Views: 468

Re: passing variable as parameters to TM1runti

P1 = account1 P2 = account2 Calling proc executecommand ('path/tm1runti.exe -adminhost myadminhost -server myserver -user "Admin" -pwd apple -process TestCalledProc parameter1="%P1%" parameter2="%P2%" ' , 1 ) ; Called proc ASCIIOUTPUT('filepath/TestOutput.csv', ' The parameter value is ' | P1 | ' AN...
by Rtel
Wed Dec 04, 2019 9:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: passing variable as parameters to TM1runti
Replies: 4
Views: 468

passing variable as parameters to TM1runti

Following code in TI process TESTPROC1 works fine executecommand ('path/tm1runti.exe -adminhost myadminhost -server myserver -user "Admin" -pwd apple -process TestCalledProc parameter1="aaa" parameter2="bbb" ' , 1 ) ; I have 2 parameters in TESTPROC1 as P1 and p2 Now if I want to pass a parameter P1...
by Rtel
Fri Oct 04, 2019 2:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create elements based on a cubeview
Replies: 2
Views: 1588

Create elements based on a cubeview

I am writing a TI to add a new element from a data source (a cube view) CUBE Name – CubeA DIMENSION – 1) Counter (1,2,3,4,5…) 2) ElementDetails ( DimName, Element, ParentElement, ChildElement, Attr1_Name, Att1_Value, …AttrN_Name, AttN_Value) When I passed view of a view of CubeA as data source, I ge...
by Rtel
Wed Jul 31, 2019 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 1185

Re: Server crashing with "Evalution stack overflow"

Do you have any example or some documentation of breaking feeders with TI please ? You should export the cube values (including rules). Then you disable the rules for, for example, opening balance of a new year. Finally, you reload the exported data again. Most of these steps can be automated throu...
by Rtel
Wed Jul 31, 2019 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 1185

Re: Server crashing with "Evalution stack overflow"

Hello Steve, thanks a lot for sharing this information. I have written below what I have understood from your post. Kindly let me know if I got it right ------------------------------------------------------------- #Rule Break points ['Day 500', Opening]=N:[Day 499, Closing]; ['Day 1000', Opening]=N...
by Rtel
Tue Jul 30, 2019 8:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 1185

Re: Server crashing with "Evalution stack overflow"

Hello, Why is 2017 and 2018 still calculated ? Can't you replace it with values loaded by TI ? In general (and I did not have a look at Steve's link), you can break the calculation stack by loading values with TI let's say the beginning of the year. This should be a yearly exercise. And only feed w...
by Rtel
Tue Jul 30, 2019 6:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 1185

Re: Server crashing with "Evalution stack overflow"

Thanks Steve, As per your link ['Today']=> DB( Cube,....Attrs('Day', !Day,'Next')....) can be broken as follows.. #Fails on June 1st ['Jan 1st']=>DB( Cube,....Attrs('Day', !Day,'Next')....) #Fails on Dec 31st ['Jun 2nd']=>DB( Cube,....Attrs('Day', !Day,'Next')....) In my case Log files in server poi...
by Rtel
Tue Jul 30, 2019 6:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 1185

Re: Server crashing with "Evalution stack overflow"

Hi. 1 yes - you model start longest 2 try clear data in cubes and restart on small data sets 3 yep if you do not touch 1 point Maybe you have a feeders from leaf level to parent (leaf+1 level) recursion ...??? Thanks for your response, I am trying to break the feeders and will experiment rebooting ...
by Rtel
Tue Jul 30, 2019 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 1185

Server crashing with "Evalution stack overflow"

Hello I am getting following error and the server does not start at all. I have persistent feeder as True 1543 [] INFO 2019-07-29 21:20:22.132 TM1.Server TM1CubeImpl::ProcessFeeders: Computing feeders for base cube 'DATA'. 1543 [] WARN 2019-07-29 21:20:23.295 TM1.Cube Execution aborted - Evaluation ...
by Rtel
Mon Jun 10, 2019 3:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating cubes across different applications with TI
Replies: 3
Views: 836

Re: Updating cubes across different applications with TI

Hello All, Thanks for your responses. I will explore the direction provided.

Hi Wim, by 'Application' I meant a TM1 server modal.

Thanks

Rtel
by Rtel
Thu Jun 06, 2019 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating cubes across different applications with TI
Replies: 3
Views: 836

Updating cubes across different applications with TI

Hi, I am writing a TI to update data in a cubes in one application. This needs to be followed by change data in a cube in another application also. So is it possible to write a TI process to update values in a cube in a different application ? or How can I have a TI process from one application call...
by Rtel
Mon Jun 03, 2019 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: At Wits' End: "File not found: tm1xl.ocx"
Replies: 11
Views: 12550

Re: At Wits' End: "File not found: tm1xl.ocx"

Correction..

I believe path to tm1p.xla should point to 'C:\Program Files\ibm\cognos\tm1_64\bin' folder since my MS Excel is 32 bit. If that's true, how do I change the TM1 perspective to look at 'C:\Program Files\ibm\cognos\tm1_64\bin' folder for Tm1p.xla
by Rtel
Mon Jun 03, 2019 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: At Wits' End: "File not found: tm1xl.ocx"
Replies: 11
Views: 12550

Re: At Wits' End: "File not found: tm1xl.ocx"

Hello, I am getting Tm1.ocx error 53. I tried registering all the DLLs (tm1xl.ocx, tm1prc.dll,tm1dasrv.dll ) but still getting error. I checked the path of tm1.xla from VBA and its pointing to C:\Program Files\ibm\cognos\tm1_64\bin64 I believe path to tm1p.xla should point to 'C:\Program Files\ibm\c...
by Rtel
Mon Jun 03, 2019 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: display Dimension dialog box from TI process
Replies: 3
Views: 384

Re: display Dimension dialog box from TI process

Hi Tomok and Paul, thank you for your help.

Rtel
by Rtel
Fri May 31, 2019 3:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: display Dimension dialog box from TI process
Replies: 3
Views: 384

display Dimension dialog box from TI process

Hello, Q 1) I want to create an action button to invoke a TI that takes an Element name as an argument. Can we create this form with action button from Architect or we need Perspective ? Q 2) Lets say we have a Dimension named Product and one of the element in it is Electronics. Can we display produ...
by Rtel
Wed May 29, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 895

Re: Getting all the children of an element

Hello All, thanks for all your help. Following is the working code that I would like to share. From the responses I understand that there are 1) two diff MDX to create subset 2) two way to create Dynamic subset ( I will try both to understand the difference) Thanks, Rtel ----------------------------...
by Rtel
Tue May 28, 2019 10:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 895

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
by Rtel
Tue May 28, 2019 10:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 895

Getting all the children of an element

Hi, In a TI, I want to loop through all the child elements of an element passed as an argument. For eg if Element name argument to TI is 'Element 1' , TI should iterate through Element 1.1 Element 1.2 Element 1.3 Element 1.3.1 Element 1.3.2 I tried ElementCount function, but it is throwing error as ...