ASO Performance Optimisation - Data Management - Data Load Rules

Summary:

ASO Performance Tuning post Application Migration.

Content (required):

We have migrated from one ASO cube [A] (one application, one cube) to another ASO cube [B] (one application, 2x cubes - 1 ASO and 1 BSO).

The challenge we are facing is that we have a Data Load Rule (DLR) from ASO Cube A for a given month running in 2-3mins with 100k records of data. By comparison, the DLR from ASO Cube B is running for 15mins with 170k records of data. There are more records of data as there are an additional 3 dimensions. This timing had initially come down from 45mins after updates were made to the Hierarchy Types. We have also Merged Data Slices and Optimised Aggregations with negligible improvement.