IBM Cognos 8 Planning

Summary

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, ...