SQL Server Performance Forum – Threads Archive

Parent-Child dimension but with multiple levels

Hi, This is about the example Foodmart database that comes with Analysis Servcies… The approach used for creating the accounts dimension (in the example database) is basically what I am referring to but the difference is that in my case I have multiple levels rather than just 2 levels (as in the example). Let me explain this more: The example database has 2 levels in the underlying table and each "non-root" record points to a parent. I want to use the same approach but in a case where I have more than 2 levels… A chart of accounts is the best example that I can think of. Can someone please guide me how I can achieve this and be able to use the parent-child dimension making apporach. Really urgent and am posting this after applying all that I could think of and after going through many hours of research on the web [<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />] Please let me know if this requires more elaboration… I’ll be glad to do so.

Refer this
http://www.nigelrivett.net/RetrieveTreeHierarchy.html Madhivanan Failing to plan is Planning to fail

]]>