Cognos 10.2 with SSAS Data Source, Hierarchy Issue

[br54016]

Created a SSAS 2012 cube, a data source in Cognos and a package.  The dimension hierarchies function properly in Excel.  When I use one of the studios in Cognos the dimensions display a separate hierarchy for each level and I am not able to drill from level to level.

Note: First SSAS cube, it's possible that I'm missing something in the hierarchy definition.

Screenshot attached

Thanks,
Brad

[MFGF]

Created a SSAS 2012 cube, a data source in Cognos and a package.  The dimension hierarchies function properly in Excel.  When I use one of the studios in Cognos the dimensions display a separate hierarchy for each level and I am not able to drill from level to level.

Note: First SSAS cube, it's possible that I'm missing something in the hierarchy definition.

Screenshot attached

Thanks,
Brad

Yep - I have seen this, and it's normal. To get the hierarchy structures you hope for in Cognos 10, you need to set up User Defined Hierarchies in Analysis Services and hide the standard hierarchies.

Cheers!

MF.

[br54016]

MF,

Thanks for the quick response, that was the issue.

Brad