Introduction of new EPM Automate Command "essbaseBlockAnalysisReport"

In April-2024 update, Oracle has introduced new EPM Automate command and REST API to creates the Essbase Block Analysis report that helps you analyze the 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 report provides information on these three areas:

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

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

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

In this blog, we will talk about the new  essbaseBlockAnalysisReport command only. Required Roles to run this command is Service Administrator. This command applies to Financial Consolidation and Close, FreeForm, Planning, Tax Reporting.

How to use -

epmautomate essbaseBlockAnalysisReport EXPORT_DATA_FILE.zip REPORT_FILE

where -

• EXPORT_DATA_FILE.zip is the name of the zip file that contains the Essbase data that was previously exported from of a BSO cube using the exportEssbaseData command.
• REPORT_FILE is the name for the HTML formatted Block Analysis report file.

Note:
Before running this report, use the exportEssbaseData command 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. Run this command to create the Block Analysis report for this zip file. The report is created in the outbox; you can use the downloadFile command to download it to a local computer or the sendMail command to email it.

Example

epmautomate essbaseBlockAnalysisReport Plan1_cube_data.zip block_report.html

Thank you!

How FCCS View dimension helps in improving the performance of data loads!

How FCCS View dimension helps in improving the performance of data loads!

In FCCS Application- Under View dimension, there are three members under a parent member “FCCS_View_System Members”: “FCCS_QTD_RULE”, “FCCS_HYTD_RULE”, and “FCCS_YTD_RULE”. 

Details -

FCCS provides an Application Settings option to disable View calculations. By Turning this setting to "Yes" -

1. This option disables computation and storing of YTD, HYTD, and QTD data for data input (through forms, data import, Data Management, and so on) in the YTD, HYTD, and QTD members. 

2. Turning this setting to "Yes" will help in improving the performance of data loads.

3. Once data is loaded, ese the required YTD_RULE, HYTD_RULE, and QTD_RULE members to see the respective View data after data load. 

4. Data will not be populated and updated in the YTD, HYTD, and QTD members after data load.

To disable View calculations:

1. Click Application, and then click Settings.
2. Set the Disable To-Date View Calculations option to Yes.
3. Load data.
4. Use the YTD_RULE, HYTD_RULE and QTD_RULE members to see the YTD, HYTD and QTD data.

However, if there is requirement to use the YTD, HYTD, and QTD members, you will have to run the Update View Calculations rule for all the Scenario/Year/Period/Entities for which data was loaded when this option was set to "Yes", and pass QTD, HYTD, and YTD as parameters so that the values are correctly computed and stored.

This will make sure future data loads will correctly populate the "Never Share" YTD, QTD, and HYTD members.

Update View Calculations rule can be run at any time, regardless of the calculation status.

To update View calculations:

1. On the Home page, click Rules.
2. From the Business Rules list, select UpdateViewCalculations.
3. Select or enter dimension members for Entities, Period, Scenario, Year, View, and Currency, and click OK.
4. Click Launch to run the rule.

   
   

Thank you!