Some measure show blank values in a crosstab while they appear in a list report

[cognos4321]

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.

[cognos4321]

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.

[SpareTire]

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.

[cognos4321]

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.