TM1 Forum

I will provide more details as requested, however - At a high level we have some users that are working with the PAX tool in TM1, and they are experiencing tremendous slowdown in the EXCEL application. For instance, they will have 3-5 second delays in basic excel navigation using arrow keys, and app...

Thanks! This is exactly what I was looking for. Really appreciate the help.

I will forward all these comments to my TM1 Developer and TM1 support team to investigate and report back with more details on the outcome.


Steve

I'll check back with the users. as to the example they sent me. However, the original question is still there - Is the standard to place a <blank> in the cell if the underlying data is null? You indicated from your earlier post that you felt NULL values were populated with 0, if the underlying data ...

I am pretty Sure that the underlying element Type is a numeric value.

the Setting from essbase is here in case someone is familiar with both systems:

Hello, My team is switching from Hyperion ESSbase, and they are familiar with an ESSBase feature where the a cell with missing data (Null Data) can default to a replacement string - typically the value "0". So in the excel PAX tool, on 10.2, unless they wrap the TM1 Function call in an IF ...