Cognos PowerPlay® Overview

PowerPlay® is the world's leading multidimensional analysis software for managers.  The world's best-selling OLAP software lets users explore volumes of data with sub-second response.

Decision makers can explore and understand corporate data faster and more easily.

What is PowerPlay?

  • Windows and Macintosh based reporting and analysis tool for managers

  • Gives decision makers high-speed navigation of multi- dimensional information

What are PowerPlay's main features?

  • Reduced development cost

  • No code; no programming

  • Productivity in 20 minutes

  • Portability and performance

View the PowerPlay Guided Tour

NB. To run the tour, you'll need the Macromedia Flash plug-in

Cognos PowerPlay is the world's best-selling OLAP (online analytical processing) software. It enables users to explore large volumes of summarized data with sub-second response times in a Web, Windows, or Excel environment. With Cognos PowerPlay, users at any business or technical skill level in a company can perform their own multidimensional analysis, create reports, and share them for better decision-making.

Cognos PowerPlay draws information from relational databases to model and build PowerCubes ("Cubes"). Cubes are data sets that can contain tens of millions of consolidated rows of data and hundreds of thousands of categories (members). Business rules and calculations (for example, percentage growth and market share change) can be built right into them, and time series analysis is delivered automatically. Cubes and reports can be deployed to Web clients, or to Windows and Excel clients, all using the same application server.

Cognos PowerPlay provides both a multidimensional data store and a feature rich end-user experience. Its multi-server, load-balanced architecture is easy to install and manage, and it scales to thousands of users.

Effortless Data Exploration The Cognos PowerPlay OLAP tool delivers advanced data analysis capabilities for enterprise data marts, and integrates with the comprehensive Cognos business intelligence solution.

Analyse what's driving your business multi-dimensionally - using intuitive information groupings and categories.

PowerPlay data is organized under logical "dimensional" headings such as fiscal periods, sales regions, and product groups - whatever makes the most sense in your business context. Explore the dimensions that are key to your business success by pointing, clicking, and dragging the information in dynamic, interactive reports.

Three simple but powerful capabilities allow users to analyse business data from any point of view:

  • Drill down. Gain fast answers to critical business questions by easily moving from one level of information to the next.

  • Slice-and-dice. Interactively explore corporate data in any combination, from every conceivable angle.

  • Graphical analysis. Choose from a wide range of graphical displays to explore the key factors driving the business.

In addition to these basic features, PowerPlay offers the broadest range of features for data exploration, including:

  • Ranking and Sorting: Quickly rank or sort data to determine your top-to-bottom, best-to-worst performers.

  • Drill Through. From within published reports, drill through to other related reports and PowerCubes easily, by clicking a button. Additionally, drill through from summary PowerPlay OLAP reports to view underlying transactional detail in either Cognos Query or Impromptu Web Reports.

  • Filtering. Users can create focused reports that show the exact level of information desired. The 80/20 filter automatically groups all categories that amount to less than 20% of a row total or column into an "Other" category.

  • Exception Highlighting. Automatic exception highlighting clearly shows values in a report that is above or below a value range.

  • Subsets. Create the logical groupings of information that you require, based on criteria like pattern matches and value thresholds.

  • Nested crosstabs and charts. Easily nest rows and columns both within dimensions and across multiple dimensions.

TOP TEN FEATURES AND BENEFITS OF POWERPLAY

1.

Effortless data exploration

Use PowerPlay to analyse what's driving your business. PowerPlay lets you explore multidimensional information by simply pointing, clicking and dragging. Drill down through increasing levels of detail, then slice and dice to view different dimensions, such as sales by region by product. View and analyse data relationships graphically and change between different displays.

2.

Powerful Report Writing

Turn analyses into accurate, high-impact business reports at the touch of a button. Create effective KPI and Balanced Scorecard reports that are dynamic. Use these reports to manage, monitor and improve the business.

3.

Data presented in a business context

PowerPlay presents information the way managers view their business. Data can be organized under logical headings such as fiscal periods, sales regions, and product groups – whatever makes the most sense in your business context. This makes exploration and analysis easier to learn, and increases user acceptance.

