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):||10 June 2015|
|PDF File Size:||19.35 Mb|
|ePub File Size:||17.95 Mb|
|Price:||Free* [*Free Regsitration Required]|
Time dimension Time dimension is a special type of dimension. Cognos TransformerCognos Tutorial. Thanks Andrew for the response.
Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.
Cognos PowerPlay Transformer Tutorial
A Transformer Model can be also created using a wizard with AutoDesign function or manually. Fact less Fact Table? You must have Transformer to build cubes. Keep in mind that Cognos cubes are static and building a PowerCube is a repetitive process cubes coghos be refreshed every day, every month or even once a year. Variable costs allocated dynamically by quantity: If a model contains multiple data sources, then the columns can be duplicated.
There are two ways of implementing allocation: Customers dimension with the source data preview: Time dimension is a special type of dimension. The measure will be allocated. Copyright interview questions Design by: PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. The time source data is in the DT column in the model.
Use Cognos 10 Business Insight-Preview and highlig 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. Signons – datasource connection information.
Cognos PowerPlay Transformer tutorial for modelers and datawarehouse developers
Andrew 5, 1 13 Main PowerPlay Transformer features: We can see a new time dimension in the Dimension Map of the model: 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. Cognos Powerplay Transformer model for the palm nursery business scenario: Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.
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. Posted by Siva Mandala On 1: Sign up or log in Sign up using Google. I don’t really see any need for the other two.
Users may filter the report, drill up, down, slice and dice and the figure will remain constant. It will be handled automatically be cognos. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Cognos Powerplay Client 2. PowerCubes – you can specify here a list of cubes created by the model. How to treat a week which spans a month?
Do you want quarter-years in the time dimension? Go to the PowerCubes window and press Insert tranxformer 2. Follow the steps below to add a new dimension: How you intend for your users to interact with the cubes determines what you need.
Gross revenue – the source data stores sales records on a daily basis.
I have the installation powrplay for the below three, but not sure if these need to be installed and if so in which order. In the following example we will analyze revenue, constant costs and variable costs. Cognos provides an automatic support for handling time dimensions which is working very well. Follow the steps below to add a new dimension:. 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.
Data Sources – a list of all connected data sources. Do you want years in the dimension?