Flat File Extract Options

When you extract members in a flat file format, you can select whether to include a header for the file.

Example: Flat File with Header

Scenario=Actual

Year=2014

Period=[Year]

View=YTD

Entity=CORP_OPS

Parent=GROUP

Value=[Parent Total]

Possible Duplicated Records=No

SalesIC;CHINA;[None];[None];[None];[None];100000

SalesIC;CHINA;[None];AllCustom2;[None];[None];100000

Scenario=Actual

Year=2014

Period=[Year]

View=Periodic

Entity=CORP_OPS

Parent=GROUP

Value=[Parent Total]

Possible Duplicated Records=No

SalesIC;CHINA;[None];[None];[None];[None];100000

SalesIC;CHINA;[None];AllCustom2;[None];[None];100000

Example: Flat File No Header

!Data

Actual;2014;[Year];YTD;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];[None];[None];[None];100000 

Actual;2014;[Year];YTD;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];AllCustom2;[None];[None];100000

Actual;2014;[Year];Periodic;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];[None];[None];[None];100000

Actual;2014;[Year];Periodic;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];AllCustom2;[None];[None];100000