4.

Analyse-then-Query

Seamlessly drill through to Cognos Impromptu to uncover the transaction-level data behind trends. Users can view additional attribute information as well as details contained in the PowerCube.

5.

Clients for every User’s Needs

PowerPlay meets the needs of your diverse user community with a full range of OLAP clients, offering a complete enterprise OLAP solution that meets the specific requirements of your organization. Users work with Web, Windows, or Excel clients-WAN, LAN-connected or remote-to effortlessly access multidimensional data and use PowerPlay’s superior analysis and reporting capabilities.

Administration Features and Benefits

1.

Single OLAP Application Server

PowerPlay Enterprise Server is a single OLAP application server for Web, Windows, and Excel clients. It simplifies administration, centralizes security and control, and effectively minimizes cost of ownership. PowerPlay enables you to deploy OLAP across the entire enterprise-quickly and cost-effectively.

2.

Universal OLAP

PowerPlay offers universal OLAP by giving direct access to Cognos OLAP structures, as well as cubes in Arbor Essbase, IBM OLAP for DB2, and Microsoft OLAP Services. And Cognos PowerCubes can be stored anywhere – locally, on the LAN, or in a relational database.

3.

Enterprise-wide scalability

From a single user to thousands, PowerPlay's scalability can handle it all. Cognos' PowerCubes are highly compressed and can contain data mart sized volumes of data. And users can drill from cube to cube to access the full range of enterprise data.

4.

Security and control

Administrators can easily define and govern the data that each user is permitted to access or analyse based on User Class security. User Class security also allows one PowerCube to serve the diverse requirements of many users. Administrators can create a single cube and distribute it to remote and mobile users, while retaining the desired level of security.

5.

Leverage client and server investment

PowerPlay can build and store cubes on Windows 95/98 and NT, as well as UNIX servers. Administrators can model the cube on the client, and then create the PowerCube on either the client or the server. PowerCubes can be stored within a relational database such as Oracle, IBM DB2, Informix, Sybase, and Microsoft SQL Server.

PowerPlay in Action...

These business intelligence tools present data in a context critical to understanding what's happening in any area of responsibility and lets users know exactly what's driving their business.

Users can immediately explore, rank, trend, drill-down, or slice-and-dice their corporate data. All the most popular reporting facilities for managers are instantly available in PowerPlay's off-line simplicity, versatility and power make it possible to examine everything that drives sales, margins, customer service, costs, quality, and more.

For instance, by simply clicking on a graph legend item such as product 'X', a preset measure such as profit, and a time field such as year, and dragging each onto a chart or cross-tab axis, you instantly see a view of profit by product 'X' by each month in that year! A PowerPlay bureau service is also available from Technologies4Targeting.

PowerPlay, an off-line, easy-to-use, reporting/presentation tool requires only minimum end-user training. It is ideal for the busy marketer, sales administrator, product manager, financial controller, business analyst, production supervisor, etc., each having their own specially prepared 'data cube' on which to drill-down, query and report.

Should a company not have the internal resources or prefer not to re-deploy or train IT staff to build PowerPlay systems, then Technologies4Targeting would be pleased to assist.

After detailed discussion with each end user, we would define the content and drill-down requirements for the 'data cubes' and help build the templates. As part of a regular update procedure, compressed extracts from the analytical database could be prepared and forwarded to you on CD, floppy disk or electronically, usually on a weekly or monthly basis.

Instantly key management will have the latest business facts at their disposal, and in a format they understand and can act upon! And for data-mining with PowerPlay we also offer  4Thought. This is based on a neural network engine and is ideal for both predictive modelling and forecasting.

Superior Analysis and Reporting for Every User

PowerPlay summarizes and presents corporate data the way users understand their business-units shipped on time per city by air, sales per branch by region, and so on.

Effortless Data Exploration

  • Drill down and slice and dice to view data in any combination

  • Analyse trends over time

  • Highlight exceptions with ease

  • Convert currency on the fly

  • Rank and compare results

  • Visualize data graphically in 2D and 3D charts

  • Use graphs and crosstabs in one display

  • Explore data the way you think—identify and understand trends and patterns first, then drill through to Cognos Impromptu for the underlying details

