Set the caption of this formula component to Medium COS Calculation Manager for

Set the caption of this formula component to medium

This preview shows page 47 - 54 out of 75 pages.

Set the caption of this formula component to Medium COS
Image of page 47
Calculation Manager for Oracle Hyperion Planning 48 Oracle Hyperion Planning, Fusion Edition 11.1.1 Medium COS: 4) Finalize the condition Copy the High COS component to the false statement of the second condition and change the formula to: Operating COS= Operating revenue / 4 Set the caption of this formula component to Low COS
Image of page 48
Calculation Manager for Oracle Hyperion Planning 49 Oracle Hyperion Planning, Fusion Edition 11.1.1 5) Restrict the COS calculation on level 0 Segments, below Seg01 Drag a drop a new member range to the left of the condition group. Call the member selector and choose the segment dimension. Pick the Seg01 segment, choose Relative 0 in the add special Click OK Move the Gross Profit Ratio Condition block inside the segment member range.
Image of page 49
Calculation Manager for Oracle Hyperion Planning 50 Oracle Hyperion Planning, Fusion Edition 11.1.1 6) Aggregate partially the Segment dimension Drag and drop an Aggregation system template outside the Segments member range and before the Variances formula. Fill this template as follows Using 1.Point of View tab: Restrict on Plan Using 4. Partial dimension aggregation (sparse) tab, check Segments, perform an aggregation on Seg01 and pick descendants as aggregation level for the sparse dimension1.
Image of page 50
Calculation Manager for Oracle Hyperion Planning 51 Oracle Hyperion Planning, Fusion Edition 11.1.1 7) Restrict calculations Drag and drop a member range component right after the Copy Data template Fill it with Plan Drag and drop the condition group into this member range (using the Segments Member range). Drag and drop the Aggregation template into this range Drag and drop another member range component just before the member range on Plan Fill it with FY10 and Working (use member selector select these 2 members in this member selector)
Image of page 51
Calculation Manager for Oracle Hyperion Planning 52 Oracle Hyperion Planning, Fusion Edition 11.1.1 Drag and drop the member range on Plan within the member range on FY10 and Working Drag and drop the Variance formula component outside the member range on plan, and inside the member range on FY10 and Working 8) Restrict the whole Rule on HSP_InputValue (HSP_Rates dimension) and Local (currency dimension) Go to the begin component Select the Global Range tab. Enter HSP_InputValue & Local or use the member selector 9) Aggregate the Entity dimension Select the second member range for FY10, Working, right and select Collapse. Drag and drop an Aggregation system template before the End component. Fill the Aggregation template with the following: Restrict on "Plan", "Act vs Plan", FY10, Working, and Distribution in the 1. Point of View tab. Select Entity as the Sparse Dimension 1 using the 2. Full Dimension aggregation tab.
Image of page 52
Calculation Manager for Oracle Hyperion Planning 53 Oracle Hyperion Planning, Fusion Edition 11.1.1 10) Validate the rule Click on Actions / Validate or click on the green check box Check Planning to validate the calc script logic Final Rule flow chart should look like this: 11) Deploy the rule
Image of page 53
Image of page 54

You've reached the end of your free preview.

Want to read all 75 pages?

  • Fall '19
  • SDAS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture