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):||3 November 2007|
|PDF File Size:||7.64 Mb|
|ePub File Size:||7.97 Mb|
|Price:||Free* [*Free Regsitration Required]|
Cognos powerplay transformer tutorial and Product Segment. There are two ways of implementing allocation:. Go to the PowerCubes window and press Insert key 2. Each source can be expanded and it lists all available columns. Users can browse the cognos powerplay transformer tutorial data by using Data Source Viewer. PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.
Users may filter oowerplay report, drill up, down, slice and dice and the figure will remain constant. Transsformer measures can be calculated.
Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data. Each source can be expanded and it lists cognos powerplay transformer tutorial available columns. Signons – datasource connection information. Use Cognos 10 Business Insight-Preview and highlig About Me Siva Mandala.
We will get into more details on that options later on in this tutorial. Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Signons – datasource connection information. Solutions for cognos powerplay transformer tutorial and Tips on customizing the c Posted by Siva Mandala On 1: Source data typically cognos powerplay transformer tutorial 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 Tutorial
Time yutorial Time dimension is a special type of dimension. The time source data is in the DT column in the model. Newer Post Older Post Home. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Gather business users requirements 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 levels Design and develop the PowerPlay model 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 cognos powerplay transformer tutorial a wizard with AutoDesign function or manually.
Fixed costs – calculated per cognos powerplay transformer tutorial whole year.
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. Advanced modelling capabilities Leverages aggregate and fact tables Intergation of the query data into the model Cogos models are defined by dimension structures and measures cognos powerplay transformer tutorial can be easily customized No custom transgormer required Time periods are handled in a specific way which makes data delivery easy High flexibilty congos portability PowerPlay cubes cognos powerplay transformer tutorial and development process The application development process in Cognos PowerPlay Transformer usually contains the following steps: PowerCubes provide secure and fast data access.
It allows creating new dimensions and modifying existing using an user-friendly graphical interface. The dimensions will have the following hierarchy:. Dimension Map manages the dimensions and levels hierarchy in the data model. The default Cognos PowerPlay transformer window is composed of the following windows depicted cognos powerplay transformer tutorial the the yransformer below.
Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
Cognos PowerPlay Transformer tutorial for modelers and datawarehouse developers
Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures. We will analyze the following measures from our tutorial business scenario: Copyright interview questions Design by: Fact less Fact Table? Do you want days in the time dimension? The measure will be allocated. It will be handled automatically trandformer cognos.
Cognos PowerPlay Transformer – Models and Cubes
Define an output PowerCube 1. Enter ther first day of a particular year yyyymmdd – year value in this setting is not important.
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.