Exclamation points ( ! ) indicate the beginning of sections. Exclamation points must be followed by valid section names (for example, Dimensions or DimensionAssociations).
Lines that start with apostrophes ( ' ) define the columns for each section. Each section header line must be followed by a column header/definition line. For example:
!Section=Dimensions 'Name|DimensionClass|DimensionAlias|DimensionStorageType|AllowDuplicatesInDimension|CommentDuplicate|ConsolidationDuplicate|DataStorageDuplicate|DimensionHierarchyType|DimensionSolveOrder|BSOMemberFormulaDuplicate|MemberSolveOrderDuplicate|SkipValueDuplicate|TimeBalanceDuplicate|UDADuplicate|TwoPassCalcDuplicate|VarianceReportingDuplicate|DimDataStorage|DimValidForCapex|DimValidForPlan1|DimValidForPlan2|DimValidForPlan3|DimValidForWorkforce|EnumOrder1|EnumOrder2|EnumOrder3|EnumOrderCapex|EnumOrderWF|AttributeType|CurrencyNameDuplicate|customDimensionId|ApplySecurity|DisplayOrder|GridMissingLabelType|Increment|SmartListLabel|StartValue
True and false values are represented as Y for true and N for false.
Semicolons ( ; ), commas ( , ), pipes ( | ), spaces, and tabs are valid field/column delimiters.
|
Note: |
You can only use one delimiter per file. For example, you cannot delimit a file with both pipes (|) and semicolons ( ;). |
Underscores (_) can be used in front of a line break to escape the line break and allow a record to span multiple lines in the flat file. For example, you may want to use line breaks to format member formulas since member formulas can be extremely long.
|
Note: |
Import files cannot contain property names with spaces. For example, when specifying a dimension association where the associated dimension is an attribute dimension, the property name specified in the dimension association section must not contain spaces. In addition, dimension names cannot begin with an exclamation point (!). |