1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Using Components to Design Business Rules and Templates
  3. DTP Assignment Components
  4. Using Design-Time Prompt Functions in DTP Assignment Components
  5. @Intersect

@Intersect

@INTERSECT returns members that are from common dimensions.

DTP Type:

@INTERSECT can be assigned to a DTP of type member range or cross dimension.

Syntax:

@INTERSECT(Argument1,Argument2)

Parameters:

Parameter Description
Argument1 Design-time prompt, function, or text
Argument2 Design-time prompt, function, or text

Example:

[IntersetMR]=@INTERSECT([MR1],[MR2])

Where:

  • [MR1] is a DTP of type member range that is a checked prompt.

  • [MR2] is a DTP of type member range that is a checked prompt.

Assume that the input for MR1 is:

  • Account: "Salaries"

  • Version: "Target"

  • Entity: "Tennessee", "Florida"

And the input for MR2 is:

  • Account: "50590", "50350"

  • Years: "FY10"

  • Scenario: "Budget"

  • Version: "First Pass"

In this example, [IntersectMR] returns "50590","50350","Salaries","First Pass","Target". Since members for "Entity" are only entered in MR1, and members for "Scenario" are only entered in MR2, these members are not included in [IntersectMR].