Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
ASO Performance Optimisation - Data Management - Data Load Rules — Cloud Customer Connect
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 Performance Optimisation - Data Management - Data Load Rules

Received Response
41
Views
8
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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