Hi All,
Created a new 'Date_Rpt' dimension in Architect with TI process. I would like to set the hierarchy levels to this 'Date_Rpt' dimension for Cognos BI reporting.
Problem: the dimension is not visible in }HierarchyProperties control cube. ( It is visible in "all" subset of the "}Dimensions" dimension. Restarted the TM1 services, and no zero suppression by cube view.)
Any ideas?
Thanks in advance for all answers.
New dimension is not visible in }HierarchyProperties cc
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: New dimension is not visible in }HierarchyProperties cc
}Dimensions is the dimension for }HierarchyProperties cube. if you can see it in the }Dimensions, it should show in the cube. Could you post a snapshot?
- Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: New dimension is not visible in }HierarchyProperties cc
When looking at the }HierarchyProperties control cube, are you looking at a named (saved) view? If so, could it be that the new dimension entry is just not yet included in the displayed subset on the "}Dimensions" dimension in that view? To correct this, open the subset editor from the view and click All to display all elements - save the view again to make the selection permanent.Tibor wrote:Problem: the dimension is not visible in }HierarchyProperties control cube. ( It is visible in "all" subset of the "}Dimensions" dimension. Restarted the TM1 services, and no zero suppression by cube view.)
When talking about Zero Suppression - could it be that you have zero suppression active on rows only (not directly visible on the zero suppression icon in the Cube Viewer)?
Michel