TM1 Forum

So using the ROUNDP(<32bit float>, 2) is the only way to apply rules that query a cell for the value 0,00 ?

Fabian

The actual inconsistency is between what I see in the TM1 Viewer and what is exported into the .cma file.

How do you explain that ?

Fabian.

It happens anyway .... We see these numbers directly imported from ORACLE. Is it possible that ORACLE stores them like this ? "validation:NUN_LEDGER","IT1:08023120","IT2:FAC1","IT3:XXX","IT4:","IT6:","AC","RAW","128...

After loading data from an ORACLE database with the format decimal(13,2) we end up finding numbers in TM1 that look like 90.000000000001 (we exported the data and find these numbers in the .cma file) and therefore also consolidated values that look like 0.0000000000001 We apply rules that check if a...

Default behaviour of TM1 is to show consolidations above it's children.

For analysis purposes this is fine, but for standard reporting subtotals and totals are generally shown below their child members.

Is there a way to get this kind of behaviour using subsets ?


Regards,

Fabian