This section defines dimension members and their member properties. Relationship member properties cannot be defined in this section since they require a parent child relationship. For example, 'AggregationWeight' cannot be defined in the Members section.

Dimension properties are defined in product-specific chapters:

Syntax

!Members=Dimension_Name

'Name;Member_Property1;…;Member_PropertyN

Example

!Members=Currency
'Name;Scale;TranslationOperator;DisplayInICT
EURO;Whole;;y
GBR;Whole;;
USD;Whole;;

!Members=Scenario
'Name;DefaultFrequency;DefaultView;ZeroViewForNonAdj;_
ZeroViewForAdjConsolidateYTD;MaximumReviewLevel;UsesLineItems;_
Creating Flat Files 3
EnableProcessManagement;SecurityClass;EnableDataAudit;_
DefFreqForICTrans
Actual;MTD;Periodic;Periodic;Periodic;N;10;Y;N;;Y;MTD
Budget;MTD;Periodic;Periodic;Periodic;N;10;Y;Y;;Y;MTD

!Members=Entity
'Name;Currency;AllowAdjs;AllowAdjFromChildren;_
HoldingCompany;SecurityAsPartner;IsICP;SecurityClass
Entity_[None];[None];N;N;;;N;
Regional;USD;Y;N;;;N;CORPORATE
UnitedStates;USD;Y;Y;;;N;US

!Members=Account
'Name;ConsolidationAccountType;IsCalculated;_
IsConsolidated;PlugAccount;Custom1TopMember;Custom2TopMember;_
Custom3TopMember;Custom4TopMember;NumDecimalPlaces;_
EnableCustom1Aggr;EnableCustom2Aggr;EnableCustom3Aggr;_
EnableCustom4Aggr;XBRLTags;ICPTopMember;IsICP;UsesLineItems;_
SecurityClass;EnableDataAudit;CalcAttribute
Account_[None];Revenue;N;N;;;;;;0;Y;Y;Y;Y;;;N;N;;N;
ExchangeRates;GroupLabel;Y;Y;;;;;;0;Y;Y;Y;Y;;;N;N;;N;
Plug;Revenue;N;Y;;;;;;0;Y;Y;Y;Y;;;N;N;;N;

Example

Example of defining a member formula in the Members section. (Underscores (_) are used to escape line breaks.)

!Members=Planning_Account
'Name|BSOMemberFormula
SpecialAccount|[OpenInputValueBlock]_
[TimeBalanceFormula("Spread_Average")]_
[CloseInputValueBlock]