Search found 9 matches

by TrailRunnerMark
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...
by TrailRunnerMark
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...
by TrailRunnerMark
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. :D
by TrailRunnerMark
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. :cry:
CX Websheet.JPG
CX Websheet.JPG (21.54 KiB) Viewed 7348 times
Luckily we only get the message once. :D Each time.
by TrailRunnerMark
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.
by TrailRunnerMark
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...
by TrailRunnerMark
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...
by TrailRunnerMark
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 ...
by TrailRunnerMark
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...