If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Can parent of category be displayed in Analysis Studio report?

Started by cccschip, 02 May 2012 12:36:48 PM

Previous topic - Next topic

cccschip

We have dimension (Account) in which the top-level is an institution and the 2nd level contains some subset of known possible values (say 10, 20, and 30), each institution using only those that are applicable.


Accounts
+ InstA
  + 10
  + 30
+ InstB
  + 10
  + 20


We include only the '10' accounts in the analysis and get the report one would expect:


      Assets
10       $65
10       $53
Total   $118


But its' not very useful because we can't see the parent institution!

We want something like:


           Assets
InstA 10      $65
InstB 10      $53
Total        $118


How might we force the display of the Institution (which is the parent of each of the displayed categories)?

Or, putting it in more general cube terminology, how can we display the path to the "10" categories?

cognostechie

How about nesting the '10' accounts under the Institution? The 1st row will be Institution and the 2nd row will be the '10' accounts (2nd level of that dimension).

cccschip

We find that we can do just that (nesting), but only if Institution is a separate dimension from Account. 

In this case, it is merely the top level category of the one "Account" dimension.  And I am unable to drag the Account dim into the Row def a second time.  Am I missing something?


cccschip

I've done more reading and learned that I can use the Expand feature on a dim (used in Rows or Cols) to instruct Cognos to create a "Combination" dim...in which two adjacent levels of the dim are displayed side-by-side.  That works in this case, though it is not quite as general as I'd like.  What if we wanted to display even more levels?  Or levels that are not direct relations to each other (i.e., the 2nd and 5th levels)?

I also have found IBM doc stating that Cognos supports "the nesting of up to 3 levels of a single dim".  But, for the life of me, I can only get two with the Expand and find no other ways to attack this.