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.
|