Set Up Microsoft Analysis Services Cube Samples

IBM® Cognos® Connection or Framework Manager provides sample cubes for Microsoft Analysis Services (MSAS).

For finance data, use the GO Finance Fact cube derived from the GOSALESDW database. This cube contains year-to-date and monthly financial data for all accounts so that you can create financial statements in Analysis Studio, Query Studio, and Report Studio. The data is in actual US dollars submissions for 2004, 2005, 2006, or 2007 (7 months actual data only).

The MSAS2005 version is in the GOFinanceFact_XX.abf file. XX represents the language. For example, XX is replaced with EN which indicates English. The MSAS2008 version of cubes also exists, with report content only for the 2005 version.

For sales data, use the GOSalesFact cube derived from the GOSalesFact_XX Analysis Services database, based on the GOSALESDW SQLSERVER Database. The cube contains measures such as unit cost, unit price, quantity, and gross profit. Dimensions include Time, Product, and Retailers.

The MSAS2005 version is in the GOSalesFact_XX.abf restorable backup file.

The backup files are located in the c10_location/webcontent/samples/datasources/cubes/MSAS directory. The files must be restored to a Microsoft SQL Server database running the applicable Microsoft Analysis Services and hosting the GOSALESDW database.

Note: Both Microsoft XML 6.0 Parser and Microsoft SQL 2005 Analysis Services 9.00 OLEDB Provider must be installed on the local client to establish data source connections to MSAS cubes.

Procedure

On the computer where IBM Cognos Business Intelligence is installed, go to the c10_location/webcontent/samples/datasources/cubes/MSAS/en directory.
Copy the GOSALESDW.cab and GOSALESDW.abf files to a directory that you can access from the Analysis Manager console in the Analysis Servers of Microsoft SQL Server.
Use the Microsoft Analysis Services Analysis Manager to restore the database from the GOSALESDW.cab and GOSALESDW.abf files.

Results

You can now create the data source connections to these MSAS datasources in Cognos Administration by referencing either the GOSalesFact_XX or GOFinanceFact_XX cubes you restored.