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