Below is an example of MDX syntax used on our DTS, but I observed that it takes ages to complete, I want alternative way of doing it.
Any idea or can you link me up with a user group where I can post the challenge?
Note the name 'Loss Sales Stock' is the name of this syntax itself defined in the analysis manger; while the other measures are QoH and arws. the dimesions is products
-- restrict this calculation to LEAF (lowest level) items - ie sku
iif( isleaf([products].currentmember),
-- show only items with qoh less than arws
iif([QoH]-[arws]<0,([QoH]-[arws]),null),
-- for non-leaf items, sum the results of the previous calculation
sum([products].currentmember.children ,[Loss Sales Stock]) )
I will appreciate response please.
MDX taking ages to run - alternative solution
-
- Posts: 1
- Joined: Fri Feb 19, 2010 7:02 am
- OLAP Product: TM1
- Version: version 9
- Excel Version: 2003