LinkedIn Discussion Group. On August 14, , Cognos BI As far as I can tell, this fix pack contains many code fixes and only one new feature: it is now possible to convert report pages to tabs in Report Studio. What are Dynamic Cubes? Dynamic cubes should not be considered as the evolution of PowerPlay cubes, as each technology excels for different use cases.
|Published (Last):||23 January 2007|
|PDF File Size:||7.39 Mb|
|ePub File Size:||10.17 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.
PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Each source can be expanded and it lists all available columns. 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. 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 columns can be duplicated.
Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. 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. 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? Yes 4. Do you want quarter-years in the time dimension? Yes 7. Do you want months in the time dimension? Yes 9. Yes Do you want days in the time dimension? No 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. 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: 1. 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.
The Dimensions Map after adding the products dimensions looks 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: 1.
Go to the PowerCubes window and press Insert key 2. Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data. 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 that figure, the corresponding 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 costs. Our goal is to be able to compare revenue to fixed and variable costs in all 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. The measure will be allocated. Variable costs - monthly detail level in a source data. This measure will be also allocated. Post a Comment. 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. Cognos Powerplay Transformer model for the palm nursery business scenario:.
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:. The time dimension levels in the PowerCube are depicted below:. Follow the steps below to add a new dimension:. Customers dimension with the source data preview:. Customer regions dimension:. The dimensions will have the following hierarchy:. The Dimensions Map after adding the products dimensions looks like depicted below:.
Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures. 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:. Fixed measure allocation:. We see below that fixed costs have been allocated in a constant fashion:.
Variable costs allocated dynamically by quantity:. Categories: Cognos Transformer , Cognos Tutorial. Newer Post Older Post Home. About Me Unknown View my complete profile. How to change 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? Total Pageviews. Powered by Blogger. Copyright interview questions Design by: Siva Mandala.
Cognos PowerPlay Transformer Tutorial
Structuring Your Data Into Di Modeling Your Key Performance PowerCubes in Production Envi Guidelines for Optimizing Pro
IBM Cognos User Manual
Digging into IBM Cognos Dynamic Cubes
IBM Cognos PowerPlay Transformer - Import - 7.1