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):||4 May 2009|
|PDF File Size:||20.53 Mb|
|ePub File Size:||5.22 Mb|
|Price:||Free* [*Free Regsitration Required]|
Define an output PowerCube 1.
We will group the data by year in the highest hierarchy level and the most detailed level in the time dimension will be a week. The time dimension levels in the PowerCube are depicted below: Main PowerPlay Transformer features: Tuforial measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.
Solutions for issues and Tips on customizing the c We can see a new cgonos dimension in the Dimension Map of the model: Piwerplay you want months in the time dimension? To add measures to the model, follow the instructions below: First a percent of total of a allocation base measure is calculated and based on that figure, the corresponding values for allocated measure are calculated.
COGNOS Transformer tutorial ~ interview questions
Follow the steps below to add a new dimension: 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 tranfsormer 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.
CSV or Excel output limitatoins Cognos: Time dimension Time dimension is a special type of dimension.
It is addressed to data In the following example we will analyze revenue, constant costs and variable costs. PowerCubes provide secure and fast data access. If not needed, we suggest to generate them based on the data and do not generate a category for each day. Power;lay – datasource connection information. There are also 9 flash movies with guides on how to work with cognos.
Reporting and OLAP
Do you want days in the time dimension? Cognos Powerplay Transformer model for the palm nursery business scenario: Follow the steps below to add a new dimension:.
Use Cognos 10 Business Insight-Preview and ttansformer Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.
Cognos Tutorial Trainings Powerplay Movies Analysis Studio Quick
It gives a brief overview of Cognos Impromptu and explains how to connect to a data mart and explore data. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
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. Time dimension is a special type cohnos dimension. Enter ther first day of a particular year yyyymmdd – year value in this setting is not important.
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. To add measures to the model, follow the instructions below:. Cognos provides an automatic support for handling time dimensions which is working very well. Users may filter the report, drill up, down, slice and dice and the figure will remain constant.
Cognos ReportNet navigation – with introduction, system navigation and