Returns information on a specific member.
Syntax
GETMBRINFO mbrName| Parameter | Description |
|---|---|
mbrName | Member name |
Notes
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