dcsimg

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

June 16, 2003

Now let's make another adjustment for readability: let's hide the Time column, as it provides no compelling information at present.

29.  Click the column axis dimension selector (Time) once more.

30.  Select Action -> Hide Total from the flyout menu, as shown in Illustration 57 below.

click for larger image

Illustration 57: Hiding the Time Column

The Total column disappears, while leaving the column axis dimension selector (currently displaying Time) available for manipulation. The display appears as partially shown in Illustration 58.


Illustration 58: The Display, sans Total Column (Partial View)

Let's take a quick look at an example of the graphics capabilities within Cognos PowerPlay Web Explorer. Most of the graphics styles can be activated simply by clicking the appropriate toolbar button.

31.  Click the 3-D graphic display button from the bottom toolbar of the Web Explorer display (depicted in Illustration 59).


Illustration 59: The 3-D Graphic Display Button from the Toolbar

The resulting 3-D charts reflect the effects of our nesting Products within the Store Cities. A graphic is presented for each Store, as is partially shown in Illustration 60.


Illustration 60: The 3-D Graphic Displays for Products within Stores (Partial View)

Keep in mind that the graphics are far from static representations; drilldown works here, as well, and can be enacted simply by clicking on the appropriate element of the chart.

Let's return to the crosstab display we occupied previously, only this time let's choose an indented display.

32.  Click the Indented Crosstab Display button from the toolbar, to the left of the 3-D graphic button, and as displayed (alongside the regular crosstab display button) in Illustration 61.


Illustration 61: Select the Indented Crosstab Display Button (Circled)

The display now appears as an indented crosstab, as depicted in Illustration 62.


Illustration 62: The Indented Crosstab Display (Partial View)

33.  Save the report as desired, by clicking the appropriate Save As button on the lower right toolbar. (Note that saving may result in a prompt from Access Manager, after which we will be walked through the setup of various items in Upfront. Upfront is beyond the scope of this article, but help can be found in the online help or within the documentation that is installed with the "typical" installation of the Cognos BI suite.)

We have examined only a handful of the options available in Cognos PowerPlay Web. Cognos PowerPlay is a powerful tool, and is, by far, the current leader in the business intelligence world in depth and breadth of analysis and reporting scope. The functionality available is both robust and easy to use. The zero-footprint interface we have reviewed is also a highly desirable attribute, in many environments, making both deployment and maintenance of the tool much easier than systems requiring client installations on the user PCs.

We will conclude our brief overview of PowerPlay Web reporting for an Analysis Services cube at this point. Much of the body of functionality that is available can be reviewed within the online documentation and other sources, just as it might be for a natively generated PowerCube.

Next in Our Series ...

In this lesson, Reporting Options for Analysis Services Cubes: Cognos PowerPlay, we explored features that integrate Analysis Services and Cognos PowerPlay to provide a vehicle for client reporting and other business intelligence pursuits. The central focus of the article was a basic overview of the steps involved in a simple (non-integrated security) connection of Cognos PowerPlay to a Microsoft Analysis Services cube, and then a high level overview of the use of PowerPlay for Windows and PowerPlay Web for the performance of analysis and reporting upon the Analysis Services OLAP data source.

In our next lesson, we will return to OLAP cube design and manipulation, and begin a new project: we will design and create a simple cube to analyze traffic data for a sample web site. We will construct tables for this purpose, and gain some exposure to the relational side of the cube life cycle in the process. Finally, we will discuss some of the eccentricities involved in constructing such a cube, and provide practical solutions for surmounting these challenges.

» See All Articles by Columnist William E. Pearson, III

Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum.

