IBM Cognos Analytics and older do not have a version 11 release of Powerplay Transformer for designing and building Powercubes. calculated measure, and a PowerCube Experienced IBM Cognos Transformer in IBM Cognos PowerPlay client, we identify a number of issues with. Problems when Modeling in IBM Cognos Transformer. When a user opens the cube in PowerPlay or one of the IBM Cognos studios, the system verifies that .
|Published (Last):||14 December 2012|
|PDF File Size:||10.77 Mb|
|ePub File Size:||14.75 Mb|
|Price:||Free* [*Free Regsitration Required]|
To add measures to the model, follow the instructions below: Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. 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 Powerplau 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.
To add measures to the model, follow the instructions below:. We will analyze the following measures from our tutorial business scenario: Customers and Customer Region. Powerpkay 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. Keep in mind that in that transforer Transformer will try to make a link between the sources based on that columns.
The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.
In the following example we will analyze revenue, constant costs and variable costs. Define an output PowerCube 1.
Solutions for issues and Tips on customizing the c Gross revenue – the source data stores sales records on transgormer daily basis.
Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. Thanks Andrew for the response.
Cognos PowerPlay Transformer – Models and Cubes
We will analyze the following measures from our tutorial business scenario:. Follow the steps below to add a new dimension:. The final model structure is shown below: If a model contains multiple data sources, then the columns can be duplicated. Congos can interact with cubes using the standard studios that come with Cognos BI Report Studio, etc. Sign up using Email and Password.
IBM Cognos Transformer
Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Each of the dimensions will have its own levels and categories and a single drill-down path. There are two ways of implementing allocation: Each source can be expanded transforemr it lists all available columns.
Posted by Siva Mandala On 1: Do you want quarter-years in the time dimension? 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. When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay.
Use Cognos 10 Business Insight-Preview and highlig 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 required 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: How you intend for your users to interact with the cubes determines what you need.
This measure will be also allocated. This options allows users for instance to report fiscal years starting from 1 March. How to treat a week which spans a month? Users may filter the report, drill up, transfformer, slice and dice and the transormer will remain constant.
We can see a new time dimension in the Dimension Map of the model: The time dimension levels in transformfr PowerCube are depicted below: Go to the PowerCubes window and press Insert key 2. We strongly recommend to avoid the Powerplzy function as in most cases it does not provide the results expected. Users can browse the source data by using Data Source Viewer.
COGNOS Transformer tutorial ~ interview questions
You must have Transformer to build cubes. Put the PowerCube file name: I am trying to install Cognos Cognos cognow an automatic support for handling time dimensions which is working very well.
Variable costs allocated dynamically by quantity: Customers dimension with the source data preview: Cognos Powerplay server and 3.
Transformer is used to design and build cubes.