Hello experts,
I have developed a crosstab report in which some measures come out as blank values while they have numbers in the TM1 cube(data source).
I created a list report sourcing from the same query and it does give me correct data for all measures while the crosstab does not.
I tried converting the list to Crosstab using 'Pivot list to crosstab' option in report studio but again those 2 measures had blank values.
I am working on Cognos BI 10.1 and the TM1- 10.2 cubes are the data source.
Please help.
Thank You.
I have found on the net that in order to avoid this we need to set 'Aggregate function' - 'None' and 'Rollup Aggregate' - 'Total' .
But these functions appear only when we have any calculated data items.
I just have simple measures dragged and dropped to the report page.
Thanks.
My initial reaction is to think the aggregation rules in the cube are wonky.
But barring that, If I were in your position I would try to go around that by creating a calculated measure using that same measure and in the formula use: Total (currentmeasure within set) or something to that effect. Let us know if you can get any results using a secondary measure.
Thanks a ton for the reply.
I tried the 'currentmeasure within set' , 'Tuple', 'Value tuple'...nothing works.
I still see no value for 2 measures in the multimeasure crosstab.
Please let me know if I need to try something else.
Thanks in advance.