COGNOS POWERPLAY TRANSFORMER TUTORIAL PDF
How is IBM Cognos PowerPlay Studio Different from IBM Cognos Series 7 .. through in a cube using Transformer, with any additional settings configured in. PowerPlay Transformer is a Cognos component used to define OLAP cubes structure and data (in PowerPlay models) and build the multidimensional analysis. COGNOS – Powerplay. Powerplay Transformer combines all of the data into a summarized format called a PowerCube.• The PowerCube.
|Published (Last):||6 September 2012|
|PDF File Size:||11.69 Mb|
|ePub File Size:||14.65 Mb|
|Price:||Free* [*Free Regsitration Required]|
To add measures to the model, follow the instructions below: Users learn how to utilize the Report Studio Copyright interview questions Design by: PowerPlay Transformer Guide – Products dimension In this lesson powfrplay will create two additional dimensions: 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.
The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.
Using Cognos Transformer to Convert a Single Table (or Query) Source into a Data Cube
Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data.
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 can browse the source data by using Data Source Viewer. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Cognos ReportNet navigation – with introduction, system navigation and Users may filter the report, drill up, down, slice and dice and the figure will remain constant.
It will be handled automatically be cognos. If not needed, we suggest to generate them based on the data and do not generate a category for each day.
Other measures can be calculated. How to change the package for an existing report w Each of the dimensions will have its own levels and categories and a single drill-down path. The data source properties window also allows users to choose the datasource type, point to the right file or database server and set up tjtorial number of processing options, like: Prompt Expressions between R There are two ways of implementing allocation:. Data sources recommendations Column names in a data source must be unique.
Follow the steps below to add a new dimension: User Classes – define the security.
The tutorial is aligned to a typical business scenario to facilitate the learning process. Put the PowerCube file name: This options allows users for instance to report fiscal years starting from 1 March.
IBM Cognos Transformer
Main PowerPlay Transformer features: It is addressed to data Insert data into an empty crosstab, nest, replace, sort data in a transcormer Explore data by changing Poaerplay and Customer Region. Define an output PowerCube 1. Split between the two Enter ther first day of a particular year yyyymmdd – year value in this setting is not important.
Every dimension requires a column on a lowest level of the dimensions hierarchy usually an ID column is at the bottom At least one measure must be derived directly from a source column.
Different type of Cognos Logs. It gives a brief overview of Cognos Impromptu pkwerplay explains how to connect to a data mart and explore data. Tutkrial by Siva Mandala On 1: Time dimension is a special type of dimension.
We will analyze the following measures from our tutorial business scenario:. Do you want to generate categories? To add measures to the model, follow the instructions below:. There are also 9 flash movies with guides on how to work with cognos.
Reporting and OLAP
Cognos Tutorials And Trainings. Variable costs allocated dynamically by quantity: The final model structure is shown below: Powerplzy Dimensions Map after adding the products dimensions looks like depicted below: Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.
PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. Measures allocation real-life example in Cognos In the following example we will analyze revenue, transforjer costs and variable costs.
Do you want years in the dimension?