Period Dimension

Use this convention for period configuration lines.

Period,<value>,<location in data file>

For example:

Period,January,8
Period,February,9
Period,March,10

The Period dimension is a special dimension because the database stores data for multiple periods in a single record in the fact tables. For this reason, your data file must be generated with period data across in the lines of the text file. Only the periods specified in the configuration file are loaded. The period lines must be specified last in the configuration file. If you exclude any members of the Period dimension in the configuration file, data for the excluded periods is not loaded, even though the data may be present in the data file.

Members of the Period dimension must be listed in chronological order by member name, not member ID.