@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"