Issues creating a ROUNDP rule

[njcube]

Hello everyone,

I am new to TM1 so please bear with me.

I am administrating an existing TM1 application. The application has a reporting cube utilized by Cognos BI reports. Within the TM1 cubes, certain measure have ling decimal values and I wanted to round those values to 2 decimal places.

The reporting cube gets loaded via a load TI process that runs every few hours. Rather than added to the TI process, I thought it would be simpler to add a rule to the reporting cube. The issue is that once I add the rule and save it, when i try to open the reporting cube, it never returns and Architect stops responding. I have to end up killing the service and restarting.

I also tried adding the RUX file while the service is down and then starting it. The service ends up never coming up and crashing eventually.

My test rule was only for one measure. I have a few more I want to apply it to but figured I would see if it worked first.

Here is the rule I added:

['Final Rate'] = N:

ROUNDP(DB('budReporting','Organization A','2020','Planning',!budElementOfResource,!budCustomer,!budOverheadType,!budFundTypeAppropSubApprop,!budAMS,!budProgram,!budEmployee,'Final Rate'),2);

I am running Planning Analytics 11.0.6
The cube is 95,166 KB in size
The server has 64 GB Memory which is about 80% in use when running TM1

Thank you very much for any feedback you can provide.

[Wim Gielis]

You have a circular reference. What you want to calculate depends on itself. That’s not going to work. If you want to use a rule, create a second measure and use that one for the calculation. That being said, I would think that BI had no problem rounding numeric values...

[Steve Rowe]

I'd strongly recommend that you regard this as a formatting problem not a data problem.

If you go the rule approach then you will duplicate all the data (bad).
You could round the data on loading in the TI process, this is probably the most right way.

but....

As TM1 (and almost any computer) sums 2 d.p. values in Base 10 together it converts them into binary and then back again. This process often introduces very small values at a high number of d.p. and so the sum of 2 d.p. values will not always give a 2 d.p. value.

[njcube]

Thank you both for your responses. It looks like I need to reevaluate how I address the rounding issue as you both suggested.

Thanks again.