TM1 Rule based facts not rolling up correctly in Cognos

[ub14]

Hi,

We are using TM1 Cube as data source and developing reports in Cognos Report Studio. We have few facts in TM1 Cube which are based on rules. and requirement is that when user select multiple reporting dates , then these facts need to be rolled up and display accordingly. But when we roll-up, instead of displaying values, its display blank in the report. The rest of the facts which are not applied rules are aggregated correctly. Example for rule as below:

[‘CSR’] = C: [‘MISales’]/['CSCOUNT'] ;

Is there any way we can rollup the facts which are applied rules also. Is this limitation with TM1 or Cognos ?

[winsonlee]

When a consolidation is not displaying the value correctly it is manly due to the feeders.
If you are using skipcheck without using feeders, it will result in the wrong result displayed.

[Marcus Scherer]

There is a documented restriction in Cognos BI which may apply to your problem:

http://publib.boulder.ibm.com/infocente ... _data.html

IBM books say "IBM Cognos 8 can run the calculation itself" - whatever that means. Maybe there is a functionality in Report Studio to solve the problem.

[ub14]

Hi,

Thanks for your reply. Its fine if we are applying few rules in TM1 and same can be applied in Report Studio to resolve this issue. Is there any alternative way we can resolve this, since we are going to apply rules on 10-20 facts which need to be used Report Studio.

[Martin Ryan]

your rule has "c" in it, which means it only applies at a consolidated level. By using this you are overriding the usual consolidation functionality.

That said, your rule looks like it may be possibly be a ratio, so it might make sense to have this rule applied at both N: and C: level. In which case the rule should be [‘CSR’] = [‘MISales’]/['CSCOUNT'] ;

As winsonlee mentions though, your other problem will also be feeders. Assuming your rule isn't a ratio (i.e. should be at N: level only, then consolidated up) your rule should be

SkipCheck;
[‘CSR’] = N: [‘MISales’]/['CSCOUNT'] ;
Feeders;
['MISales'] => ['CSR'];

For more on the introduction to rules, try here: http://wiki.tm1forum.com/index.php/TM1_Rules

HTH,
Martin