Summary

ASO mdx data copy is hrs

Content

Hi All,

I have an MDX script which will copy data from one member to other member it is taking 3 hours to complete the script..

is there any way to optimize the MDX or any other way to write it 

execute allocation process on database app.db with
pov
"CROSSJOIN ({Descendants([Net Income],[Account].Levels(0))},
CROSSJOIN ({&PCMCSYearRange},
CROSSJOIN ({Descendants([YearTotal],[Period].Levels(0))},
CROSSJOIN ({Descendants([Total Cost Center],[Cost_Center].Levels(0))},
CROSSJOIN ({Descendants([Geography],[Geography].Levels(0))},
CROSSJOIN ({Descendants([Source Segment],[Source Segment].Levels(0))},
CROSSJOIN ({Descendants([Segment],[Segment].Levels(0))},{Descendants([Project],[Project].Levels(0))})))))))"
amount "([GBP_Calc],&PCMCSScenario,[No_Custom1])"
target "([GBP],&PCMCSScenario,[No_Custom1])"
range ""
spread;

  -Vijay

Version

11.1.2.4