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 
Ideas worth spreading: TED Monday, February 11, 2008
Posted by kalyanimath in Ideas.Tags: Ideas
add a comment
Not very often i get to a web page and wished I had seen it before, I recently stumbled upon TED and had one of those missed moment.I am captivated by this site. There is something alluring about hearing people talk about that someonething they are passionate about.
It is exteremly hard to generalise people talking about Giant SunFish to people talking about Mining the moon, But for me all of these people showed one common trait and that was – having that inextinguishable, unceasing appetite for learning.
I hope to some extent i can live by like that 
