Merry Christmas to all!
And hopefully a Happy New Year
Search found 241 matches
- Thu Dec 24, 2020 10:24 am
- Forum: General
- Topic: For anyone who has been depressed by the train wreck that was 2020...
- Replies: 4
- Views: 371
- Thu Nov 19, 2020 11:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form rebuild removes MDX in subset
- Replies: 2
- Views: 288
Re: Active form rebuild removes MDX in subset
Hi, Like Tomok this makes little sense to me without more information. One thing I would point out is that I notice in your MDX you have a cube name, RC_UBZ_PC and a dimension with exactly the same name. I have seen where a cube and dimension have the same name it messes with MDX, however it usually...
- Thu Sep 10, 2020 3:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 1675
Re: Active form hell
Hi Wim,
All I can say is it wasn't me!
regards, Mark
All I can say is it wasn't me!
regards, Mark
- Thu Sep 10, 2020 3:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 1675
Re: Active form hell
Hi Wim, No because you only have one year in each example. In your original rolling 13 you had 2 years in the columns. Try 2 years and put the value in a month that you don't include on the report, so have Y1 and Y2, Jan and Feb but put 5999 in March. That way you sort of replicate your original pro...
- Thu Sep 10, 2020 2:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 1675
Re: Active form hell
Hi Wim, your original had only 13 rolling months, so if some there was data in any month in the same year but not part of the 13 months then you would see extra rows, even though the months were not in the columns. But in your new example you have 2 years worth of data and every month, and because t...
- Thu Sep 10, 2020 1:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 1675
Re: Active form hell
Hi Wim, But it worked surely because those rows are the only rows to have values in any month in the years selected (i.e. 2020, 21 and 22)? the other rows disappear because they have no values in any of those months? Which is why your post 2 up just confused me and I didn't respond! This bit really ...
- Fri Sep 04, 2020 8:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 1675
Re: Active form hell
Hi Wim, I am not aware this has ever worked differently, though happy to be corrected. So not sure if I would say you have been lucky, more possibly you have not had a form set up which exposes this limitation? But as I said if you create your view in the cube viewer and supress zero rows you would ...
- Fri Sep 04, 2020 8:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 1675
Re: Active form hell
Hi Wim, Not sure I follow you, the 24 column workaround does not involve deleting any columns. That workaround basically throws the 13 rolling period out of the window and settles for 24 columns each and every time. Because what you are trying to do can only, as far as I know, be achieved by followi...
- Fri Sep 04, 2020 8:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 1675
Re: Active form hell
Hi Wim, Tomok is correct of course. One dimension would solve this. Or forgetting 13 periods and settling for any given 2 years, possibly conditional formatting the columns you want to focus on. I.e. some other workaround. The reason you are seeing Product 1,2 and 3 must be because there is a value ...
- Mon Jul 13, 2020 5:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Reports ver 2.0.9 - data misaligned
- Replies: 3
- Views: 702
Re: Active Reports ver 2.0.9 - data misaligned
Hi, I have found that if the TM1RPTROW column order on the report does not follow the column order of the cube then it gets misaligned. Appears to be a bug in later releases. It should be noted that it does work ok on the web even if it doesn't work in excel. If you do need to work within excel then...
- Mon Jul 13, 2020 4:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Expand function with numbers
- Replies: 13
- Views: 1851
Re: Expand function with numbers
Hi Wim, I feel like you have pulled the 5 card trick here, in your first comment you reference nStart but never expand nStart but in your latest example you expand N both times. So the issue with your original problem has nothing to do with decimal places and expand does it? The problem is you cant ...
- Fri Jul 10, 2020 12:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculate minutes
- Replies: 10
- Views: 1124
Re: Calculate minutes
Hi Orlando, Well, assuming you want to calculate the difference in minutes between 2 dates, then TIMVL isn't going to help you as far as I can see. Though maybe you could have put something like that in the topic title :D Here is how I would approach it: I would break the value down between the date...
- Tue Jul 07, 2020 7:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: STR(Num, len, dec) with only one argument
- Replies: 11
- Views: 1627
Re: STR(Num, len, dec) with only one argument
I am more from the Treble Ctrl C, as I always think you need an extra one for luck! 

- Mon Jul 06, 2020 12:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: STR(Num, len, dec) with only one argument
- Replies: 11
- Views: 1627
Re: STR(Num, len, dec) with only one argument
Whilst you are making the RFE could you suggest they change the function name to something a bit longer as I don't have enough typing to do? lol! I have always wanted some function aliases in TM1 but was too afraid to ask! So NumberToString could be NTS for example. That would have saved soooo much...
- Thu Jul 02, 2020 10:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Change of MDX security in 2.0.9 - Discussion
- Replies: 18
- Views: 3325
Re: Change of MDX security in 2.0.9 - Discussion
Yeah, thanks from me too 

- Wed Jul 01, 2020 7:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check if a parameter value is numeric
- Replies: 9
- Views: 3323
Re: check if a parameter value is numeric
Yes, and in that case just use if iserror!
regards, Mark
regards, Mark
- Tue Jun 30, 2020 4:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check if a parameter value is numeric
- Replies: 9
- Views: 3323
Re: check if a parameter value is numeric
Yes, I originally had isnumber in my comment but then thought it is probably for the web so changed it!
- Tue Jun 30, 2020 9:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check if a parameter value is numeric
- Replies: 9
- Views: 3323
Re: check if a parameter value is numeric
Hi,
I would think Tomok's suggestion is the way to go, but
Cant you just do the check in Excel, so have a formula along the lines of:
=IFERROR(A1*1,0)
=IF(A2=0,0,1)
Then have a parameter in the TI called pIsNumeric (1 or 0) and have the action button point at this cell?
regards,
Mark
I would think Tomok's suggestion is the way to go, but
Cant you just do the check in Excel, so have a formula along the lines of:
=IFERROR(A1*1,0)
=IF(A2=0,0,1)
Then have a parameter in the TI called pIsNumeric (1 or 0) and have the action button point at this cell?
regards,
Mark
- Mon Jun 22, 2020 1:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Picklist
- Replies: 3
- Views: 789
Re: Dynamic Picklist
Hi, Assuming you literally only want to rule where a person is in opport1 they should not appear in opport2 picklist, then I got this to work as follows: Create a clone of your existing cube but with the person dimension and a measure dimension added, this measure will hold a 1 or 0. This cloned cub...
- Wed May 27, 2020 7:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW error: VIEW_CONVERSION_FAILED
- Replies: 1
- Views: 366
Re: PAW error: VIEW_CONVERSION_FAILED
Hi, I have seen this before and it was security related. For some reason, possibly to do with performance modeler, the }DimensionSecurity cube was created which meant groups had None access to the dimensions! The remedy was to take the server offline and delete the }DimensionSecurity cube. regards, ...