Perform Regular Housekeeping

A Service Administrator must perform needed housekeeping tasks on a regular basis to guard against performance degradation. Tuning the Oracle Essbase by regularly removing unnecessary data blocks and ensuring that data block structure is stored efficiently are essential for optimal consolidation performance.

Note:

You may run the restructureCube EPM Automate command to remove empty blocks and restructure the cube.

Clear Empty Blocks

Clearing empty blocks helps optimize database calculation speed. For example, if an initial calculation creates numerous consolidated level blocks, subsequent recalculations take longer, because the calculation must pass through the additional blocks.

To clear empty blocks:

1. Sign in to Financial Consolidation and Close as a Service Administrator.
2. In the Home page, click Rules.
3. In the Business Rules tab, click Launch in the ClearEmptyBlocks row.
4. In Business Rules, select the scenario, year, and period for which empty blocks are to be cleared.
   
   
5. Click Launch.
6. Run consolidation.

Restructure Dense Cubes

Data fragmentation occurs naturally in Block Storage (BSO) databases as a result of end user data updates, incremental data loads, and executing calculations. The performance of Financial Consolidation and Close application will be impacted if the database is fragmented.

To check if a cube restructuring is required:

1. Sign in to Financial Consolidation and Close as a Service Administrator.
2. On the Home page, click Application and then Consolidation.
3. Launch Oracle Hyperion Calculation Manager by clicking Final Calculations.
4. In Calculation Manager, click Database Properties .
5. In the left pane of Database Properties, expand EPM Cloud, then the node of your application, and then click Consol.
6. In the right pane, click Statistics.
7. Check the value of Average clustering ratio. If the displayed value is 1.00 (maximum) or close to it, a restructuring is not required. If the value is much lower, for example, 0.01032828, you must restructure the cube to defragment it.

Before running this command, ensure that no one is using the application.

To restructure a cube:

1. Sign in to Financial Consolidation and Close as a Service Administrator.
2. On the Home page, click Application and then Jobs.
3. Schedule and run the Restructure Cube job.
   1. Click Schedule Jobs.
      
      
   2. From What type of job is this?, select Restructure Cube.
   3. Select Run Now to start the restructuring immediately. Click Next, and then Finish. Alternatively, you can schedule the job to start at a later time.