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
Tm1 and Cognos Report Studio
- 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
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
-
- 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
Thank you very much. That's exactly what I need.
- 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
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