In certain applications, such as general ledger and legacy systems, tables may be organized so that columns identify similar time periods. For example, a single row may include all months of a year. In this case, each subsequent row includes a measure category as a data value; for example, a specific account number.
To create a dimension of the type time, Integration Server requires that all time identifiers be in one column and that accounts identifiers be in separate columns, as shown in Table 15. If data is stored with each month as an individual column, as shown in Table 14, restructure the data. Individual months should be data values in a MONTH column, and the measures categories, such as SALES, should be separate columns.
You can write a program to convert the data to a table that uses the appropriate format or use the source database to transpose the columns (see Transposing Columns and Rows).