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:
Note: |
This section is optional. Member property values can also be defined in the Hierarchies and PropertyArray sections of the flat file. |
Syntax
!Members=Dimension_Name 'Name;Member_Property1;…;Member_PropertyN
Parameter |
Description |
---|---|
Dimension_Name |
Name of dimension whose members are being defined. |
Name |
A member name, for example Euro. This is a required column. |
Member_PropertyX |
Member-level property name for the respective dimension type. See the product-specific chapters for property information. |
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]
Note: |
Smart List member names cannot contain special characters, hyphens, or spaces. For additional information, see Smart List Names. |
Note: |
The MemberFormula property has been deprecated. If the flat file uses MemberFormula, a warning is displayed and the values are ignored. You should use the ASOMemberFormula or BSOMemberFormula property instead. ASOMemberFormula is valid for Essbase ASO and Profitability and Cost Management applications. BSOMemberFormula is valid for Essbase BSO, Profitability and Cost Management, and Planning applications. |