IBM Cognos Data Advisor Homework Help, Assignment Help, Online Tutor, Tutoring

Submit Assignment

Payment Online Assignment Help

Homework Help

sfsf

IBM Cognos Data Advisor

With IBM® Cognos® Express® Data Advisor you can create a multi-dimensional model definition. You can use this model definition for creating a package that contains a cube. You can analyze your data by creating a view, that is based on the cube, in IBM® Cognos® Express® Advisor.

Steps for creating the multi-dimensional model definition

1. Start Express Data Advisor.

2. In the New Model Definition dialog box specify the following on the General tab:

• For the Name type GoSalesCube

• As the Data Source select great_outdoors_sales

• For Package select Store in my folder.

• For Model select OLAP.

On the Advanced tab, for Model generation, specify the option Client based.

3. Click OK.

Steps for configuring the multi-dimensional model definition

1. On the Select Data pane, only select the order_details and order_header tables from the gosales schema.

2. Open the Define Relationships pane.

3. From the order_details table, drag and drop the order_number to the order_number column in the order_header table.

4. Open the Create Dimensions pane.

5. From the order_details table, drag and drop the quantity column in the Values dimension.

6. From the order_details table, drag and drop the ship_date column in the Time dimension.

7. You can choose to create and analyze the cube, or to just create the cube.

Either Click the Create and Analyze Cube icon .

Express Advisor starts and displays the view. You can now analyze your data with this view.

or Click the Create Cube icon .

The package is created.

Steps for opening the multi-dimensional package in Express Advisor

1. Start IBM Cognos Connection.

2. On the My Folders tab click My Folders > Advisor Packages > GoSalesCube.

3. Click the Default Analysis package.

Tutorial - analyzing a cube in IBM Cognos Express Advisor

In this tutorial you use samples. To install the samples, see the Managing IBM Cognos Express guide, Setting up the IBM Cognos Express samples

To use the samples in IBM® Cognos® Express® Advisor you must create a package.

Steps for creating a package for Express Advisor

1. Open the IBM Cognos Express Manager page.

2. Click the Data tab in the Administration section.

3. Click Add.

4. Specify the following:

• Data Source Type:TM1

• Name:Sales Plan Tutorial

• Admin Host: <Express Server>

Specify the name of your Express server.

• ICAS Server Name: CXMD

• Cube Name: Sales Plan

• Namespace: CognosExpress

5. Click OK.

Steps for analyzing a cube in Express Advisor

1. Open the Welcome to IBM Cognos Express page.

2. Click Analyze my Business with Advisor.

3. Click the package Sales Plan Tutorial.

Express Advisor starts.

4. Click the Views button on the toolbar tab.

5. On the Public Folders tab, click the Sales Plan package icon .

6. Click New.

7. Select View.

8. Type the name of the new view.

9. Click Open.

In the Connection Information dialog box, the package Sales Plan Tutorial is already selected.

10. From the Database menu, select the Sales Plan database and click OK.

You can now analyze your data in the view you created.