Hierarchy Management and Decision Making Tuesday, March 4, 2008
Posted by kalyanimath in Ideas, Microsoft.Tags: Hierarchy Management, MDM, SQLServer
add a comment
General Ledgers, Chart of accounts, Cost centers, Organisational Structure, Product lines, Sales Territory … the list of these Enterprise lists are far too many too mention, Hierarchy management in BI is essentially the discipline of defining and manipulating these enterprise data lists for the purpose of improving analysis of business processes and stream line the process of information integration.
Found an excellent article at tdwi talking about how an abstracted analysis layer for hierarchies can help organisations maintain competitive advantage by opening new realm of flexible analytics by allowing its business users to create their own alternate views of the organization and ask questions.
A powerful, flexible Hierarchy Management is one of the most important & interesting module of an MDM. One of my biggest qualms when designing a MDM in the SQLServer 2000/ 2005 was the lack of an efficient way to store & traverse data stored in tree structures, SQLServer 2008 is now sporting a new Data type called HeirarchyId. This will make our job so much easier, phew 
