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):||7 October 2007|
|PDF File Size:||2.72 Mb|
|ePub File Size:||5.42 Mb|
|Price:||Free* [*Free Regsitration Required]|
Signons – datasource connection information.
There are also 9 flash movies with guides on how to work with cognos. Copyright interview questions Design by: The dimensions will have the following hierarchy:. There are two ways of implementing allocation: Follow the steps below to add a new dimension:. Each of the dimensions will have its own levels and categories and a single drill-down path.
Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of
This measure will be also allocated. The data source properties window also allows users to choose the datasource type, point to powerplayy right file or database server and set up a number of processing options, like: User Classes – define the security.
How to change the package for an existing report w Go to the PowerCubes window and press Insert key 2. Customers and Customer Region.
IBM Cognos Transformer
Product and Product Segment. Each source can be expanded and tutorila lists all available columns. We will analyze the following measures from our tutorial business scenario:.
The final model structure is shown below: Split between tansformer two Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing The most active forums are: Cognos provides an automatic support for handling time dimensions which is working very well. Cognos TransformerCognos Tutorial. In the following example we will analyze revenue, constant costs and variable costs.
Cognos ReportNet navigation – with introduction, system navigation and Newer Post Older Post Home. Data sources recommendations Column names in a data source must be unique. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: 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.
It is a high Choose the first day of the week. To add measures to the model, follow the instructions below: The time dimension levels in the PowerCube are depicted below: The measure will be allocated.
Reporting and OLAP
There are two ways of implementing allocation:. This options allows users for instance to report fiscal years starting from 1 March.
PowerPlay Transformer Guide – Products dimension In this lesson we will transforer two additional dimensions: Do you want quarter-years in the time dimension? It is addressed to data 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.
Users learn how cognso utilize the Report Studio Use Cognos 10 Business Insight-Preview and highlig Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: