Page 1 of 1

Tm1 and Cognos Report Studio

Posted: Mon Jan 20, 2014 4:22 pm
by fabpas
hi all,

I am not sure if this forum is appropriate for my question. As I don't know the answer, don't blame me too hard!
I have a data source with is TM1 for my reports in Cognos Report Studio. When doing a query in RS, I may or may not specify elements for each of the dimensions.
I heard the concept of Default member for when I don't specify an element for a given dimension. Can someone tell me more about that? Where do I specify the "default" member for a dimension? Is that in TM1 or in Cognos RS?

Thx for your help,
fabrice

Re: Tm1 and Cognos Report Studio

Posted: Mon Jan 20, 2014 4:44 pm
by qml
You specify that default element on the TM1 side. Find the }HierarchyProperties cube in your model and in it set the defaultMember property for a given dimension to be your default element name.

Re: Tm1 and Cognos Report Studio

Posted: Mon Jan 20, 2014 4:50 pm
by fabpas
Thank you very much. That's exactly what I need.

Re: Tm1 and Cognos Report Studio

Posted: Mon Jan 20, 2014 4:54 pm
by qml
Pleasure. One more thing - you will probably have to run RefreshMdxHierarchy('Dim') function in TI after setting the default members for this to kick in.