Create Data Source Connections to Microsoft Analysis Service Cubes

Use the following procedure to create a data source connection to a Microsoft Analysis Service cube.

Procedure

  1. Open IBM® Cognos® Administration by connecting to the IBM Cognos BI portal and clicking Administer IBM Cognos Content on the Welcome page.
  2. On the Configuration tab, click New Data Source.
  3. In the Name box, type the name of the data source connection, and then click Next.
    • For the GOFinanceFact cube, type GOFinanceFact_XX_MSAS2005.
    • For the GOSalesFact cube, type GOSalesFact_XX_MSAS2005.
  4. In the Specify Connection page of the New Datasource Wizard, click Microsoft Analysis Services 2005.
  5. Click Next.
  6. In the Server Name box, type the name of the server where the restored databases are located. Back slashes are not required.
  7. Under Signon, select the Password check box and then select the Create a signon that the Everyone group can use check box. Type the user ID and password for the MSAS2005 database. For MSAS2005, this is a network login.
  8. Click Test the connection, and then click the Test button. Click Close.
  9. Click Finish. You are now prompted to create a package.

    Alternatively, you can deploy an existing package from a sample deployment archive. The names of the deployment archives match the datasource connection names specified in step 4 and contain sample reports that work with the associated cubes.

    In Content Administration on the Configuration tab in IBM Cognos Administration, click New Import. The New Import Wizard prompts you to select a deployment archive. When you select a deployment archive, it is important to click Edit and specify a target name for the package to prevent an existing package from being overwritten.

  10. To create a package, check Create a Package and then click OK.
  11. Specify a package name and then click OK.
    • For the GO Finance Fact cube, type GOFinanceFact_XX_MSAS2005.
    • For the GO Sales Fact cube, type GOSalesFact_XX_MSAS2005.
  12. Specify the Analysis Services database you restored either GOFinanceFact_XX or GoSalesFact_XX:
    • For either the GOFinanceFact cube or the GOSalesFact cubes, type GOSALESDW.
    • For the GO Sales Fact cube, type GO Sales Fact.
  13. Click the cube applicable to the database.
  14. Click Finish.
Parent topic: Creating Data Source Connections to OLAP Data Sources