Use the following procedure to create a data
source connection to a PowerCube.
Procedure
- Open IBM® Cognos® Administration by connecting
to the IBM Cognos BI portal and clicking Administer
IBM Cognos Content on the Welcome page.
- Click the Configuration tab.
- Click the new data source button
. Note: You must add a data source connection for
each cube.
- To create a data source connection for the Sales and Marketing
cube, type sales_and_marketing in the Name box,
and then click Next.
- In the connection page, under Type click IBM
Cognos PowerCube, and then click Next.
The connection string page for the selected database appears.
- Optional: In the Read cache size (MB) box,
type the cache size of the cube in megabytes.
If you
leave this field blank or type 0, IBM Cognos Connection uses the default
value in the ppds_cfg.xml file in the configuration folder.
- 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
c10_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.
- To test whether the parameters are correct, do the following:
- Click Test the connection.
- Click Test.
- When the test finishes, click Close twice.
- Click Finish.
Results
You can now import the IBM_Cognos_Powercube.zip sample package
for the PowerCube to use this data source or you can create your own
package using the cube.
