ASO MDX Data copy
Summary
ASO MDX data copy script is taking hrsContent
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))})))))))"
1