Essbase Block Analysis

This section describes the REST APIs for simulating user activities for testing purposes.

Use this REST API to create an Oracle 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 Essbase Block Analysis report is helpful to resolve performance issues resulting from patterns of data; for example, repeated numbers in Essbase BSO cubes.

The Essbase Block Analysis 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.

• Percentage of cells with only Near Zero Values: XX.XX%, which displays the percentage of cells with near-zero values (such as 0.000000001604) in blocks.

• 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.

Before executing this API, use the Export Essbase Data (v2) API to export the data from the cube for which you want to create the Block Analysis report to a zip file. You may export level0 or all data as needed. Execute this API to create the Block Analysis report for this zip file. The report is created in the outbox; you can use the Download API to download it to a local computer or the Send Email (v1) or Send Email (v2) API to email it.