Tm1 and Cognos Report Studio

Post Reply
fabpas
Posts: 18
Joined: Fri Feb 01, 2013 9:59 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: Switzerland, Estavannens

Tm1 and Cognos Report Studio

Post 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
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Tm1 and Cognos Report Studio

Post 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.
Kamil Arendt
fabpas
Posts: 18
Joined: Fri Feb 01, 2013 9:59 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: Switzerland, Estavannens

Re: Tm1 and Cognos Report Studio

Post by fabpas »

Thank you very much. That's exactly what I need.
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Tm1 and Cognos Report Studio

Post 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.
Kamil Arendt
Post Reply