Tuesday, March 25, 2014

Planning 11.1.2.3 (3) - ASO and Forms

Starting with the 11.1.2.3 release, Planning can now have plan types which use ASO cubes. You can write back to the ASO database and set up forms against an ASO database. After the data is input in ASO zero level members, the parent level doesn't need to run any business rules to roll up, they can do it automatically and the performance is good even for the large dimensions. For BSO, it cannot roll up data automatically for parent members and the business rules' aggregation speed is quiet low for large dimensions.
04-01
But for ASO cubes, you can't define any business rules in the calculation manager. Business rules are only served for BSO applications.04-07
One thing bad I want to say is the page dimensions in the form. From version 11.1.2.2 Planning change its UI to ADF view, and then the page dimensions displayed very dim. And the worst thing is that you can't see the full set of it when the member name/alias is too long, the only way you can see the full name is to select the page member, and then put your mouse over it. I was complained by the clients for many times on this place but what I only can say is Smart View has no this problem...
04-02
From the release 11.1.2.2 as well, form's data can be displayed as chart but only for the composite forms. In the composite form design mode, you can set the form to display as chart.
04-03
Then select the chart type, similar types as other BI tools.04-04
And then you can find the form's icon changed to a chart.
04-05
The display results as below, seems not to bad.04-06

From release 11.1.2.2 as well, cells input history can be viewed in web form. This feature should be enabled first. Tools > Reports


Switch to Auditing page, check "Data" and then Save the Selections

Now all the changes of cell's data will be recorded. Right-click of the cell, click Show Change History.


All the change history will be shown as below.


Another feature starts from 11.1.2.2 is "Map Reporting Application", it allows you to push data from planning databases to another Essbase database. Look the example below, the upper form shows data stored in BSO cube and the lower form is an ASO one.
04-08

You can find the "Map Reporting Application" from Administration menu.04-09
Create a new mapping
04-10
Input the Application Mapping Name, select the Source Application's Plan Type and select Essbase Reporting Application's database.04-11
Define the mapping type, from the list you can define types "Dimension to Dimension" or "Smart List to Dimension"
04-12
Save the mapping.04-14
Select the new created mapping, click "Push data"04-15
You can select clear data on destination first or not
04-16
The data was pushed to ASO cube from the source Planning cube, and because the destination is an ASO cube so that data can be aggregated automatically.
04-17

3 comments:

  1. Hi Xie,
    Good information,can we automate the process of pushing data to reporting cube?

    ReplyDelete
  2. Hi Sagar, you can use the Planning utility to do this. For more information, you can search "Pushing data with a utility" in Hyperion Planning Admin guide. Or the link below, https://docs.oracle.com/cd/E40248_01/epm.1112/hp_admin/frameset.htm?ch10s03s09.html

    ReplyDelete