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