Oracle

Achieving Data Copy Functionality in “Planning in Oracle EPM Cloud” ASO Reporting Cube

Website Design. Developing Programming And Coding Technologies.

It is standard practice to use the DATA COPY function to copy actuals for the current and previous months to forecast in BSO cubes to support the forecasting for the business FP&A departments. When it comes to ASO cubes it’s a little bit challenging with the combination of MaxL script to invoke a calc script to provide the same functionality. It has been made easy in Oracle Planning and Budgeting Cloud (PBCS) through the graphical rule in calculation manager using the formula object by choosing the appropriate Point of View.

Below are the steps I have followed to achieve the functionality:

Application Name:           Vision

Cube Name:                      VisASO

Picture1

Navigator -> Click Rules under Create and Manage -> ASO Cube -> Right Click on Rules and Click Create.

Picture2

Calculation Manager window opens.

Under System View expand ASO cube and select Rules. In this scenario VisASO is the cube name. A new Rule can be created either by right click and choose “New” or Selecting the Action drop down menu and select “New Object” as below (Either one of the below).

Picture3

Provide the Name to the Rule, make sure the Application Type, Application & Cube name are appropriate and click OK as shown below.

Picture4

By clicking OK button in the above screen will result into the below screen where the POV can be chosen.

Picture5

By clicking the Member Selector would provide the option to choose the Variable, Member or a Function.

Picture6

I chose to use the Function and used the function @FilterSharedAndDynamic to filter the Dynamic Calc Members and the Shared Members. I then repeated the same for the dimensions Account, Entity, Product, AltYear dimensions. I used the specific period for the Period dimension and the Substitution Variable “CurrYear” for the Year dimension.

The screen caps below display these steps.

Picture7

Picture8

Picture9

Once the POV is selected both Begin & End will display as above. Now drag and drop the Formula object from the New Objects on the left upper corner to the right-side window in between Begin & End objects as below.

Picture10

Select the Formula Object and enter the formula as below.

RHS: Source

LHS: Target

Copy the data from Actual, Final to Forecast,RF1_11 version.

Picture11

Picture12

Once the POV and Formula are satisfying the criteria please validate, save and deploy the rule.

Picture13

Picture14

I have used the below sample set of data where I have the Level0 data for Actual, Final exists to test the intended functionality is displayed in SmartView.

Picture15

Now I have executed the Copy_Actuals_RF1_11 rule.

Picture16

I refreshed my SmartView sheet and I am able to see the data in Forecast, RF1_11 version for FY20, Jan.

Picture17

With these simple steps I am able to achieve the copy functionality in ASO similar to BSO.

 

 

 

 

About the Author

Ashok Raya is a Lead Technical Consultant in Perficient’s Corporate Performance Management Practice. As an accomplished Hyperion Applications Consultant, he is experienced in analyzing, designing, developing, implementing, and supporting Hyperion Suite of tools including Hyperion Essbase, Hyperion Financial Reporting, Hyperion Planning, Planning in the Oracle EPM Cloud, Business Intelligence, and Oracle ERP (EBS).

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories