Requesting Essbase Block Analysis Report

The size of BSO cubes is an important factor in Oracle Essbase performance. Usually, a bigger size cube performs less efficiently than a smaller cube. It is not easy to determine the data patterns in a BSO cube to clear unnecessary data.

To identify data patterns in BSO cubes, you can create the Essbase Block Analysis Report that shows the patterns of your data (for example, 0s, repeating numbers, and so on). Such a report will help you clear the unnecessary data and reduce the size of BSO cubes. You create this report using these resources:

• essbaseBlockAnalysisReport EPM Automate command
• Essbase Block Analysis Report REST API

If, for some reason, you cannot create the Essbase Block Analysis Report, you can request Oracle to provide it by completing these steps:

• Create a Provide Feedback submission from the environment for which the report is required. See Creating a Provide Feedback Submission.
• Create a technical service request. See Submitting a Technical Service Request. In the service request, specify the Provide Feedback reference number.