p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 (http://p2p.wrox.com/forumdisplay.php?f=251)
-   -   Recursive Relationships with MDX (http://p2p.wrox.com/showthread.php?t=48706)

Dima20 October 6th, 2006 04:45 AM

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.



All times are GMT -4. The time now is 01:31 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.