Topic
  • 3 replies
  • Latest Post - ‏2012-10-09T21:58:42Z by nishu85
nishu85
nishu85
8 Posts

Pinned topic Cube Dimension Expansion

‏2012-10-09T13:48:39Z |
Hello All

This may be a simple question. I am trying to expand a cognos cube to 4th level and the option to expand is greyed out. Is this expected or do I have to make any changes to my cube to allow for expansion beyond 3 level of any dimension ?

Thanks
Nishant
Updated on 2012-10-09T21:58:42Z at 2012-10-09T21:58:42Z by nishu85
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Cube Dimension Expansion

    ‏2012-10-09T19:22:48Z  
    It looks like you are using Analysis Studio. In this studio you will be limited to 3 levels from a single dimension. The purpose of Analysis Studio is to allow fast analysis of the data and this means that your activities should be focused on slicing the data and using tools such as top and bottom counts to identify the relevant values which need to be actioned. If you need to output large data volumes or low-level details then you would be better off using a tool which is intended for this type of task such as Business Insight Advanced, Query Studio, or Report Studio.
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: Cube Dimension Expansion

    ‏2012-10-09T21:56:17Z  
    Have a look at http://www-01.ibm.com/support/docview.wss?uid=swg21495975 In particular the nesting section.
  • nishu85
    nishu85
    8 Posts

    Re: Cube Dimension Expansion

    ‏2012-10-09T21:58:42Z  
    Thank you. This makes sense. I was just trying to make sure that I am not missing out any new functionality if introduced.

    Thanks
    Nishant