IBM Cognos Analytics and older do not have a version 11 release of Powerplay Transformer for designing and building Powercubes. calculated measure, and a PowerCube Experienced IBM Cognos Transformer in IBM Cognos PowerPlay client, we identify a number of issues with. Problems when Modeling in IBM Cognos Transformer. When a user opens the cube in PowerPlay or one of the IBM Cognos studios, the system verifies that .
|Published (Last):||7 July 2012|
|PDF File Size:||3.53 Mb|
|ePub File Size:||8.65 Mb|
|Price:||Free* [*Free Regsitration Required]|
PowerCubes provide secure and fast data access. 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.
Main PowerPlay Transformer features: 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 powerplya and distribute them to the end users Analyze and explore the cube data using Transfor,er A Transformer Model can be also created using a wizard with AutoDesign function or manually.
PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the transgormer screenshots below.
Each source can be expanded and it lists all available columns.
Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of
Users can browse the source data by using Data Source Viewer. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. User Classes – define the security. Signons – datasource connection information.
Cognos Powerplay Transformer model for the palm nursery business scenario: Source data typically comes from a data warehouse, sometimes from production ERP system and in many cases includes multiple sources in order to deliver information required by the model. Data sources recommendations Column names in a data source must be unique. If a model contains multiple data sources, then the clgnos can be duplicated. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
Cognos PowerPlay Transformer – Models and Cubes
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. Other measures can be calculated. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: The data source properties window also allows users to choose the datasource type, point to the right file or database server and set up a number of processing options, like: We will get into more details on that options later on in this tutorial.
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 source data is in the DT column in the model. Time dimension Time dimension is a special type of dimension. Cognos provides an automatic support for handling time dimensions which is working very well. Do you want years in the dimension?
Do you want quarter-years in the time dimension? Do you want months in the time dimension? Do you want days in the time dimension? Choose the first day of the week.
How to treat a week which spans a month? Split between the two Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. This options allows users for instance to report fiscal years starting from 1 March. Do you want to generate categories? If not needed, we suggest to generate them based on the data and do not generate a category for each day. The time dimension levels in the PowerCube are depicted below: Customers and Customer Region. Each of the dimensions will have its own levels and categories and a single drill-down path.
Follow the steps below to add a new dimension: Customers dimension with the source data preview: 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.
PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Product and Product Segment. The dimensions will have the following hierarchy: The Dimensions Map after adding the products dimensions powfrplay like depicted below: Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.
When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay. To add measures to the model, follow the instructions below: Define an output PowerCube 1.
Go to the PowerCubes window and press Insert key 2. Put a name for the PowerCube: Put the PowerCube file name: Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data.
There are two ways of implementing allocation: Users may filter the report, drill up, down, slice and dice and the figure will remain constant. First a percent of total of a allocation base measure is calculated and based on cognoss figure, the cognls values for allocated measure are calculated. Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable powerplau. Our goal is to be able to compare revenue to fixed and variable costs in transfodmer the time dimension levels available.
We will analyze the following measures from our tutorial business scenario: Gross revenue – the source data stores sales records on a daily basis. It will be handled automatically be cognos. Fixed costs – calculated per the whole year.
powerpplay The measure will be allocated. Variable costs – monthly detail level in a source data. This measure will be also allocated. We see below that fixed costs have been allocated in a constant fashion: Variable costs allocated dynamically by quantity: Posted by Siva Mandala On 1: 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 trandformer below. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Time dimension is a special type of dimension. We can see a new time dimension in the Dimension Map of the model: Follow the steps below ckgnos add a new dimension:.
Cognos PowerPlay Transformer Tutorial
The dimensions will have the following hierarchy:. To add measures to the model, follow the instructions below:. The final model structure is shown below: There are two ways of implementing allocation:.
In the following example we will analyze revenue, constant costs and variable costs. We will analyze the following measures from our tutorial business scenario:.
Cognos TransformerCognos Tutorial. Newer Transforemr Older Post Home. About Me Siva Mandala. How to tramsformer the package for an existing report w Solutions for issues and Tips on customizing the c Different type of Cognos Logs.
Use Cognos 10 Business Insight-Preview and highlig Fact less Fact Table? Prompt Expressions between R CSV or Excel output limitatoins Cognos: Copyright interview questions Design by: