Cognos Tutorials And Trainings Cognos PowerPlay Tutorial Cognos Movies Cognos Analysis Studio quick tour Cognos training space Cognos ReportNet. Cognos powerplay. 1. COGNOS – Powerplay; 2. The worlds best-selling OLAP software lets usersexplore volumes of data with. You use IBM® Cognos® PowerPlay® Studio to create and view reports that are based on PowerCube data sources. You access PowerPlay Studio from the IBM .

Author: Zule Kazimuro
Country: Anguilla
Language: English (Spanish)
Genre: Software
Published (Last): 4 December 2011
Pages: 56
PDF File Size: 15.67 Mb
ePub File Size: 20.55 Mb
ISBN: 241-7-50254-956-2
Downloads: 33618
Price: Free* [*Free Regsitration Required]
Uploader: Kagajinn

IBM Cognos Transformer

Each of the dimensions will have its own levels and categories and a single drill-down path. Solutions for issues and Tips on customizing the c CSV or Excel output limitatoins Cognos: It lets you examine many combinations of the key dimensions and measures in your data.

To add measures to the model, follow the instructions below:. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: The tutorial shows how to: In the following example we will analyze revenue, constant costs and variable costs.

This measure will be also allocated.

IBM Cognos Transformer

You can change the report properties so the default action is to open the report in PDF format in a Report Cogmos.

How to treat a week which spans a month? Cognos Tutorials And Trainings.

Main PowerPlay Transformer features: User Classes – define the security. Managing Your Reports After you create one or more reports, you can manage them for yourself and others. Users learn how to utilize the Report Studio Product and Product Segment. Fixed costs – calculated per the whole year.


Cognos PowerPlay Tutorial

The final model structure is shown below: First a percent of total of a poweplay base measure is calculated and based on that figure, the corresponding values for allocated measure are calculated. We will analyze the following measures from our tutorial business scenario: Users may filter the report, drill up, down, slice and dice and the figure will remain constant.

We will analyze the following measures from our tutorial business scenario:.

Variable costs – monthly detail level in a source data. Prompt Expressions between R If not needed, we suggest to generate them based on the data and do not generate a category for each day. Time dimension Time dimension is a special type of dimension. Do you want days in the time dimension? Both viewers provide access to report options such as drill through and the ability to open the report in PowerPlay Studio.

PowerCubes provide secure and fast data access. The data source properties window also allows users to choose the datasource type, point to the right file or database server tutodial set up a number of processing options, tutoriwl There are two ways of implementing allocation: Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.


The dimensions will have the following hierarchy:. Do you want quarter-years in the time dimension? Customers and Customer Region. This options allows users for instance to report fiscal years starting from 1 March. It is located under Cognos menu entry and is divided into the following sections: It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Choose the first day of the lowerplay. The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results.

Fact less Fact Table? To create a new report, you open a package in PowerPlay Studio, select the data and format for the report, and then save the report to IBM Cognos Connection.

You can determine the impact that powerplau area of your business has on overall results and compare that with other dimensions as you explore and analyze further. To add measures to the model, follow the instructions below: It will be handled automatically be cognos.

Do you want years in the dimension?

Previous post: