View Single Post
  #1 (permalink)  
Old October 6th, 2006, 04:45 AM
Dima20 Dima20 is offline
Registered User
 
Join Date: Oct 2006
Location: Sankt Petersburg, , Russia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Recursive Relationships with MDX

There is an example in SQL Server 2005 Reporting Services book how to build a table with recursive hierarchies. In this example SQL query is used for creating table with EmployeeID and ManagerID columns.
 I have a cube with Organization Tree dimension. Each item of organization tree (cost place ) has unique OrgID and Parent ORGID. The number of levels can be different for each branch : e.q.
1
 1.1
 1.2
    1.2.1
    1.2.2
 1.3

 It seems that using Recursive Relationships to be a solution for my task. Is it possible to get it using MDX and how that MDX can look like ?

Thanks in advance.