Search found 9 matches
- Fri Nov 13, 2015 8:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MagnitudeDifferenceToBeZero
- Replies: 4
- Views: 3792
Re: MagnitudeDifferenceToBeZero
I have not used this before but will test over the weekend. However the OP didn't say what the value of A was set to, or what the parameter was set to in the config file. The MagnitudeDifferenceToBeZero specifies the size ratio between the numerator and denominator, beyond which the safe division ca...
- Wed Sep 19, 2012 8:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: If null in TM1 rule
- Replies: 6
- Views: 8240
Re: If null in TM1 rule
Since TM1 doesn't store zero's (unlike other databases) there is no difference between Null and 0; they are the same thing. If it is a rule calculated value that is conditionally populated (so it might be populated and that value could be zero) you could base your test on the condition used in the c...
- Fri Sep 14, 2012 4:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Deactivate dialog "Are you sure you want to leave this page"
- Replies: 8
- Views: 7396
Re: Deactivate dialog "Are you sure you want to leave this p
Thanks Wim,
Your MVP status is well deserved! We made the change to the HTML and the logout link appears and works as advertised. Now I can't even remember what that crazy old message said.
Your MVP status is well deserved! We made the change to the HTML and the logout link appears and works as advertised. Now I can't even remember what that crazy old message said.

- Fri Sep 14, 2012 1:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Deactivate dialog "Are you sure you want to leave this page"
- Replies: 8
- Views: 7396
Re: Deactivate dialog "Are you sure you want to leave this p
Sadly, no button for us. An About, a Help, and a pretty logo. 
Luckily we only get the message once.
Each time.

Luckily we only get the message once.

- Fri Sep 14, 2012 12:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Deactivate dialog "Are you sure you want to leave this page"
- Replies: 8
- Views: 7396
Re: Deactivate dialog "Are you sure you want to leave this p
There's a logout button? In our environment, CX 9.5 IE9, I've never been able to find one. We've just ignored the annoying message.
- Tue Jun 05, 2012 12:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need to make a change in existing TM1 application
- Replies: 8
- Views: 5275
Re: Need to make a change in existing TM1 application
Hi, That is pretty open ended! I didn't understand from your post if the attributes of the workstation elements changed or if you get new workstation elements each month. You will have to give a bit more information. If the elements in the workstation dimension are changing each month (i.e. new work...
- Fri Jun 01, 2012 12:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with Decimals data load from TM1 Cube to Oracle table
- Replies: 17
- Views: 13403
Re: Issue with Decimals data load from TM1 Cube to Oracle ta
The key piece of the function description for EXPAND, That string has a fixed minimum length of 10 characters. If the converted number is too small to fill 10 characters, it is padded with leading spaces. Only three leading decimal characters are converted. For example, a numerical value of 0.123456...
- Mon May 28, 2012 6:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX TM1FILTERBYPATTERN - from a subset
- Replies: 5
- Views: 7151
Re: MDX TM1FILTERBYPATTERN - from a subset
I think it's the DynamicTop that is giving you problems. It doesn't seem to be recognized by TM1. If you type it into the expression window of the Subset Editor you get the same "Failed to compile MDX expression" message. What is the logic for the MDX to pick just the single element EC4GB ...
- Wed Mar 07, 2012 11:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web - hide empty columns
- Replies: 6
- Views: 8313
Re: TM1 Web - hide empty columns
We figured out a way to have the columns show as blank by exploiting the fact that the INDIRECT function is not supported in TM1Web. We are displaying 60 possible weeks of data and the column headers are derived by an IF formula with it's False condition being INDIRECT("H8") or other blank...