Create data source connections to PowerCubes

Use the following procedure to create a data source connection to a PowerCube.

1. In IBM® Cognos® Administration, click the Configuration tab.
2. Click the new data source button .
3. To create a data source connection for the Sales and Marketing cube, type sales_and_marketing in the Name box, and then click Next.
4. In the connection page, under Type click IBM Cognos PowerCube, and then click Next.

   The connection string page for the selected database appears.

5. Optional: In the Read cache size (MB) box, type the cache size of the cube in megabytes.

   To use the default value in the ppds_cfg.xml file, leave this field blank or type 0.

6. In the Windows location box, type the location and name of the sales_and_marketing.mdc file for the data source connection. For example, type

   install_location/webcontent/samples/datasources/cubes/PowerCubes/En/Sales_and_Marketing.mdc

   You can define a Microsoft Windows operating system path or a UNIX operating system path.

   If you define a UNIX path and you plan to use Framework Manager, you must also define the Windows path and ensure that the cube is also available in the Windows location. Framework Manager can access cubes only from Windows locations.

7. To test whether the parameters are correct, do the following:
   • Click Test the connection.
   • Click Test.
   • When the test finishes, click Close twice.
8. Click Finish.