This example shows a simple flat file that can be used for Planning. With simple flat files, the Members and Property Array sections are not included, and the information from those sections is moved to the Hierarchies section.
!FILE_FORMAT=ADS !VERSION=1.0 !Section=Dimensions 'Name|DimensionClass|DimensionAlias|DimDataStorage|Plan1Density|Plan2Density|Plan3Density|WorkforceDensity|CapexDensity|EnumOrder1|EnumOrder2|EnumOrder3|EnumOrderWF|EnumOrderCapex|DimValidForPlan1|DimValidForPlan2|DimValidForPlan3|DimValidForWorkforce|DimValidForCapex Colors|Attribute|Colors|||||||||||||||| Account|Account|Account|NeverShare|Dense|Dense|Dense|Dense||0|0|0|0||Y|Y|Y|N| Currency|Currency|Currency|NeverShare|Sparse|Sparse|Sparse|Sparse||0|0|0|0||Y|Y|Y|N| Entity|Entity|Entity|NeverShare|Sparse|Sparse|Sparse|Sparse||0|0|0|0||Y|Y|Y|N| NewCustomDimension|Generic|NewCustomDimension|NeverShare|Sparse|Sparse|Sparse|Sparse||0|0|0|0||Y|Y|Y|N| Period|Period|Period|NeverShare|Dense|Dense|Dense|Dense||0|0|0|0||Y|Y|Y|N| Scenario|Scenario|Scenario|NeverShare|Sparse|Sparse|Sparse|Sparse||0|0|0|0||Y|Y|Y|N| Version|Version|Version|NeverShare|Sparse|Sparse|Sparse|Sparse||0|0|0|0||Y|Y|Y|N| Year|Year|Year|NeverShare|Sparse|Sparse|Sparse|Sparse||0|0|0|0||Y|Y|Y|N| Alias|Alias|Alias|||||||||||||||| !Section=DimensionAssociations 'BaseDimension|Property|TargetDimension Colors|Alias|Alias Account|Alias|Alias Currency|Alias|Alias Currency|TriangulationCurrency|Currency Entity|Alias|Alias Entity|Currency|Currency Entity|Colors|Colors NewCustomDimension|Alias|Alias Period|Alias|Alias Scenario|Alias|Alias Scenario|StartPeriod|Period Scenario|EndPeriod|Period Scenario|StartYear|Year Scenario|EndYear|Year Version|Alias|Alias Year|Alias|Alias smartLists|Alias|Alias !Hierarchies=Colors 'Parent|Child|DataStorage #root|blue| #root|green| #root|purple| !Hierarchies=Account 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|Plan1Aggregation|Plan2Aggregation|Plan3Aggregation|WorkforceAggregation|DataType|SourcePlanType|AccountType|ExchangeRateType|VarianceReporting|TimeBalance|SmartList|UDA|TwoPassCalc|SkipValue|Description|BSOMemberFormula|Alias=Default|Alias=Aliases_Table_1|Alias=Aliases_Table_2|Alias=Aliases_Table_3|Alias=Aliases_Table_4 #root|100|NeverShare|Y|Y|Y|N||+|+|+|+|Currency|Plan1|Revenue|Average|NonExpense|Flow|||||||Alias_100|Aliases_Table_1 100|Aliases_Table_2 100|Aliases_Table_3 100|Aliases_Table_4 100 !Hierarchies=Currency 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|DataType|Symbol|Scale|ThousandSep|DecimalSep|NegativeSign|NegativeColor|ReptCurrency|TriangulationCurrency|CurrencyCode|SmartList|UDA|Description|Alias=Default #root|Local|StoreData|Y|Y|Y|N||Unspecified|null|Whole|None|Dot|Prefixed Minus|Black|N|||||Local currency| #root|USD|StoreData|Y|Y|Y|N||Unspecified|$|Whole|None|Dot|Prefixed Minus|Black|Y|||||United States of America dollar| #root|DEM|StoreData|Y|Y|Y|N||Unspecified|DM|Whole|None|Dot|Prefixed Minus|Black|Y|||||Germany deutsche mark|Alias_DEM #root|EUR|StoreData|Y|Y|Y|N||Unspecified|***|Whole|None|Dot|Prefixed Minus|Black|Y|||||European Union Euro| #root|FRF|StoreData|Y|Y|Y|N||Unspecified|F|Whole|None|Dot|Prefixed Minus|Black|Y|EUR||||France franc|Alias_FRF #root|IEP|StoreData|Y|Y|Y|N||Unspecified|IR£|Whole|None|Dot|Prefixed Minus|Black|Y|||||Ireland punt| !Hierarchies=Entity 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|Plan1Aggregation|Plan2Aggregation|Plan3Aggregation|WorkforceAggregation|DataType|Currency|SmartList|UDA|Colors|Description|Alias=Default #root|ParentMMM|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| ParentMMM|Mem_3|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| ParentMMM|Mem_2|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| ParentMMM|Mem_1|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| #root|ParentMMM_Shared|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| ParentMMM_Shared|Mem_3|ShareData|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| ParentMMM_Shared|Mem_2|ShareData|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| ParentMMM_Shared|Mem_1|ShareData|Y|Y|Y|N||+|+|+|+|Unspecified|USD||||| #root|Canada|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD|||||Alias_Canada #root|United States|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD|||blue||Alias_United States United States|Oregon|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD|||||Alias_Oregon United States|California|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD|||||Alias_California California|San Francisco|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD|||||Alias_San Francisco United States|Washington|NeverShare|Y|Y|Y|N||+|+|+|+|Unspecified|USD|||||Alias_Washington !Hierarchies=NewCustomDimension 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|Plan1Aggregation|Plan2Aggregation|Plan3Aggregation|WorkforceAggregation|DataType|SmartList|UDA|Description|Alias=Default #root|One|NeverShare|Y|Y|Y|N||+|+|+||Unspecified||||Alias_One !Hierarchies=Period 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|DataType|SmartList|UDA|Description|PeriodType|Alias=Default #root|BegBalance|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| #root|YearTotal|StoreData|Y|Y|Y|N||Unspecified||||Year Time Period| YearTotal|Q1|StoreData|Y|Y|Y|N||Unspecified||||Summary Time Period| Q1|Jan|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| Q1|Feb|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| Q1|Mar|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| YearTotal|Q2|StoreData|Y|Y|Y|N||Unspecified||||Summary Time Period| Q2|Apr|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| Q2|May|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| Q2|Jun|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| YearTotal|Q3|StoreData|Y|Y|Y|N||Unspecified||||Summary Time Period| Q3|Jul|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| Q3|Aug|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period|Alias_Aug_New Q3|Sep|StoreData|Y|Y|Y|N||Unspecified||||Base Time Period| YearTotal|Q4|StoreData|Y|Y|Y|N||Unspecified||||Summary Time Period| Q4|Oct|StoreData|Y|Y|Y|N||Unspecified||||Summary Time Period| Q4|Nov|StoreData|Y|Y|Y|N||Unspecified||||Summary Time Period| Q4|Dec|StoreData|Y|Y|Y|N||Unspecified||||Summary Time Period| !Hierarchies=Scenario 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|DataType|StartYear|EndYear|StartPeriod|EndPeriod|UseBegBalance|EnableProcessManagement|SmartList|ExchangeRateTable|UDA|Description|Alias=Default #root|Current|StoreData|Y|Y|Y|N||Unspecified|FY06|FY09|Jan|Dec|N|Y||||| #root|A_Scenario|StoreData|Y|Y|Y|N||Unspecified|FY06|FY06|Jan|Dec|N|Y||A_FXRate|||Alias_A_Scenario #root|B,_Scenario|StoreData|Y|Y|Y|N||Unspecified|FY06|FY06|Jan|Dec|N|Y||A_FXRate|||Alias_B,_Scenario !Hierarchies=Version 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|DataType|VersionType|EnableProcessManagement|SmartList|UDA|Description|Alias=Default #root|BU Version_1|StoreData|Y|Y|Y|N||Unspecified|BottomUp|Y|||| #root|A_Version|StoreData|Y|Y|Y|N||Unspecified|BottomUp|Y||||Alias_A_Version #root|B,_Version|StoreData|Y|Y|Y|N||Unspecified|BottomUp|Y||||Alias_B,_Version #root|C,_Version|StoreData|Y|Y|Y|N||Unspecified|Target|N||||Alias_C,_Version #root|D_Version|StoreData|Y|Y|Y|N||Unspecified|Target|N||||Alias_D_Version !Hierarchies=Year 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|DataType|SmartList|UDA|Description|Alias=Default #root|FY06|StoreData|Y|Y|Y|N||Unspecified||||Alias_FY06 #root|FY07|StoreData|Y|Y|Y|N||Unspecified|||| #root|FY08|StoreData|Y|Y|Y|N||Unspecified|||| #root|FY09|StoreData|Y|Y|Y|N||Unspecified|||| #root|FY10|StoreData|Y|Y|Y|N||Unspecified|||| #root|FY11|StoreData|Y|Y|Y|N||Unspecified|||| !Hierarchies=Alias 'Parent|Child #root|Aliases_Table_1 #root|Aliases_Table_2 #root|Aliases_Table_3 #root|Aliases_Table_4 #root|Default