Oracle PBCS CLEARCUBE – PART 2

As promised in Part 1 of this series I will run through how to use this functionality in this blog post.

We will cover the below items in this blog post:

 

• Setting Up Basic Clear Cube Job in PBCS
• New EPM Automate Utility Version with CLEARCUBE command

• New REST API: Clear_Cube

• Planning Clear Cube Job Now Clears Relational Data and Essbase Data

Setting Up Basic Clear Cube Job in PBCS

Setup Clear Cube Definition

In the Overview section in PBCS, from the menu you are able to create a clear job. This is covered in more detail in my previous blog post Clearing Essbase ASO Cubes in PBCS. This will work setting up clear cube definitions for ASO and BSO, but with the ASO we get the ability to do a partial clear (including advanced capability for MDX entry).

Setup Clear Cube Job

This is one of those tasks you will need to do both to test is working and that is also set as a job that can be called from EPM Automate or directly from the REST API.

EPM Automate CLEARCUBE Command

Download & Install Latest EPM Automate Version

Download & Install Latest EPM Automate Version should be downloaded from PBCS Pod with version 17.07 or higher.

Running the EPM Automate Clearcube command

The command for EPM Automate is epmautomate clearcube JOB_NAME.

For me I used the following to match clear definition in PBCS:

epmautomate clearcube Test_Clear

New REST API: Clear_Cube

You can use any simple REST Client to test this. The command for the rest api is: {“jobType”:”CLEAR_CUBE”,”jobName”:”<jobName>”}

For me I used the following to match clear definition in PBCS: {“jobType”:”CLEAR_CUBE”,”jobName”:”Test_Clear”}

Planning Clear Cube Job Now Clears Relational Data and Essbase Data

Previously you could only clear Essbase data. To view the updated Clear Cube job options, click Application, then Overview. From the Actions menu, select Clear Cube. On the Clear Cube page, click Create, complete the job name, select the cube, then select from the clear options displayed. Oracle has also provided two modes for clearing partial data for aggregate storage cubes. Selecting Partial Data (Basic Mode) enables you to use the member selector to specify the regions to be cleared. Selecting Partial Data (Advanced Mode) enables you to clear Essbase data by using an MDX expression in the text box provided.

 

THE FORCE IS WITH YOU……HYPERION JEDI….

Advertisement