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.

Author: Magar Netilar
Country: Algeria
Language: English (Spanish)
Genre: Video
Published (Last): 25 July 2004
Pages: 125
PDF File Size: 5.78 Mb
ePub File Size: 15.60 Mb
ISBN: 211-5-19238-484-8
Downloads: 26207
Price: Free* [*Free Regsitration Required]
Uploader: Gonris

IBM Cognos Transformer

The tutorial shows how to: Do you want months in the time dimension? Variable costs – monthly detail level in a source data. There are two cogbos of implementing allocation:.

Choose the first day of the week. The most active forums are: It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Do you want to generate categories?

User Classes – define the security. Newer Post Older Post Home. The Dimensions Map after adding the products dimensions looks like depicted below: The tutorial is aligned to a typical business scenario to facilitate the learning process. Customers and Customer Region. The final model structure is shown below: Users can browse the source data by using Data Source Viewer. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: If not needed, we suggest to generate them based on the data and do not generate a category for each day.


Follow the steps below to add a new dimension: It is a high Split between the two Copyright interview questions Design by: PowerCubes provide secure and fast data access. How to change the package for an existing report w We can see a new time dimension in the Dimension Map of the model: 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 using a wizard with AutoDesign function or manually.

When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay.

Ttorial you want days in the time dimension? The tutodial Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Cognos provides an automatic support for handling time dimensions which is working very well.

Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. Fact less Fact Table? Do you want years in the dimension?

Reporting and OLAP

Our goal is to be able to compare trznsformer to fixed and variable costs in all the time dimension levels available. Cognos Tutorials And Trainings. The dimensions will have the following hierarchy:. Cognos TransformerCognos Tutorial.


Using Cognos Transformer to Convert a Single Table (or Query) Source into a Data Cube

Product and Product Segment. Do you want quarter-years in the time dimension? Follow the steps below to add a new dimension:. Users learn how to utilize the Report Studio Tutirial dimension is a special type of dimension. A Transformer Model can be also created using a wizard with AutoDesign function or manually.

It will be handled automatically be cognos. It gives a hutorial overview of Cognos Impromptu and explains how to connect to a data mart and explore data. Customers dimension with the source data preview: Go to the PowerCubes window and press Insert key 2. Transfoemer Cognos forums Cognos discussion forums where Cognos users may find relevant information in resolving cognos issues.

We see below that fixed costs have been allocated in a constant fashion: About Me Siva Mandala.

Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures. 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.