Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jun 16, 2003

Reporting Options for Analysis Services Cubes: Cognos PowerPlay - Page 9

By William Pearson

The completed Cube Properties dialog should appear substantially like that shown in Illustration 42.

click for larger image
Illustration 42: The Completed Cube Properties Dialog

12.  Click OK to accept and apply the settings.

The Cube Properties dialog closes, returning us to the PowerPlay Enterprise - Server Administration window. We see the newly inserted cube, sporting the new name we assigned earlier in the Cube Properties dialog, Warehouse Analysis Services Cube, as depicted in Illustration 43.

Illustration 43: The New Warehouse Analysis Services Cube Appears

Let's perform a test of our new cube by using the Open with Browser "preview" capability afforded us by PPES Administration. The icon for access to this feature is shown in Illustration 44.

Illustration 44: The Open with Browser Icon

13.  Click the Open with Browser icon.

The browser initializes, and we are taken to the cube presentation, as shown in Illustration 45. (Keep in mind our comments regarding prompted database / other logons, depending upon the level of integration of security. An example would be the appearance of a database login screen at this stage in the simple security scenario. Provide logon credentials to proceed in cases such as this, if applicable).

Illustration 45: The Browser Presentation (Compressed View)

A successful test is thus indicated. Now that we have established connectivity to the Analysis Services Warehouse cube, we will overview PPWEB reporting from the PPES cube.

Reporting via the "zero-footprint" web client that requires only a reasonably current browser (see the documentation for acceptable versions of standard browsers) on the client to access and report from our cube. The procedures in this article are presented using Internet Explorer, but the steps should be quite similar using Netscape.

1.      Close Internet Explorer completely.

2.      Open Internet Explorer again.

3.      Type the following URL into the address field, substituting your server name for MOTHER (my server name) :


4.      Click Go, to the right of the URL.

The Table of Contents appears as shown in Illustration 46. We see the new Warehouse Analysis Services Cube that we have published, along with the sample cubes that are added in the typical installation of PPES and related applications.

Illustration 46: The Table of Contents Page in Explorer

5.      Click the Warehouse Analysis Services Cube.

6.      Provide database logon credentials, then log on, as applicable,

The data from the newly connected Warehouse Analysis Cube appears once again, as shown in Illustration 47.

Illustration 47: The Warehouse Cube Opens in the PowerPlay Web Explorer Window

We can now get into analyzing our data from the browser interface. We can perform all the typical reporting capabilities that are available to us for a proprietary cube in PowerPlay Web, in addition to leveraging several extended capabilities that become available with the Analysis Services cube.

Let's take a quick look at navigation in the Cognos PowerPlay Web Explorer interface at this point.

7.      Click the Store dimension label in the bottom left of the display.

8.      Click Store in the cascading menu that appears.

The flyout menu appears, as shown, offering drilldown paths and other functionality, some of which are depicted in Illustration 48.

Illustration 48: Drilldown and other Selections Appear in the Flyout Menu

9.      Click USA -> WA on the flyout to drill down to the WA children.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM