Top >
ESSCMD Commands >
GETMBRINFO
GETMBRINFO
Returns information on a specific member.
Syntax
GETMBRINFO mbrName
Description
This command returns the following information on a
specific member:
- Member name.
- Member number.
- Dimension name.
- Dimension number.
- Data-storage share information.
- Level: Steps from bottom to top.
- Generation: Steps from top to bottom.
- Unary operator (+, -, *,/,%,~) for consolidation: add, subtract, multiply, divide,
percentile, ignore.
- Member tag types, if any; for example, Accounts and Time Series tags,
Two-Pass Calc tags.
- Name of the tagged currency database member (if any).
- Currency conversion. Values: Yes/No
- Member description.
- Parent member name.
- Child member name.
- Previous member name.
- Next member name.
- Attributed: Whether the member has attributes associated with it.
Values: Yes, No, N/A (N/A for attribute members).
- Attribute Type: The attribute member type. Values: Boolean, Date, Numeric, Text.
- Attribute Value: The short attribute member name, if an attribute member. This is the
name shown in the Outline Editor.
- Member has relational descendants: Applicable if Hybrid Analysis is used.
Example
GETMBRINFO "Ounces_20";
Returns:
Member info of [Ounces_20]
------------------------------------
MbrName : Ounces_20
MbrNumber : 2
DimName : Ounces
DimNumber : 7
Status : Virtual Member (Non-stored)
Level : 0
Generation : 2
UnaryCalc : NoRollUp
MbrTagType : SkipNone
CrMbrName : N/A
CurrConvert : N/A
Description : N/A
ParentMbrName : Ounces
ChildMbrName : N/A
PrevMbrName : Ounces_32
NextMbrName : Ounces_16
Attributed : N/A
Attribute Type : Numeric(Double)
Attribute Value: 20
Member has relational descendants: No