Measures from TM1 Cubes are not displayed in Report Studio

[Bindiya]

Hi All,
We are trying to connect to TM1 cubes and develop some Report studio reports (Cognos version 10.2).

We have around 11 dimensions and 2 measures in cube.
When I pull all 11 dimensions and one measure into a list, the measure values are displayed.
But, when I pull only one dimension and one measure into a list, the dimensional values are displayed but the measure is all blank. What should be done to fix this?

Any inputs would be helpful.
Thank you all.

[MFGF]

Hi All,
We are trying to connect to TM1 cubes and develop some Report studio reports (Cognos version 10.2).

We have around 11 dimensions and 2 measures in cube.
When I pull all 11 dimensions and one measure into a list, the measure values are displayed.
But, when I pull only one dimension and one measure into a list, the dimensional values are displayed but the measure is all blank. What should be done to fix this?

Any inputs would be helpful.
Thank you all.

Hi,

What you are seeing here is a result of the design of the TM1 cube you are using. In most OLAP technologies, hierarchies are defined with a single member at the top (Apex member), and these Apex members are flagged as being the Default Member of that dimension. When you write a report from a cube designed in this way, it is doing some nice things under the covers to help you. If you bring in a specific member from a dimension along with a measure, the cube is actually returning the measure value for that member in the dimension you included, and for the Default Member of every other dimension (even though you didn't reference them). It makes sense if you think about it - if you bring in a measure for (say) a Customer, and your other dimensions are Products, Time and Locations, you end up seeing the measure value for your specified customer for all time for all products for all locations.

I'm willing to bet that in your situation, you don't have apex members for some (or all) of your hierarchies. This means there is no Default Member for those dimensions. Unless you pinpoint which member(s) to use from these dimensions, the report cannot return a value for the measure. If (say) you have a Years dimension with a top level of Year and there are 20 year members in it, which of these should the report use? The first? Last? Some other choice? It can't just assume - so you need to tell it. If you don't want to show the year directly in your report, you can simply drag the relevant year member to the Context area at the top of the report. Repeat for each other dimension without an apex member, and you will then see a result for your measure.

To change this behaviour, you would need to re-design your TM1 cube to have an Apex member for each hierarchy. Sometimes this is straightforward, but if you have a cube used for planning, and there is a Scenario dimension, for example, it wouldn't make sense to have an apex and roll all scenarios up to a grand summary. In this case you'd always need to specify the desired scenario in your report to see measure results.

Cheers!

MF.

[Bindiya]

Thank you for the inputs.
I will check if we have default members specified for all dimensions in TM1.

[Bindiya]

Yes you were right. We did not specify the default members. Adding them resolved the issue.
Thank you so much:)

[Bindiya]

I am running into an issue where measures are not properly getting rolled up in Report Studio with TM1 cube. When I tried the same scenario with one of the sample cube, they are getting rolled up as intended. I tried it both on list and crosstab. Please see the attachment for details. Could there be any measure rollup properties that could be set on TM1 side?