}HierarchyProperties

[Wim Gielis]

Hello,

Does anyone know if we can use the above control cube in MDX statements in plain TM1 ? If I read this page:

https://www.ibm.com/support/knowledgece ... n0274.html

You can assign your own custom names to the hierarchy levels of the TM1® dimension by using the }HierarchyProperties control cube. The named levels you create can then be used when you externally access TM1 data with IBM® Cognos® Report Studio, MDX statements or other MDX OLAP tools. You can also assign a default member for the dimension.

Or would it mean MDX statements outside of TM1 ?

I tried syntax like:

Code: Select all

{[Period].[Quarters]}

where Quarters was defined in the }HierarchyProperties cube, after which I ran

Code: Select all

RefreshMdxHierarchy('Period');

in TI.

Thanks !

[gtonkin]

Hi Wim,
I happened on your post whilst trying to do something similar today.
I managed to get something returned using this syntax

Code: Select all

 { [<Dimension>].[<Level Name>].Members} 

Unfortunately my dimension contains 6 hierarchies and each level within the hierarchies have unique names - I was hoping to use the }HierarchyProperties to name my levels more as a reference and to keep my sanity in check.
From what I see in the }HierarchyProperties cube, I would need to add additional hierarchy elements alongside hierarchy0 so that I can input my level name against the associated hierarchy for the dimensions.
The next step would be seeing if it is possible to query a level for a particular hierarchy. Right now the code above brings back elements from each of the hierarchies.
Hope the MDX helps you at any rate.