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
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.