MDX taking ages to run - alternative solution

Post Reply
Patrick Ogundipe
Posts: 1
Joined: Fri Feb 19, 2010 7:02 am
OLAP Product: TM1
Version: version 9
Excel Version: 2003

MDX taking ages to run - alternative solution

Post by Patrick Ogundipe »

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