ASO MDX formula optimization or different method
Hello All,
We have an ASO application where we have requirement that level zero members should be mulitply the value according to formula and the parent member should be summed .for Example
in the below formula it shows for the level zero members it is should perform cu cumulative * Production units for the extended cost up and for the parent level it should sums the level 0 data to the Extended cost up
case
when
islevel(period.currentmember,0) and
islevel([Destination].currentmember,0) and
islevel([ModelYear].currentmember,0) and
islevel([Version].currentmember,0) and
islevel([Parts].currentmember,0) and
islevel([Supplier].currentmember,0) and
islevel([PMSCategory].currentmember,0) and