REST API to Generate an Essbase Block Analysis Report

You can now use a REST API to generate an Essbase Block Analysis report that helps you analyze Oracle Essbase data to support the tuning of Block Storage Option (BSO) cubes (generally, used for calculations) in your application. The report provides information in these areas:

  • Percentage of blocks with only Zero: Shows the blocks that contain only zeros as a percentage of all the blocks contained in the export file.
  • Top 10 Repeated Numerical Cell Values By Percentage of Numerical Cells: Shows the top 10 repeated values as a percentage of all the values in the export file.
  • Top 100 Dense Member Combinations with Repeated Values: Shows the top 100 dense combinations with repeated values in the cube. The "Cell Value" column shows a value for each member, in the order it appears in the hierarchy, as a different column. For example, if Period is across the column, there will be a different column for January, February, and so on. Other dense dimension(s) appear in the rows. This should help you identify the locations of the repeated values.

Business Benefit: The Essbase Block Analysis report is helpful to resolve performance issues resulting from patterns of data; for example, repeated numbers in Essbase BSO cubes.

Tips And Considerations

Benefit from the Implementation Best Practices for EPM Cloud REST APIs in REST API for Oracle Enterprise Performance Management Cloud.

Key Resources

Access Requirements

Service Administrators