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
-- show only items with qoh less than arws
-- for non-leaf items, sum the results of the previous calculation
sum([products].currentmember.children ,[Loss Sales Stock]) )
I will appreciate response please.
1 post • Page 1 of 1