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

Model Ragged/Unbalanced Hierarchy

Started by wyconian, 03 Jun 2009 06:06:23 AM

Previous topic - Next topic

wyconian

Morning all.  I think I already know the answer to this but does anyone know of a way to model a ragged or unbalanced hiearchy in FM?

The situation is this;

I have some data items that can be modeled as a hierarchy, the problem is I don't know how many levels there are and different instances of the data item can have different numbers of levels.

Any help appreciated as always.

Thanks

Simon

blom0344

Quite often ragged hierarchies are caused by some sort of recursion in the data-structure. The most widely used example is that of the manager-employee relationship. It is possible to unravel such a structure by means of an ETL proces or a recursive SQL view, but nevertheless if you want to model this in FM you will still need to assign the levels (and know how many there will ultimately be)

From what we gathered on DMR ragged dimensions are a no-no. This is still a drawback compared with the 'old' C7 cube technology.
An unbalanced hierarchy (different depth of levels) should be possible, but I suspect you need that you do need to repeat the lowest leaf member to the deepest level that exists in the model. 

wyconian

Thanks Blom that's pretty much the conclusions I was coming to