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

variable depth hierarchies

Started by mgraham, 15 Aug 2007 08:06:13 AM

Previous topic - Next topic

mgraham

Re. variable depth hierarchies.

We have a standard parent child relationship for customers/companies. Does Framework have a method to handle thisi type of hierarchy or do I have to create flat dimension tables with the inbuilt hierarchy generated using SQL.


Any comments.
Much appreciated.
Mark

MFGF

Hi Mark,

There is no functionality in Framework Manager explicitly designed to handle unbalanced/ragged/recursive hierarchies.  Typically these would be best resolved before modelling the data in FM.  ETL tools such as Data Manager have the required technology for resolving these kinds of issues.

Best regards,

MF.
Meep!