|

|
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?
What are PowerPlay's main features?
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
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
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
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
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
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
Windows Platforms
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
|


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