Data Import File Format

The file format consists of rows and columns. The first row consists of Column Headers. The first Column Header is the Dimension name of the import dimension. After that, there can be members from one other dimension called the driver dimension. The next Column Heading is the Point-of-View, and the last Column Heading is Data Load Cube Name.

Each row contains the member of the Load dimension as the first column. The next set of columns is the data value for each of the driver members. The Point-of-View column has members of the remaining dimension to uniquely identify the cell to which data is being imported. The last column is the Cube name - either Consol or Rates.