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):||9 October 2008|
|PDF File Size:||14.95 Mb|
|ePub File Size:||15.87 Mb|
|Price:||Free* [*Free Regsitration Required]|
There are also 9 flash movies with guides on how to work with cognos. The dimensions will have the following hierarchy: The measure will be allocated. Split between the two It is a high Customers dimension with the source data preview: Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample rtansformer and a guide to develop data warehouse models in Cognos.
Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of
Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Do you want to generate categories?
Cognos Tutorials And Trainings. The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results.
Main PowerPlay Transformer features: Prompt Expressions between R The tutorial shows how to: Users learn how to utilize the Report Studio A Transformer Model can be also created using a wizard with AutoDesign function or manually. If a model contains multiple data sources, then the columns can be duplicated.
Time dimension is a special type of dimension. To add measures to the model, follow the instructions below: Enter ther first day of a particular year yyyymmdd – year value in this setting is not important.
IBM Cognos Transformer
Newer Post Older Post Home. This measure will be also allocated. User Classes – define the security. Users may filter the report, drill up, down, slice and dice and the figure will remain constant.
Do you want years in the dimension?
It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Variable costs – monthly detail level in a source data.
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. Cognos TransformerCognos Tutorial. Cognos ReportNet navigation – with introduction, system navigation and Follow the steps below to add a new dimension: Data sources recommendations Column names in a data source must be unique. If not needed, hutorial suggest to generate them based on the data and do not generate a category for each day.
This options allows users for instance to report fiscal years starting from 1 March. Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.
COGNOS Transformer tutorial ~ interview questions
We will analyze the following measures from our tutorial business scenario:. 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. Product and Product Segment. Fact less Fact Table? 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 Oowerplay A Transformer Model can be also created using a wizard with AutoDesign function or manually.
Do you want days in the time dimension?
The dimensions will have the following hierarchy:.