There was an issue reported from user that a small sheet with 15 rows and 6 columns from reporting cube (ASO) is taking around 6 minutes to retrieve and getting timed-out We tried from our end couple of times and identified that it was sporadic and tried all possible options to fix it. Sometimes, it retrieves very quickly and sometimes it takes a huge amount of time. Option 1: Outline size was around 200MB and we compacted the outline which brought down the outline size to 22 MB. But, this didn't work Option 2: We cleared aggregations (We were very sure that this will not improve performance). It didn't work Option 3: We have a database where we capture all our metadata and data loads with start time, end time and elapsed time. We noted down the times when the retrievals were faster and looked in to the database to find what process were run before the retrievals. We found that whenever a dimension build process is completed, the retrievals are faster but after that
My Knowledge... My Expericence... My Tips & Tricks... All around Oracle EPM Product Suite and Analytics as a whole