TM1 Forum

Has anyone used rules to force a cell format?
I what to restrict the number of decimal points accepted by the cube on a dbs from the user. They don't alwas get the rounding right and Excel has a habit of poor rounding on calculated values.

wissew wrote:Has anyone used rules to force a cell format?
I what to restrict the number of decimal points accepted by the cube on a dbs from the user. They don't alwas get the rounding right and Excel has a habit of poor rounding on calculated values.

I may be wrong but as far as I know cell formatting won't affect the precision of the values stored, just the display of them.

A rule which pulls from the raw numbers and rounds them into output numbers in different elements using the RoundP function would be possible, but probably pretty expensive in terms of processing overhead and memory for what it does. Another option is to have the values loaded into an input cube and have TI interface them to the main cube rounded, but again that would require processing time and prevent the numbers from being "real time". A third option might be to have a TI process run periodically which loops through the numbers and rounds them off.

But AFAIK you can't restrict input to a specified decimal value; it's either a number or a string.

Alan Kirk wrote:

wissew wrote:Has anyone used rules to force a cell format?
I what to restrict the number of decimal points accepted by the cube on a dbs from the user. They don't alwas get the rounding right and Excel has a habit of poor rounding on calculated values.

I may be wrong but as far as I know cell formatting won't affect the precision of the values stored, just the display of them.

A rule which pulls from the raw numbers and rounds them into output numbers in different elements using the RoundP function would be possible, but probably pretty expensive in terms of processing overhead and memory for what it does. Another option is to have the values loaded into an input cube and have TI interface them to the main cube rounded, but again that would require processing time and prevent the numbers from being "real time". A third option might be to have a TI process run periodically which loops through the numbers and rounds them off.

But AFAIK you can't restrict input to a specified decimal value; it's either a number or a string.

Thanks for confirming my thoughts.
I thought about the raw and round value elements and the overhead would be big, but all the math the rounded value woiuld be used for would run in TI mostly at night.
I gave it a shot using the roundp in a cell security cube rule but that only effects access to data not data.
If I come up with something I'll keep you posted