COGNOS POWERPLAY 6.0: Empowering Your Organization

PowerPlay allows users to view data in multi-dimensional formats. Thus,
gives decision-makers the power to explore various perspectives in the data,
often resulting in the exposure of hitherto-missed insights lying within the
data. It enables users to create applications that read source data and
manipulate it into a multi-dimensional presentation called a ‘cube’. Each
cube is in essence a datamart which provides the information that users need to
analyze their operations. By structuring source data to reflect the way an
organization operates and what its users need, an application can be created,
which provides timely and meaningful information.

Some possibilities with
PowerPlay are:

  • Comparing
    first-quarter sales over the past five years across locations.

  • Analyzing
    proportion of the total business by product over the years.

  • Viewing
    seasonal trends in business revenues over the past years.

  • Ranking
    products, customers, sales person’s performance over the past years and
    observing upward or downward movement of ranking.

  • Analyzing
    planned and actual business performance, and observing the variance over the
    past years.Every PowerPlay report consists
    of a cube, in its native .MDC format. Various dimensions within the report are
    presented in the dimension line. Each element in the dimension line is named a
    ‘dimension folder’. It is possible to explore each of the dimension folders
    contained within reports.

    With PowerPlay, it is possible to
    quickly move from one level of detail to another, exploring various aspects and
    perspectives of the data.

    Data can be sliced and diced to
    show revenue for each location over the past few months, or inventory levels for
    each branch of the organization at the end of the quarter. It is also possible
    to introduce data filters. For example, total revenue from all product lines may
    be modified to reflect revenue only from the north region for all product lines.

    Adding nested columns or rows is
    yet another way to generate fresh insights from within the data. It is possible
    to add nested dimensions easily by dragging a dimension folder to the row and

    With PowerPlay, the user may also
    change the measure used in the report. For example, information can be examined
    using, say, revenue measure and then, look at the same information using profit
    margin as the measure. The process is completely intuitive, with the need to
    remember complex formulae or even click through half a dozen icons, being

    PowerPlay Transformation Server (Admin): Rs60,000

    PowerPlay Transformation
    Server (End-user): Rs46,900

    Contact Details:
    Anandan G
    Deputy General Manager,
    BI Solutions, IIS Infotech
    D-1/3, Okhla Industrial Area,
     New Delhi – 110 020
    Tel:(011)692 9502-05, 6316214 
    Fax:(011)682 4694

    A small, but fairly comprehensive
    set of built-in graph formats complement drab-looking tables. All the popular
    graph formats–from line diagram, vertical bar charts, histograms to pie
    charts, are present.

    PowerPlay should be a useful addition to the
    business arsenal of multi-product, multi-location organizations seeking to hone
    business strategies based on past trends. PowerPlay’s uniqueness lies in its
    ability to do simple, pre-set operations with a minimum number of mouse clicks.
    However, pre-set options also restrict the analyses and hence, insights
    contained in the data could be lost too.

    Surendran Nambiath


Leave a Reply

Your email address will not be published. Required fields are marked *