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.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 the application will be impacted if the database is fragmented.
To restructure a cube:
- Sign in to Tax Reporting as a Service Administrator.
- On the Home page, click Application and then Jobs.
- Schedule and run the Restructure Cube job right away.
Alternatively, you can schedule the job to start at a later time.
- a. Click Schedule Jobs.
- From What type of job is this?, select Restructure Cube.
- 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.
- a. Click Schedule Jobs.