Introduction to MSSQL Server Analysis Services Series
Introduction to Security in Analysis Services
Cube Storage: Planning Partitions from a SQL Server Management Studio Perspective
Cube Storage: Planning Partitions (Business Intelligence Development Studio Perspective)
Cube Storage: Introduction to Partitions
Introduction to Cube Storage
Attribute Discretization: Customize Grouping Names
Attribute Discretization: Using the "Clusters" Method
Attribute Discretization: Using the "Equal Areas" Method
Attribute Discretization: Using the Automatic Method
Introduction to Attribute Discretization
More Exposure to Settings and Properties in Analysis Services Attribute Relationships
Attribute Relationships: Settings and Properties
Introduction to Attribute Relationships in MSSQL Server Analysis Services
Attribute Member Values in Analysis Services
MSSQL Analysis Services - Attribute Member Names
Attribute Member Keys - Pt II: Composite Keys
Attribute Member Keys - Pt 1: Introduction and Simple Keys
Dimension Attributes: Introduction and Overview, Part V
Dimension Attributes: Introduction and Overview, Part IV
Dimension Attributes: Introduction and Overview, Part III
Dimension Attributes: Introduction and Overview, Part II
Dimension Attributes: Introduction and Overview, Part I
Dimensional Model Components: Dimensions Part II
Dimensional Model Components: Dimensions Part I
Manage Unknown Members in Analysis Services 2005, Part II
Manage Unknown Members in Analysis Services 2005, Part I
Alternatively Sorting Attribute Members in Analysis Services 2005
Introduction to Linked Objects in Analysis Services 2005
Distinct Counts in Analysis Services 2005
Positing the Intelligence: Conditional Formatting in the Analysis Services Layer
Administration and Optimization: SQL Server Profiler for Analysis Services Queries
Mastering Enterprise BI: Time Intelligence Pt. II
Mastering Enterprise BI: Time Intelligence Pt. I
Design and Documentation: Introducing the Visio 2007 PivotDiagram
Actions in Analysis Services 2005: The URL Action
Actions in Analysis Services 2005: The Drillthrough Action
Mastering Enterprise BI: Introducing Actions in Analysis Services 2005
Mastering Enterprise BI: Introduction to Translations
Mastering Enterprise BI: Introduction to Perspectives
Introduction to the Analysis Services 2005 Query Log
Mastering Enterprise BI: Working with Measure Groups
Mastering Enterprise BI: Introduction to Key Performance Indicators
Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II
Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. I
Process Analysis Services Objects with Integration Services
Usage-Based Optimization in Analysis Services 2005
Introduction to MSSQL Server Analysis Services: Named Sets Revisited
Introduction to MSSQL Server Analysis Services: Migrating an Analysis Services 2000 Database to Analysis Services 2005
Introduction to MSSQL Server Analysis Services: Introducing Data Source Views
Introduction to MSSQL Server Analysis Services: Reporting Options for Analysis Services Cubes: MS Excel 2003 and More ...
Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Create Aging "Buckets" in a Cube
Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II
Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube
Introduction to MSSQL Server Analysis Services: Process Analysis Services Cubes with DTS
Introduction to MSSQL Server Analysis Services: Presentation Nuances: CrossTab View - Same Dimension
Introduction to MSSQL Server Analysis Services: Point-and-Click Cube Schema Simplification
Introduction to MSSQL Server 2000 Analysis Services: Manage Distinct Count with a Virtual Cube
Introduction to MSSQL Server 2000 Analysis Services: Distinct Count Basics: Two Perspectives
Introduction to MSSQL Server 2000 Analysis Services: Semi-Additive Measures and Periodic Balances
Introduction to MSSQL Server 2000 Analysis Services: Performing Incremental Cube Updates - An Introduction
Introduction to MSSQL Server 2000 Analysis Services: Partitioning a Cube in Analysis Services - An Introduction
Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Design
Introduction to MSSQL Server 2000 Analysis Services: Derived Measures vs. Calculated Measures
Introduction to MSSQL Server 2000 Analysis Services: Creating a Dynamic Default Member
Introduction to MSSQL Server 2000 Analysis Services: Another Approach to Local Cube Design and Creation
Introduction to MSSQL Server 2000 Analysis Services: Introduction to Local Cubes
Introduction to MSSQL Server 2000 Analysis Services: Actions in Virtual Cubes
Introduction to MSSQL Server 2000 Analysis Services: Putting Actions to Work in Regular Cubes
Introduction to MSSQL Server 2000 Analysis Services: Reporting Options for Analysis Services Cubes: ProClarity Part II
Introduction to MSSQL Server 2000 Analysis Services: Reporting Options for Analysis Services Cubes: ProClarity Professional, Part I
Introduction to MSSQL Server 2000 Analysis Services: Using Calculated Cells in Analysis Services , Part II
Introduction to MSSQL Server 2000 Analysis Services: Using Calculated Cells in Analysis Services, Part I
Introduction to MSSQL Server 2000 Analysis Services: MSAS Administration and Optimization: Toward More Sophisticated Analysis
Introduction to MSSQL Server 2000 Analysis Services: MSAS Administration and Optimization: Simple Cube Usage Analysis
Introduction to MSSQL Server 2000 Analysis Services: Build a Web Site Traffic Analysis Cube: Part II
Build a Web Site Traffic Analysis Cube: Part I
Reporting Options for Analysis Services Cubes: Cognos PowerPlay
Reporting Options for Analysis Services Cubes: MS FrontPage 2002
Reporting Options for Analysis Services Cubes: MS Excel 2002
Introduction to MSSQL Server 2000 Analysis Services: Drilling Through to Details: From Two Perspectives
Introduction to MSSQL Server 2000 Analysis Services: Custom Cubes: Financial Reporting - Part II
Introduction to MSSQL Server 2000 Analysis Services Custom Cubes: Financial Reporting (Part I)
Introduction to SQL Server 2000 Analysis Services: Exploring Virtual Cubes
Introduction to SQL Server 2000 Analysis Services: Working with the Cube Editor
Introduction to SQL Server 2000 Analysis Services: Parent-Child Dimensions
Introduction to SQL Server 2000 Analysis Services: Handling Time Dimensions
Introduction to SQL Server 2000 Analysis Services: Working with Dimensions
Introduction to SQL Server 2000 Analysis Services: Creating Our First Cube








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers