@Dependency

"Inclusive" returns member(s) from Input 1 for which Input 2 has member(s) specified from the same dimensions. "Exclusive" returns members from Input 1 for which Input 2 has no specified members in the same dimensions.

Destination DTP types can be used with the following DTPs for @DEPENCENCY:

Destination DTP Types	Parameters to Use In `@DEPENDENCY`
Member	Member Range, Cross Dimension, Dimension, or Dimensions. If member is used in `@DEPENDENCY`, it must be used within the function `@DIMMEMBER` (member).
Members	Dimension or Dimensions
Dimension	Member Range, Cross Dimension, Dimension, or Dimensions
Dimensions	Member Range or Cross Dimension
Member Range	Member Range, Cross Dimension, Dimension, or Dimensions
Cross Dimension	Member Range, Cross Dimension, Dimension, or Dimensions

Syntax:

@DEPENENCY (Input1, Dependence, Input2)

Parameters:

Parameter	Description
`Input1`	design-time prompt or function
`Dependence`	"Inclusive" or "Exclusive"
`Input2`	design-time prompt or function

Example 1 and Example 2 below assume the following inputs:

[cd_mr_i1] is a DTP of type cross dimension that is not a checked prompt.
[CD1] is a promptable DTP of type cross dimension with the following inputs:
- Account: "Units"
- Period: "Jan"
- HSP_View:
- Year: "FY15"
- Scenario: "Actual"
- Version: "Working "
- Entity: "111"
- Product:
[POV] is a promptable DTP member range with the following inputs:
- Account:
- Period:"Feb"
- HSP_View:
- Year: "FY16"
- Scenario: "Actual"
- Version: "Working "
- Entity:
- Product: "P_000"

Example 1:

[cd_mr_i1]=@DEPENDENCY([CD1],"Inclusive",[POV])

In this example, [cd_mr_i1] returns "Jan->FY15->Actual->Working" since "Period ", "Year", "Scenario", and "Version" have inputs for "CD1" and "POV".

Example 2:

[cd_mr_e1]=@DEPENDENCY([CD1],"Exclusive",[POV]

In this example, [cd_mr_e1] returns "Units->"111" " since "Account" and "Entity" are the only dimensions in "Input 1" that have members specified and that are not specified in "Input 2".