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):||26 September 2009|
|PDF File Size:||9.67 Mb|
|ePub File Size:||5.59 Mb|
|Price:||Free* [*Free Regsitration Required]|
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. Cognos ReportNet navigation – with introduction, system navigation transrormer User Classes – define the security. Enter ther first day of a particular year yyyymmdd – year value in this setting is not important.
COGNOS Transformer tutorial ~ interview questions
transformdr Variable costs – monthly detail level in a source data. We see below that fixed costs have been allocated in a constant fashion: Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Each of the dimensions will have its own levels and categories and a single drill-down path.
Users can browse the source data by using Data Source Viewer. Put the Cognoa file name: If not needed, we suggest to generate them based on the data and do not generate a category for each day.
Reporting and OLAP
Data sources recommendations Column names in a data source must be unique. CSV or Excel output limitatoins Cognos: 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. The tutorial shows how to: Fixed costs – calculated per the whole year.
Define an tuhorial PowerCube 1. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
A Transformer Model can be also created using a wizard with AutoDesign function or manually. Do you want months in the time dimension?
It will be handled automatically be cognos. To add measures to the model, follow the instructions below: Copyright interview questions Design by: Variable costs allocated dynamically by quantity: Do you want days in the time dimension?
IBM Cognos Transformer
Cognos Powerplay Transformer model for the palm nursery business scenario: Other measures can be calculated. There are two ways of implementing allocation:.
Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: How to treat a week which spans a month? The measure will be allocated.
The final model structure is shown below: Main PowerPlay Transformer features: Split between the two The Dimensions Map after adding the products dimensions looks like depicted below: