ASO Cube Optimization
Summary:
We are experiencing performance impact in ASO Cube for Custom Workforce application.
Content (please ensure you mask any confidential information):
We have a Planning application with 14 dimensions using a WFP solution, consisting of both a BSO cube and an ASO cube. We push data from BSO to ASO to support Narrative Reporting (NR) reports. Attached is a screenshot showing the dimensionality and member counts. All dimensions are set to Store Data in both the BSO and ASO cubes.
In the BSO cube, forms at the Total Entity level open successfully (though they take some time). However, the same forms and NR reports against the ASO cube take significantly longer and often time out when opened at the Total Entity level.
1