Using PowerPlay for Windows for Reporting and Analysis with an Analysis Services Cube

By William E. Pearson III, May 12th, 2003 Posted in Cognos. Subscribe to our RSS Feed

Let’s look at using PowerPlay to report from our Analysis Services cube. We’ll examine a few of the capabilities within PowerPlay for viewing cube data, and get a feel for the functionality PowerPlay can provide us in reporting for Analysis Services data sources. We have established connectivity to the Warehouse cube via Cognos Connect in the steps above. Next, we’ll initialize PowerPlay and begin exploring our cube.

1. Click the Start button.

2. Select Programs > Cognos EP Series 7.

3. Select Cognos PowerPlay from the submenu that appears.

The Welcome dialog for Cognos PowerPlay appears.

4. Click the Create a New Report button.

The Choose a Local Cube dialog appears. (If the Choose a Remote Cube dialog appears instead, simply click the Local radio button to change to the … Local dialog).

5. Click to select the MSSQL_Warehouse pointer .mdc file we created earlier.

6. Click Open.

PowerPlay opens and displays a default Explorer view of the MSSQL_Warehouse cube, made possible by its connection to the Analysis Services Server via the Pointer cube file we created in an earlier section. The crosstab report we see should resemble this.

Written by William Pearson - Visit Website

Go To Page: 1 2 3 4 5

All Tutorials by Category:

Entire site Copyright © 1999-2007 2000Trainers.com, all rights reserved.
Content on this site may not be copied or reproduced in any way without permission.

IT Showcase