Search found 83 matches
- 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!!
- 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...
- 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!
DIMENSIONSORTORDER('Monthss','BYINPUT','ASCENDING','BYINPUT','ASCENDING');
how can I fix the order so it appears:
01, 02,03....12?
thanks!
- 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!
- Mon Oct 28, 2019 3:26 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 so much!!
- 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!
- 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...
- 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 ...
- 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!
- 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!!
Thank you so much for answering!!
- 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...
- 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.
- 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!
- 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...
- 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...
- 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!
- 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?
- 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?
- 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?
- 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...