Search found 59 matches
- Mon Jan 04, 2021 3:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 application validation error on approval hierarchy
- Replies: 1
- Views: 1195
TM1 application validation error on approval hierarchy
Hello, we have upgraded from TM1 10.2.2 to PA 2.0.9.2 After importing the data from Tm1 application in 10.2.2 to 2.0.9.2 when I validate the application I get following error "One or more members of the approval hierarchy have multiple parents" --- and there is an element value provided (e...
- Mon Jan 04, 2021 3:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 7892
Re: ASCIIOUTPUT does not create output file
Thank you for all the responses,
I will check if Meta and data sections are processed at all or not.
Also the view is already manually created and is used as a data source. The data in the view is rule derived.
Thanks
Rtel
I will check if Meta and data sections are processed at all or not.
Also the view is already manually created and is used as a data source. The data in the view is rule derived.
Thanks
Rtel
- Wed Dec 23, 2020 6:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 7892
Re: ASCIIOUTPUT does not create output file
Hello, thank you for your feedback. sorry for the delayed response. The code runs fine in prolog and it created an output (test.CSV) file. Prolog ASCIIOUTPUT('/folder1/folder2/TestOutput1.csv', 'a', 'b', 'c'); But when I run the asciioutput in data section on the same path it does not create file at...
- Fri Nov 20, 2020 7:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 7892
Re: ASCIIOUTPUT does not create output file
Sorry misspelled your name Wim
- Fri Nov 20, 2020 7:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 7892
Re: ASCIIOUTPUT does not create output file
Thanks Tomok,
1) the folder1 and folder 2 are valid path
2) I will check the service account access the folder on linux server
Thanks Gim
I ran the code in prolog and still the same issue
Thanks
Rtel
1) the folder1 and folder 2 are valid path
2) I will check the service account access the folder on linux server
Thanks Gim
I ran the code in prolog and still the same issue
Thanks
Rtel
- Fri Nov 20, 2020 6:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 7892
ASCIIOUTPUT does not create output file
Hello, its strange that the ASCIIOUTPUT does not create the output .cma file at all The code is very simple .... ASCIIOUTPUT('/folder1/folder2/test1.cma', '1', '2', '3'); Its a linux server and running TM1 10.2.2 (I want to extract a view and that's not working either ...so I tried a simple code as ...
- 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: 2124
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
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
- 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: 2571
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
It's working now !
Thank you very much
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: 2571
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 pa...
- 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: 2571
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...
- 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: 3055
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...
- 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: 5567
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...
- 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: 5567
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...
- 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: 5567
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...
- 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: 5567
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...
- 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: 5567
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 ...
- 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: 5567
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 ...
- 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: 2663
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
Hi Wim, by 'Application' I meant a TM1 server modal.
Thanks
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: 2663
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...
- 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: 19610
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
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