We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ASO Data copy

Received Response
6
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

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])"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!