loaded my pod with… Sunday, March 30, 2008
Posted by kalyanimath in Personal.Tags: Personal, running
add a comment
the top 10 songs from iTune store and I ran the Run for the Kids 2008.
This was my first “long distance” run and running in a sea of red shirts (30,000 to be correct!) was incredible.
The atmosphere, the people, the views, the tunnel, the bolte bridge, It was so worth it and the money goes to such a worthy cause. Probably my sore legs wont agree at the moment but both my mind & body want to surely do this again, hell yeah!
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 
