@PlanDimMember
@PLANDIMMEMBER returns a member if the member is valid for the specified dimension in the specified plan type.
DTP Type:
@PLANDIMMEMBER can be assigned to a DTP of type member.
Syntax:
@PLANDIMMEMBER(plan type,dimension,member)
Parameters:
| Parameter | Description |
|---|---|
plan type |
Design-time prompt that returns the type of plan |
dimension |
Design-time prompt that returns the dimension name |
member |
Design-time prompt that returns the member name |
Example 1:
[DIM_mbr1]=@ PLANDIMMEMBER("Plan1",[DIM],[Member])
Where:
-
[DIM_mbr1]is a DTP of type member that is not a checked prompt. -
[DIM]is a DTP of type dimension that is a checked prompt. -
[Member]is a DTP of type member that is a checked prompt. -
[Dim]="Entity" -
[Member]="Washington"