This example shows a regular flat file that can be used for Planning.
!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 !Members=Colors 'Name blue green purple !Hierarchies=Colors 'Parent|Child|DataStorage #root|blue| #root|green| #root|purple| !Members=Account 'Name|DataType|SourcePlanType|AccountType|VarianceReporting|TimeBalance|SmartList|UDA|TwoPassCalc|SkipValue|Description|BSOMemberFormula 100|Currency|Plan1|Revenue|NonExpense|Flow|||||| !Hierarchies=Account 'Parent|Child|DataStorage|ExchangeRateType|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|Plan1Aggregation|Plan2Aggregation|Plan3Aggregation|WorkforceAggregation #root|100|NeverShare|Average|Y|Y|Y|N||+|+|+|+ !PropertyArray=Account 'Property|Name|Key|Value Alias|100|Aliases_Table_1|Aliases_Table_1 100 Alias|100|Aliases_Table_2|Aliases_Table_2 100 Alias|100|Aliases_Table_3|Aliases_Table_3 100 Alias|100|Aliases_Table_4|Aliases_Table_4 100 Alias|100|Default|Alias_100 !Members=Currency 'Name|DataType|Symbol|Scale|ThousandSep|DecimalSep|NegativeSign|NegativeColor|ReptCurrency|TriangulationCurrency|CurrencyCode|SmartList|UDA|Description Local|Unspecified|null|Whole|None|Dot||Black|N|||||Local currency USD|Unspecified|$|Whole|None|Dot||Black|Y|||||United States of America dollar DEM|Unspecified|DM|Whole|None|Dot||Black|Y|||||Germany deutsche mark EUR|Unspecified|***|Whole|None|Dot||Black|Y|||||European Union Euro FRF|Unspecified|F|Whole|None|Dot||Black|Y|EUR||||France franc IEP|Unspecified|IR£|Whole|None|Dot||Black|Y|||||Ireland punt !Hierarchies=Currency 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex #root|Local|StoreData|Y|Y|Y|N| #root|USD|StoreData|Y|Y|Y|N| #root|DEM|StoreData|Y|Y|Y|N| #root|EUR|StoreData|Y|Y|Y|N| #root|FRF|StoreData|Y|Y|Y|N| #root|IEP|StoreData|Y|Y|Y|N| !PropertyArray=Currency 'Property|Name|Key|Value Alias|DEM|Default|Alias_DEM Alias|FRF|Default|Alias_FRF !Members=Entity 'Name|DataType|Currency|SmartList|UDA|Colors|Description ParentMMM|Unspecified|USD|||| Mem_3|Unspecified|USD|||| Mem_2|Unspecified|USD|||| Mem_1|Unspecified|USD|||| ParentMMM_Shared|Unspecified|USD|||| Canada|Unspecified|USD|||| United States|Unspecified|USD|||blue| Oregon|Unspecified|USD|||| California|Unspecified|USD|||| San Francisco|Unspecified|USD|||| Washington|Unspecified|USD|||| East|Unspecified|USD|||| NY|Unspecified|USD|||| West|Unspecified|USD|||| CA|Unspecified|USD|||| WA|Unspecified|USD|||| NJ|Unspecified|USD|||| !Hierarchies=Entity 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|Plan1Aggregation|Plan2Aggregation|Plan3Aggregation|WorkforceAggregation #root|ParentMMM|NeverShare|Y|Y|Y|N||+|+|+|+ ParentMMM|Mem_3|NeverShare|Y|Y|Y|N||+|+|+|+ ParentMMM|Mem_2|NeverShare|Y|Y|Y|N||+|+|+|+ ParentMMM|Mem_1|NeverShare|Y|Y|Y|N||+|+|+|+ #root|ParentMMM_Shared|NeverShare|Y|Y|Y|N||+|+|+|+ ParentMMM_Shared|Mem_3|ShareData|Y|Y|Y|N||+|+|+|+ ParentMMM_Shared|Mem_2|ShareData|Y|Y|Y|N||+|+|+|+ ParentMMM_Shared|Mem_1|ShareData|Y|Y|Y|N||+|+|+|+ #root|Canada|NeverShare|Y|Y|Y|N||+|+|+|+ #root|United States|NeverShare|Y|Y|Y|N||+|+|+|+ United States|Oregon|NeverShare|Y|Y|Y|N||+|+|+|+ United States|California|NeverShare|Y|Y|Y|N||+|+|+|+ California|San Francisco|NeverShare|Y|Y|Y|N||+|+|+|+ United States|Washington|NeverShare|Y|Y|Y|N||+|+|+|+ #root|East|NeverShare|Y|Y|Y|N||+|+|+|+ East|NY|NeverShare|Y|Y|Y|N||+|+|+|+ #root|West|NeverShare|Y|Y|Y|N||+|+|+|+ West|CA|NeverShare|Y|Y|Y|N||+|+|+|+ West|WA|NeverShare|Y|Y|Y|N||+|+|+|+ West|NJ|NeverShare|Y|Y|Y|N||+|+|+|+ !PropertyArray=Entity 'Property|Name|Key|Value Alias|Canada|Default|Alias_Canada Alias|United States|Default|Alias_United States Alias|Oregon|Default|Alias_Oregon Alias|California|Default|Alias_California Alias|San Francisco|Default|Alias_San Francisco Alias|Washington|Default|Alias_Washington !Members=NewCustomDimension 'Name|DataType|SmartList|UDA|Description One|Unspecified||| !Hierarchies=NewCustomDimension 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|Plan1Aggregation|Plan2Aggregation|Plan3Aggregation|WorkforceAggregation #root|One|NeverShare|Y|Y|Y|N||+|+|+| !PropertyArray=NewCustomDimension 'Property|Name|Key|Value Alias|One|Default|Alias_One !Members=Period 'Name|DataType|SmartList|UDA|Description BegBalance|Unspecified||| YearTotal|Unspecified||| Q1|Unspecified||| Jan|Unspecified||| Feb|Unspecified||| Mar|Unspecified||| Q2|Unspecified||| Apr|Unspecified||| May|Unspecified||| Jun|Unspecified||| Q3|Unspecified||| Jul|Unspecified||| Aug|Unspecified||| Sep|Unspecified||| Q4|Unspecified||| Oct|Unspecified||| Nov|Unspecified||| Dec|Unspecified||| !Hierarchies=Period 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex|PeriodType #root|BegBalance|StoreData|Y|Y|Y|N|N|Base Time Period #root|YearTotal|StoreData|Y|Y|Y|N|N|Year Time Period YearTotal|Q1|StoreData|Y|Y|Y|N|N|Summary Time Period Q1|Jan|StoreData|Y|Y|Y|N|N|Base Time Period Q1|Feb|StoreData|Y|Y|Y|N|N|Base Time Period Q1|Mar|StoreData|Y|Y|Y|N|N|Base Time Period YearTotal|Q2|StoreData|Y|Y|Y|N|N|Summary Time Period Q2|Apr|StoreData|Y|Y|Y|N|N|Base Time Period Q2|May|StoreData|Y|Y|Y|N|N|Base Time Period Q2|Jun|StoreData|Y|Y|Y|N|N|Base Time Period YearTotal|Q3|StoreData|Y|Y|Y|N|N|Summary Time Period Q3|Jul|StoreData|Y|Y|Y|N|N|Base Time Period Q3|Aug|StoreData|Y|Y|Y|N|N|Base Time Period Q3|Sep|StoreData|Y|Y|Y|N|N|Base Time Period YearTotal|Q4|StoreData|Y|Y|Y|N|N|Summary Time Period Q4|Oct|StoreData|Y|Y|Y|N|N|Base Time Period Q4|Nov|StoreData|Y|Y|Y|N|N|Base Time Period Q4|Dec|StoreData|Y|Y|Y|N|N|Base Time Period !PropertyArray=Period 'Property|Name|Key|Value Alias|Aug|Default|Alias_Aug_New !Members=Scenario 'Name|DataType|StartYear|EndYear|StartPeriod|EndPeriod|UseBegBalance|EnableProcessManagement|SmartList|ExchangeRateTable|UDA|Description Current|Unspecified|FY06|FY09|Jan|Dec|N|Y|||| A_Scenario|Unspecified|FY06|FY06|Jan|Jan|N|Y||A_FXRate|| B,_Scenario|Unspecified|FY06|FY06|Jan|Dec|N|Y||A_FXRate|| !Hierarchies=Scenario 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex #root|Current|StoreData|Y|Y|Y|N| #root|A_Scenario|StoreData|Y|Y|Y|N| #root|B,_Scenario|StoreData|Y|Y|Y|N| !PropertyArray=Scenario 'Property|Name|Key|Value Alias|A_Scenario|Default|Alias_A_Scenario Alias|B,_Scenario|Default|Alias_B,_Scenario !Members=Version 'Name|DataType|VersionType|EnableProcessManagement|SmartList|UDA|Description BU Version_1|Unspecified|BottomUp|Y||| A_Version|Unspecified|BottomUp|Y||| B,_Version|Unspecified|BottomUp|Y||| C,_Version|Unspecified|Target|N||| D_Version|Unspecified|Target|N||| !Hierarchies=Version 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex #root|BU Version_1|StoreData|Y|Y|Y|N| #root|A_Version|StoreData|Y|Y|Y|N| #root|B,_Version|StoreData|Y|Y|Y|N| #root|C,_Version|StoreData|Y|Y|Y|N| #root|D_Version|StoreData|Y|Y|Y|N| !PropertyArray=Version 'Property|Name|Key|Value Alias|A_Version|Default|Alias_A_Version Alias|B,_Version|Default|Alias_B,_Version Alias|C,_Version|Default|Alias_C,_Version Alias|D_Version|Default|Alias_D_Version !Members=Year 'Name|DataType|SmartList|UDA|Description FY06|Unspecified||| FY07|Unspecified||| FY08|Unspecified||| FY09|Unspecified||| FY10|Unspecified||| FY11|Unspecified||| !Hierarchies=Year 'Parent|Child|DataStorage|MemberValidForPlan1|MemberValidForPlan2|MemberValidForPlan3|MemberValidForWorkforce|MemberValidForCapex #root|FY06|StoreData|Y|Y|Y|N| #root|FY07|StoreData|Y|Y|Y|N| #root|FY08|StoreData|Y|Y|Y|N| #root|FY09|StoreData|Y|Y|Y|N| #root|FY10|StoreData|Y|Y|Y|N| #root|FY11|StoreData|Y|Y|Y|N| !PropertyArray=Year 'Property|Name|Key|Value Alias|FY06|Default|Alias_FY06 !Members=Alias 'Name Aliases_Table_1 Aliases_Table_2 Aliases_Table_3 Aliases_Table_4 Default !Hierarchies=Alias 'Parent|Child #root|Aliases_Table_1 #root|Aliases_Table_2 #root|Aliases_Table_3 #root|Aliases_Table_4 #root|Default