Creating Calculation Measures by using Physical Column

To create a derived calculation measures by using Physical logical columns you perform the following steps:

1)      Open the Repository in Offline Mode or Online Mode, in my case I am opening in offline mode.

2)      Create a new logical Column in BMM Layer.

3)      Build the formula and specify an aggregation rule.

4)      Deploy the Repository in Enterprise Manager Fusion middleware control. After deploying Repository restart all the system components.

5)      Once all System components are restarted, create and Run an Analysis to check whether Calculation measures are working properly or not.

6)      Check the Query Log in Analysis whether all tables, columns and Measures are querying properly or not.

(Note: Aggregation rule is applied after the formula when we create Calculation measures by using Physical Column.)

Open Repository in offline mode.

1)      Select Start > Programs > Oracle Business Intelligence > BI Administration>File>Open>Offline Mode.

2) In the BMM layer, expand Sample Sales > F1 Revenue

3) Right-click F1 Revenue and select New Object > Logical Column to open the Logical Column dialog box.

4) On the General tab, enter Name in the Name field.

5) Click the Column Source tab then select Derived from physical mappings and click the column mapping tab of the Logical Table Source dialog box to open the Expression Builder for the new column.

6) Click the Edit Expression button to open Expression Builder.

6)     In the Left pane select Physical Tables> F1 Revenue> COST_FIXED and click insert then click division (/) button and again Physical Tables> F1 Revenue> COST_VARIABLE. Click OK.

6)     When you close the Expression Builder, the expression appears in the Expression field for the column on the column Mapping tab of the Logical Table Source dialog box.

9) Click OK to close Expression Builder. Notice that the formula is added to the Logical Column dialog box.

6)     Click OK to close the Logical Column dialog box. The CF/CV calculated measure is added to the business model.

6)     Specify an Aggregation Rule.

6)     Click OK to close the Logical Column dialog box. The CF_CV calculated measure is added to the business model with the Aggregation Rule.

6)     Check the query log in Analysis.