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
Quote from: br54016 on 16 Jul 2014 08:54:36 AM
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.
MF,
Thanks for the quick response, that was the issue.
Brad