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: Dolkis Dakasa
Country: Bhutan
Language: English (Spanish)
Genre: Environment
Published (Last): 16 March 2014
Pages: 390
PDF File Size: 13.48 Mb
ePub File Size: 19.94 Mb
ISBN: 906-7-76834-258-7
Downloads: 84939
Price: Free* [*Free Regsitration Required]
Uploader: Mikalar

Do you want years in the dimension? It lets you examine many combinations of the key dimensions and measures in your data.

You can use IBM Cognos Connection to work with entries such as reports, analyses, queries, agents, metrics, and packages. Signons – datasource connection information. The tutorial shows how to: Prompt Expressions between R Each of the dimensions will have its own levels and categories and a single drill-down path.

IBM Cognos Transformer

Cognos Powerplay Transformer – multiple data sources in a model with pwerplay data source definition: Time dimension is a special type of dimension.

We see below that fixed costs have been allocated in a constant fashion: If a model contains multiple data sources, then the columns can be duplicated. Each source can be expanded and it lists all available columns. Do you want quarter-years in the time dimension?

Reporting and OLAP

Users learn how to utilize the Report Studio Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing User Classes – define poderplay security. Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. There are also 9 flash movies with guides on how to work with cognos.


About Me Siva Mandala.

It will be handled automatically be cognos. Newer Post Older Post Home. When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay.

Choose the first day of the week. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.

IBM Cognos Transformer

Solutions for issues and Tips on customizing the c Cognos Powerplay Transformer model for the palm nursery business scenario: The dimensions will have the following hierarchy: The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. This measure will be also allocated.

Keep in powerpllay that Cognos cubes are static and building a PowerCube is a repetitive process cubes may be refreshed every day, every month or even once a year.

Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. Tutoroal Transformer application The default Cognoss PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.

It is addressed to data Follow the steps below to add a new dimension:.

How to change the package for an existing report w Cognos provides an automatic support for handling time dimensions which is working very well. But at this stage we don’t want to have Customers grouped by Region, Country and then by Segment becuase it would be not intuitive for the end users. Other measures can be calculated. PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: To add measures to the model, follow the instructions below: Tutorrial it is required to perform allocation when part of the data is available only on a higher detail level than other data.


Copyright interview questions Design by: Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. The tutorial is aligned to a typical business scenario to facilitate the learning process.

Main PowerPlay Transformer features: We will analyze the following measures from our tutorial business scenario:. Poweprlay business users requirements Create a Model Plan which will include design and data requirements for the model and decide on the cube distribution methodology Select measures Plan dimensions and levels Design and develop the PowerPlay model in Transformer Create PowerPlay cubes and distribute them to the end users Analyze and explore the cube data using PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.

Cognos ReportNet navigation – with introduction, system navigation and Users can browse the source data by using Data Source Viewer. Managing Your Reports After you create one or more reports, you can manage them for yourself and others. It is located under Cognos menu entry and is divided into the following sections: