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):||11 May 2008|
|PDF File Size:||13.24 Mb|
|ePub File Size:||9.73 Mb|
|Price:||Free* [*Free Regsitration Required]|
IBM Cognos Transformer
Keep in mind that Cognos cubes are static and building a PowerCube is a repetitive process cubes may be refreshed every poeerplay, every month or even once a year. We will analyze the following measures from our tutorial business scenario: Each source can be expanded and it lists all available columns.
Customers and Customer Region.
Cognos Powerplay Client 2. The dimensions will have the following hierarchy:.
Cognos PowerPlay Transformer
You must have Transformer to build cubes. Fact less Fact Table? To add measures to the model, follow the instructions below: A Transformer Model can be also created using a wizard with AutoDesign powrplay or manually.
Gross revenue – the source data stores sales records on a daily basis. I don’t really see any need for the other two.
Cognos PowerPlay Transformer Tutorial
It will be handled automatically be cognos. We can see a new time dimension in the Dimension Map of the model: Enter ther first day of a particular year yyyymmdd – cogmos value in this setting is not important. There are two ways of implementing allocation: User Classes – define the security.
Fixed costs – calculated per the whole year. The final model structure is shown below: Each of the dimensions will have its own levels and categories and a single drill-down path. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Variable transformrr – monthly detail level in a source data.
PowerCubes provide secure and fast data access. 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: Follow the steps below to add ppwerplay new dimension: Do you want quarter-years in the time dimension?
Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. To add measures to the model, follow the instructions below:.
Data Sources – a list of all connected data sources. How to treat a week which spans a month? Powerplay Client is a desktop tool for reading the cube.
COGNOS Transformer tutorial ~ interview questions
Use Cognos 10 Business Insight-Preview and highlig I do not have much experience with Cubes. Signons – datasource connection information. This measure will be also allocated. If a model contains multiple data sources, then the columns can be duplicated. Each source can be expanded and it lists all available columns.