@Compliment
@COMPLIMENT
returns the members in DTP1 that are not in DTP2, and the members that are in DTP2 that are not in DTP1. In other words, @COMPLIMENT
returns what is not common between DTP1 and DTP2.
DTP Type:
@COMPLIMENT
can be assigned to a DTP of type member range or cross dimension.
Syntax:
@COMPLIMENT(Argument1,Argument2)
Parameters:
Parameter | Description |
---|---|
Argument1 |
Design-time prompt or function that returns a member range or cross dimension |
Argument2 |
Design-time prompt or function that returns a member range or cross dimension |
Example 1:
[DTP_MR]=@COMPLIMENT([MR1],[MR2])
Where:
-
[DTP_MR]
is a DTP of type member range that is not a checked prompt. -
[MR1]
="Salaries,"FY14","Local","Tennessee","USA" -
[MR2]
="Jan", "Feb", "Mar","FY15","Actual", "Budget","Working","Florida","California","000", "G100"
In this example, DTP_MR
returns "Salaries,"Jan", "Feb", "Mar", "Actual", "Budget","Working","Local","000", "G100","USA"
Example 2:
[DTP_CD]=@COMPLIMENT([CD1],[CD2])
Where:
-
[DTP_CD]
is a DTP of type cross dimension that is not a checked prompt. -
[CD1]
="Salaries"->"Jan"->"Actual"->"Local" -
[CD2]
="50100"->"Feb"->"Budget"->"Working"->"California"->"000"
In this example, [DTP_CD]
returns "Working"->"Local"->"California"->"000"