In this chapter, we discussed the various ways in which you can copy data by using a D-Link. We demonstrated how you can copy data from a D-Cube and from an ASCII file or a database. You can connect to an ASCII file by using a File Map. If your data source is a database, you can connect to it using an ODBC connection. An ODBC connection gives you the ability to write SQL statements against the database and to manipulate the data before extracting it. Once you have defined the data and dimensions from the source, you need to pair or allocate the dimension items. You can automatically match descriptions, or can manually allocate the dimension items by using an allocation table. The allocation table could be created locally within the D-Link, ...

Get IBM Cognos 8 Planning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.