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