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: Tamuro Mezilmaran
Country: Luxembourg
Language: English (Spanish)
Genre: Music
Published (Last): 3 March 2008
Pages: 121
PDF File Size: 17.85 Mb
ePub File Size: 2.9 Mb
ISBN: 320-8-42958-141-8
Downloads: 29380
Price: Free* [*Free Regsitration Required]
Uploader: Nami

The dimensions will have the following hierarchy:. If a model contains multiple data sources, then the columns can be duplicated.

PowerPlay Studio

Optionally, for PowerCube data sources, the administrator can choose to automatically generate a package when they create the data source connection, eliminating the need to create the package in Framework Manager.

How to treat a week which spans a month? How to change the package for an existing report w Cognos Powerplay Transformer model for the palm nursery business scenario: Variable costs allocated dynamically by quantity: The time source data is in the DT column in the model.

Fact less Fact Table?

It will be handled automatically be cognos. Enter ther first day of a particular year yyyymmdd – year value in this setting futorial not important. Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing Both viewers provide access to report options such as drill through and the ability to open the report in PowerPlay Studio. The final model structure is shown below: Data sources recommendations Column names in a data source must be unique.


We will analyze the following measures from our tutorial business scenario: The hutorial is aligned to a typical business scenario to facilitate the learning process. About Me Siva Mandala.

When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay. Main PowerPlay Transformer features: A Transformer Model can be also created tutorual a wizard with AutoDesign function or manually.

The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results. Do you want years in the dimension?

Reporting and OLAP

Solutions for issues and Tips on customizing the c Avoid changing or switching columns in the source data Powerplaay Transformer uses the following data types to populate dimensions, levels, categories and measures: To add measures to the model, follow the instructions below:. Source data typically comes from a data warehouse, sometimes from production ERP system and in many cases includes multiple sources in order to deliver information required by the model.

Go to the PowerCubes window and powerplah Insert key 2. It is addressed to data Users can browse the source data by using Data Source Viewer. The measure will be allocated.


Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Cognos. This options allows users for instance to report fiscal years starting from 1 March. Different type of Cognos Logs.

Cognos PowerPlay Tutorial

We will get into more details on that options later on in this tutorial. Regardless of the default action setting, a report consumer can choose tutorlal open the report in either PDF format or interactive format. It is tutoriall high User Classes – define the security.

PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.

Dimensions and underlaying Levels are created by moving columns tutprial the Data Sources window to the corresponding dimension column. 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.