@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].