Sample Planning Flat Files (Simple)

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