THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

MDX-Optimizing operation on leave level

Last post 07-17-2008, 10:19 by tomas olejar. 0 replies.
Sort Posts: Previous Next
  •  07-17-2008, 10:19 7882

    MDX-Optimizing operation on leave level

    Any hint how to optimize operation on leave level, e.i. I have a margin on leave level & product dimension (parent-child) & organization (parent-child), I need to have a margin on the parent, so I wighted margin with a balance on leave level & divide a balance on parent. I need to leave sum aggregation on margin because of writeback.

    Code:

     sum(descendants([Product].[Product].allmembers,,leaves),sum(descendants([Organization].[Organization],allmembers,,leaves),&&operation&&))

     

    Thanks,

    tomas 

    Filed under: ,
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement