Hyperion Essbase (MOSC)

MOSC Banner

Extract All Levels Data from ASO Cube

I have a requirement to extract all data from ASO (All levels data till rollup parent), I am trying to do through report script but it is taking more than 5-6 hours. I have attached Report script was used for fetching all data from ASO cube. Please suggest a better way to make fetch all level data from ASO.

Also, I went through some blogs, and got to know MDX works faster than Report script in fetching data. Can you help with MDX query based on the criteria shared in Report script.


Here is the report script:

========================================================

//ESS_LOCALE English_UnitedStates.Latin1@Binary

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center