Sample ASCII File

Here is the delimited ASCII file (example.cma) that you will use to build a dimension and import data. 
"New England", "Massachusetts", "Boston", "SuperMart",
"Feb" , 2000000"New England", "Massachusetts", "Springfield", "SuperMart",
"Feb" , 1400000"New England", "Massachusetts", "Worcester", "SuperMart",
"Feb" , 2200000

Each record in this source file has six fields, three of which will be used to create the Example dimension. The first two fields will become consolidated elements. The third field will become a numeric element. The remainder of the fields will be ignored.

In the Dimension Editor, the Example dimension will have the following structure:

New England

  • Massachusetts
    • Boston
    • Springfield
    • Worcester

The numeric values from Boston, Springfield, and Worcester will consolidate into Massachusetts totals, which will consolidate into New England totals.