Powerful OLAP Reporting

  • Generate business performance, KPI, and scorecard-style reports

  • Create balanced and unbalanced nested crosstabs

  • Include categories from multiple dimensions in a row or column

  • Format data for financial reports like income statements

  • Build reports that accommodate changes to the underlying cube structure

  • Create narrowcast reports where one cube supports many reports and user classes

  • Publish reports to HTML

  • Generate macros automatically

A Client for Every User

  • PowerPlay for Windows offers advanced OLAP functionality for in-depth analysis and OLAP report authoring and viewing.

  • PowerPlay Web is a zero-footprint, HTML-only Web client for all essential OLAP analysis and report viewing that requires little or no user training.

  • PowerPlay for Excel brings full OLAP analysis and reporting power to users who prefer to work with Microsoft Excel spreadsheets.

  • All clients are installed and upgraded centrally.

Unmatched Deployability

PowerPlay Enterprise Server is a single, scalable OLAP application server for Web, Windows, and Excel users. It supports a mixed hardware environment, and runs on both UNIX and NT.

Central Data Management

  • Enable users to access cubes centrally

  • Maintain cubes from one point of control for all users

Enterprise Scalability

  • Scale to thousands of users through multi-tier processing with automatic load balancing

  • Enable Web users to view OLAP data in their language and regional settings of choice with full multilingual server support

Central Security and Control

  • Store security information in a central secure repository

  • Incorporate secure user classes to easily serve the diverse needs of many users with a single cube

PowerPlay Personal Server

This single-user OLAP application engine for Windows and Excel users provides full access to PowerCubes, in-database PowerCubes, and third-party cubes for users who are working offline, travelling, or working remotely. Users store and process OLAP cubes right on their PCs.


Universal OLAP

In addition to its own PowerCubes, PowerPlay Enterprise Server lets you easily access third-party cubes, including Hyperion Essbase, IBM DB2 OLAP, as well as Microsoft OLAP Services and other OBDO-compliant cube servers.


Multidimensional Data Modelling

PowerCubes scale to store data mart-sized data sets (over 50 million consolidated rows of data and up to 500,000 categories) but are highly compressed—so they are easy to build, update, and distribute.

Easy Cube Building

  • Model data quickly and easily within the PowerPlay Transformation Server's intuitive graphical interface

  • Quickly create highly compressed PowerCubes within a daily update window

  • Schedule cube building to run automatically

  • Move processing to off-peak hours to reduce network traffic

Business Rules in Cubes

  • Build business rules and calculations like percentage growth and market share right into the PowerCube so everyone in the organization is defining data consistently

Harness All of the Data

  • Populate PowerCubes with both relational and non-relational data from multiple sources like databases, data warehouses, data marts, and spreadsheets

Leverage Your Current Technology Investment

  • Build and store cubes on UNIX or NT servers, in relational databases, and on mobile users’ PCs

Powerful Capabilities

  • Easily incorporate customized time dimensions

  • Maintain calendar and fiscal time periods in the same dimension

  • Define multiple drill-down paths for alternate views of the business

  • Use category counts to enumerate distinct instances of items

Technical Specifications

Hardware Requirements

  • IBM PC 486 or greater

  • 16 MB RAM (minimum)

  • 36 MB free hard disk space

Windows Platforms

  • Windows 98/NT/2000/2003/XP

UNIX Platforms

  • HP/UX, IBM AIX, Sun Solaris, DEC UNIX, Siemens SINIX

In-Database PowerCube Support

  • Any Informix, Oracle, Sybase SQL Server, or Microsoft SQL Server platform; IBM DB2 Common Server 2.1; and IBM DB2 Universal Database 5.0

Third Party OLAP Server Support

  • Arbor Essbase, Oracle Express, IBM DB2 OLAP, Microsoft OLAP Services


© Tech4T (Technologies4Targeting Ltd.) 2002/2004 All Rights Reserved.  www.tech4t.co.uk