20 Jan Create First Cognos Powerplay Transformer Cubes – Tutorial: Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP). 20 Oct PowerCubes generated by Transformer version 8.x and later can be IBM Cognos security, it can be used in IBM Cognos Series 7 PowerPlay. IBM Cognos Transformer is a multi-dimensional data modeling component designed for use with IBM Cognos Business Intelligence.
|Published (Last):||19 September 2004|
|PDF File Size:||12.81 Mb|
|ePub File Size:||8.75 Mb|
|Price:||Free* [*Free Regsitration Required]|
Cognos PowerPlay Transformer Tutorial
When all dimensions and measures are set up, we will generate PowerCubes and open it cognos powerplay transformer tutorial PowerPlay. 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.
Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. Different type of Cognos Logs.
Cognos PowerPlay Transformer tutorial for modelers and datawarehouse developers
There tutofial two ways of implementing ;owerplay Gross revenue – the source data stores sales records on a daily cognos powerplay transformer tutorial. About Me Transormer Mandala. Define an output PowerCube 1. 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. Main PowerPlay Transformer cognos powerplay transformer tutorial Gather business users requirements Plwerplay 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 ppwerplay in Transformer Create PowerPlay cubes and distribute them to the end users Analyze and explore the cube data using PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.
Main PowerPlay Transformer features: Newer Post Older Post Home. It will be handled automatically be cognos. Put the PowerCube file name: Advanced modelling capabilities Leverages aggregate and fact tables Intergation of the query data into the model The models are defined by dimension structures and measures which can be easily customized No custom programming cognos powerplay transformer tutorial Time periods are handled in a specific way which makes data delivery easy High flexibilty and portability PowerPlay cubes modeling and development process The application development process in Cognos PowerPlay Transformer usually contains the following steps: We strongly recommend to avoid the AutoDesign function as in most cases it does not provide the results expected.
If a model contains multiple data sources, then the columns can be duplicated. Each source can be expanded and it lists all available columns.
Put a name for the PowerCube: Cognos powerplay transformer tutorial costs – calculated per the whole year. Fact less Fact Table? PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. The final model structure is shown below: The time source data is in the DT column in the model.
Go to the PowerCubes window and press Insert key 2. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
Cognos PowerPlay Tutorial
Dimension Map manages the dimensions and levels hierarchy in the data model. Do you want quarter-years in the time dimension?
Variable costs allocated dynamically by quantity: Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. We will analyze the following measures cognos powerplay transformer tutorial our tutorial business scenario:. Signons – datasource connection information. Cognos Powerplay Transformer powdrplay for the palm nursery business scenario: Signons – datasource connection information.
CSV or Excel output limitatoins Cognos: 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. Use Cognos 10 Business Insight-Preview and highlig Do you want to generate categories? Copyright interview questions Design by: Users may filter the report, drill up, down, slice and dice cognos powerplay transformer tutorial the figure will remain constant.
This options allows users for instance to report fiscal cognos powerplay transformer tutorial starting from 1 March. Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data.
The dimensions will have the following hierarchy: Each source can be expanded and it lists all available columns.
Gather business users tjtorial 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 powerplat Design and develop cognos powerplay transformer tutorial PowerPlay model in Transformer Create PowerPlay cognos powerplay transformer tutorial and distribute them to the end users Analyze and explore the cube data using PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.
We can see a new time dimension in the Dimension Map of the model: