Cognos 8 Report Studio report over Tm1 data with calcs

[BigG]

Hi, This may not have many answers.

We have Report Studio reports over TM1 cube. A report will return data ok from TM1 data source (cube) into a crosstab. In the Report Studio report, we have further singleton cells calculating (on the fly) the % of total for each column (so the % 's are displayed in bottom row). This works well except for some rule calculated items (returning '--' which apparently means error). The rules are fed, the % calcs work in TM1, but C8 Report studio not happy.

We completed the following to date:
1) calculated % in TM1, but the % does not allow us drag into the last row (has to be column) of crosstab
2) created two queries, add master data relationship, but this means the relationship for whole 'page' and we have other crosstabs on the report as well

The problem seems to be with a quirk in C8 when calculating the rule driven measures. Cant find anything on the web, so any suggestions would be good. thanks in advance

G

[BigG]

Think this is the reason why the numbers don't return for rule calculated cells in a singleton, believe it may be due to the order of the calculation

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

Unexpected Results When Using Aggregation with TM1 Data Sources
TM1 data sources can include rule-derived cells. IBM Cognos 8 cannot identify these rule-derived cells ahead of time, so performing an aggregation on these cells may yield unexpected results. For example, aggregating a set containing a rule-derived value may produce unexpected results in Report Studio and Analysis Studio.

Note: Explicit aggregation operations like sum, average, count, minimum, and maximum are not affected.

If you are using TM1 data cubes with rule-derived cells in IBM Cognos 8, we recommend that you install TM1 build number 9.4.00001.576, which identifies aggregation errors by marking the error cells with dashes (--).

[BigG]

I resolved this by recalculating the cube rule calculation in the report.