Search found 292 matches
- 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: 1857
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: 9735
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: 4001
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: 4367
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: 4367
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: 9791
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: 8073
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: 8073
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: 8073
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: 2641
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: 1528
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, ...
- Tue May 26, 2020 1:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - weight of a member
- Replies: 5
- Views: 5055
Re: MDX - weight of a member
Hi,
The answer I got on this was:
"the weight expression seems more of an internal mechanism, not really built for something like filtering. We (IBM) would recommend filtering using another method"
Regards,
Mark
The answer I got on this was:
"the weight expression seems more of an internal mechanism, not really built for something like filtering. We (IBM) would recommend filtering using another method"
Regards,
Mark
- Tue May 05, 2020 9:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - Navigation in Perspectives v Web
- Replies: 3
- Views: 2605
Re: Action Buttons - Navigation in Perspectives v Web
Hi,
I have used DBRW's as references to reports in Action buttons.
Can you provide exactly what values you are holding in the cubes the DBRW's are referncing and
how exactly you are referencing the DBRW's in the action button?
regards,
Mark
I have used DBRW's as references to reports in Action buttons.
Can you provide exactly what values you are holding in the cubes the DBRW's are referncing and
how exactly you are referencing the DBRW's in the action button?
regards,
Mark
- Tue Apr 14, 2020 5:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button Properties window (dialog box)
- Replies: 2
- Views: 1490
Re: Action Button Properties window (dialog box)
Hi,
Don't have access to TM1 at the moment but if memory serves me right, in this situation I just press the enter key on the keyboard when I have finished updating the action button. This seems to work ok
regards,
mark
Don't have access to TM1 at the moment but if memory serves me right, in this situation I just press the enter key on the keyboard when I have finished updating the action button. This seems to work ok
regards,
mark
- Thu Mar 12, 2020 11:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW in Excel
- Replies: 2
- Views: 2069
Re: DBRW in Excel
Hi,
FYI this was previously discussed here:
https://www.tm1forum.com/viewtopic.php? ... 380#p72795
Personally I nearly fell off my chair when I first heard about this!
regards,
Mark
FYI this was previously discussed here:
https://www.tm1forum.com/viewtopic.php? ... 380#p72795
Personally I nearly fell off my chair when I first heard about this!
regards,
Mark
- Wed Feb 26, 2020 12:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hyperlink in TM1 Web
- Replies: 5
- Views: 3415
Re: Hyperlink in TM1 Web
Yes I was wondering about the Action Button too.
But for information, I can hyperlink to a .xlsm too
But for information, I can hyperlink to a .xlsm too
- Tue Feb 25, 2020 12:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hyperlink in TM1 Web
- Replies: 5
- Views: 3415
Re: Hyperlink in TM1 Web
HI, You need to use the name of the file in the externals folder, not the applications. Also, I have found that if I try to hyperlink from excel and then publish the form to the application folder it fails. So I just create the hyperlink, don't test it in excel and then publish it. Then test it on t...
- Wed Feb 19, 2020 2:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL Query - ODBC or syntax issue?
- Replies: 5
- Views: 13319
Re: SQL Query - ODBC or syntax issue?
Looking at the error I would check your spacing, for example you have sum([DMBTR]) as AmountFROM [SAP_Eksport].[dbo].[VE_Z_XTRACT_DOCUMENTS] ZapisySapLEFT There needs to be a space between Amount and From and ZapisySap and Left There are other spacing issues so I would sort that out first regards, M...
- Tue Feb 18, 2020 7:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drill Through to ORACLE ODBC
- Replies: 11
- Views: 5084
Re: Drill Through to ORACLE ODBC
Just ruling out anything obvious, you haven't applied any case sensitivity to any of your table columns have you?
- Thu Jan 30, 2020 1:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX FILTER and non-existent elements
- Replies: 7
- Views: 4319
Re: MDX FILTER and non-existent elements
Oh so this stops server crashes for invalid members, in that case a welcome improvement, given I have fallen foul of this when I first started out on TM1!