Search found 83 matches

by lynnsong986
Mon Oct 28, 2019 5:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 6085

Re: TI process question - Mapping greyed out

It works now thanks everyone!!
by lynnsong986
Mon Oct 28, 2019 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 6085

Re: TI process question - Mapping greyed out

Thank you very much! I'll go read it now...
by lynnsong986
Mon Oct 28, 2019 3:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 6085

Re: TI process question - Mapping greyed out

sorry one more question, somehow the months get sorted wrong (please see attached capture.png), the generated line:
DIMENSIONSORTORDER('Monthss','BYINPUT','ASCENDING','BYINPUT','ASCENDING');

how can I fix the order so it appears:

01, 02,03....12?

thanks!
by lynnsong986
Mon Oct 28, 2019 3:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 6085

Re: TI process question - Mapping greyed out

it worked, thanks both for your kind help!
by lynnsong986
Mon Oct 28, 2019 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 6085

Re: TI process question - Mapping greyed out

I see what you mean, I'll give it a try in Prolog, thanks!
by lynnsong986
Mon Oct 28, 2019 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 6085

Re: TI process question - Mapping greyed out

Thanks for replying, can you please let me know why Mapping is greyed out and how can I get to it so I can select "Create Cube"? this is literally the first time I'm doing something like this, please bear with me...
by lynnsong986
Mon Oct 28, 2019 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 6085

TI process question - Mapping greyed out

Hello, I'm trying to create a reporting cube for an Income Statement cube with different time dimensions. the source cube has one time dimension (please see attachment timeDim) and I need to split it into two dimensions: months and Year while skipping all YTD elements I don't understand why Mapping ...
by lynnsong986
Tue Oct 15, 2019 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about using Chore to update dimension/cube
Replies: 7
Views: 7516

Re: Question about using Chore to update dimension/cube

Thank you so very much for your time on this! You are totally awesome!
by lynnsong986
Tue Oct 15, 2019 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about using Chore to update dimension/cube
Replies: 7
Views: 7516

Re: Question about using Chore to update dimension/cube

It’s great to know! I can stop searching for answers now...

Thank you so much for answering!!
by lynnsong986
Mon Oct 14, 2019 5:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about using Chore to update dimension/cube
Replies: 7
Views: 7516

Question about using Chore to update dimension/cube

Hello, It seems that I need to rename the updated CSV files and take the browser to the renamed file for the TI process to recognize changes made in that file to update a dimension or a cube. This doesn’t make sense to me - if I create new chore that updates the dimension or the cube every 7 days au...
by lynnsong986
Sun Oct 13, 2019 4:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about time dimension
Replies: 4
Views: 4084

Re: Question about time dimension

No it’s not...sorry I was just trying to understand why the YTD part looks so different.
by lynnsong986
Fri Oct 11, 2019 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about time dimension
Replies: 4
Views: 4084

Re: Question about time dimension

Ok got it thanks so much again!
by lynnsong986
Fri Oct 11, 2019 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about time dimension
Replies: 4
Views: 4084

Question about time dimension

Hello, this is a dumb question...can someone please tell me if there is a difference between the two time dimensions? the second on is an existing one and I manually created the first one. they are both sorted by hierarchy but look very differently (the YTD part), trying to understand why here... th...
by lynnsong986
Thu Oct 10, 2019 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI problem loading "Comments"
Replies: 14
Views: 7367

Re: TI problem loading "Comments"

I didn't expect any answers yet you took the time to explain it in such great details...I can't tell you how much I appreciate it!! I did go through a few rounds during my training changing variable type to "Other" then manipulate the codes directly under Map. I didn't realize where the pr...
by lynnsong986
Wed Oct 09, 2019 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI problem loading "Comments"
Replies: 14
Views: 7367

Re: TI problem loading "Comments"

thanks so much for your time!
by lynnsong986
Wed Oct 09, 2019 9:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI problem loading "Comments"
Replies: 14
Views: 7367

Re: TI problem loading "Comments"

yes it worked! what is the logic behind this if you don't mind me asking?
by lynnsong986
Wed Oct 09, 2019 9:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI problem loading "Comments"
Replies: 14
Views: 7367

Re: TI problem loading "Comments"

I can't proceed, the same pop up came up when I clicked on Dimensions or Advanced. and I tried to delete the process and recreate it, same thing happened. What else could have gone wrong here?
by lynnsong986
Wed Oct 09, 2019 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI problem loading "Comments"
Replies: 14
Views: 7367

Re: TI problem loading "Comments"

sorry I tried but got the same popup, I don't understand as I have two dimensions and I have two elements under variables?
by lynnsong986
Wed Oct 09, 2019 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI problem loading "Comments"
Replies: 14
Views: 7367

Re: TI problem loading "Comments"

Thanks so much for helping me out!! we went through a merger (4 big utilities merged) and the mergeCo is now using TM1 for budget/forecasts. I have no IT background whatsoever, so I'm very sorry if my questions are too basic for you. The problem with TM1 is that, unlike Excel with which I can always...