Search found 7 matches

by Meg
Wed Oct 05, 2016 9:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Export using TI process
Replies: 9
Views: 7172

Re: Cube View Export using TI process

data tab.png
data tab.png (21.55 KiB) Viewed 6965 times
by Meg
Wed Oct 05, 2016 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Export using TI process
Replies: 9
Views: 7172

Re: Cube View Export using TI process

attached the picture of the variables.
defined Variables.png
defined Variables.png (24.23 KiB) Viewed 6966 times
by Meg
Wed Oct 05, 2016 9:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Export using TI process
Replies: 9
Views: 7172

Re: Cube View Export using TI process

thanks all.I was able to export at the consolidated level but the posting key against the value is matching. Posting key logic is mentioned below, IF(V17=1); IF(Value>0); vPosting='50'; ELSE; vPosting='40'; Endif; Else; IF(Value>0); vPosting='40'; ELSE; vPosting='50'; Endif; ENDIF; attached picture ...
by Meg
Wed Sep 28, 2016 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Export using TI process
Replies: 9
Views: 7172

Re: Cube View Export using TI process

Hi David,

Here are the attached screen shots, currently I am getting the export at leaf level.
leaf level.png
leaf level.png (45.7 KiB) Viewed 7107 times
But need the export as below, how to do this ? as all the Dimension in the cube has only one consolidation as total.
Consolidated level.PNG
Consolidated level.PNG (71.65 KiB) Viewed 7107 times
by Meg
Wed Sep 28, 2016 5:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Export using TI process
Replies: 9
Views: 7172

Re: Cube View Export using TI process

Hi Jim, Thanks for your suggestion but I have only one consolidation & have 158 GL Codes as leaf level elements.as these elements are mapped to different Salary components of Employees like Bonus,Gross Pay,Net Pay,expense etc.i need the data consolidation of each leaf level elements,how do I do ...
by Meg
Tue Sep 27, 2016 10:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Export using TI process
Replies: 9
Views: 7172

Cube View Export using TI process

Hi,

How to export .csv file by using the Cube view at consolidated level in TI process?i am able to export through tI process using ASCIIOUTPUT but I need at consolidated level.
by Meg
Wed Jun 08, 2016 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New to TM1
Replies: 3
Views: 2894

New to TM1

Hi,

Am very new to TM1 not sure on where to start with. Can anybody give me suggestion as to what are basics i should start with? Am not a technical guy.

Regards
Meg