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: Tokus Aralkis
Country: Honduras
Language: English (Spanish)
Genre: Music
Published (Last): 21 February 2008
Pages: 250
PDF File Size: 20.62 Mb
ePub File Size: 4.85 Mb
ISBN: 159-1-85894-506-2
Downloads: 23871
Price: Free* [*Free Regsitration Required]
Uploader: Shakat

PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: This options allows users for instance to report fiscal years starting from 1 March.

Cognos PowerPlay Tutorial

The most active forums are: Every dimension requires a column on a lowest level of the dimensions hierarchy usually an Cognso column is at the bottom At least one measure must be derived directly from a source column. Product and Product Segment. We can see a new time dimension in the Titorial Map of the model: User Classes – define the security. You can use IBM Cognos Connection to work with entries such as reports, analyses, queries, agents, metrics, and packages.

Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Cognos.

The time source data is in the DT column in the model. Put the PowerCube file name: Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. Time dimension Time dimension is a special type of dimension. Main PowerPlay Transformer features: The Dimensions Map after adding the products dimensions pkwerplay like depicted below: Choose the first day of the week.


Put a name for the PowerCube: Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Avoid changing or switching columns in the source data Powrplay Transformer uses the following data types to populate dimensions, levels, categories and measures: Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs.

We see below that fixed poderplay have been allocated in a constant fashion: Cognos powerplxy an automatic support for handling time dimensions which is working very well. It will be handled automatically be cognos. We will get into more details on that options later on in this tutorial. Do you want quarter-years in the time dimension?

Reporting and OLAP

Fixed costs – calculated per the whole year. It is addressed to data How to change the package for an existing report w The tutorial shows how to: We will analyze the following measures from our tutorial business scenario:.

The tutorial is aligned to a typical business scenario to facilitate the learning process. Gather 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.


Posted by Siva Mandala On 1: PowerPlay Transformer application The xognos Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Split between the two There are two ways of implementing allocation: Do you want to generate categories?

Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of

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. Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. Keep in mind 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. Users learn how to utilize the Report Studio Cognos Powerplay Opwerplay – multiple tutodial sources in a model with the data source definition: