Cognos Tutorials And Trainings Cognos PowerPlay Tutorial Cognos Movies Cognos Analysis Studio quick tour Cognos training space Cognos ReportNet. Cognos powerplay. 1. COGNOS – Powerplay; 2. The worlds best-selling OLAP software lets usersexplore volumes of data with. You use IBM® Cognos® PowerPlay® Studio to create and view reports that are based on PowerCube data sources. You access PowerPlay Studio from the IBM .
|Country:||Trinidad & Tobago|
|Published (Last):||28 May 2007|
|PDF File Size:||8.99 Mb|
|ePub File Size:||8.27 Mb|
|Price:||Free* [*Free Regsitration Required]|
IBM Cognos Transformer
The most active forums are: The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results. If a model contains multiple data sources, then the columns can be duplicated.
Newer Post Older Post Home. Signons – datasource connection information. Customers dimension with the source data preview: There are two ways of implementing allocation: Follow the cotnos below to add a new dimension: Split between the two Solutions for issues and Tips on customizing the c The final model structure is shown below: Put a name for the PowerCube: Users learn how to utilize the Report Powerplayy PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.
Each of the dimensions will have its own levels and categories and a single drill-down path.
Reporting and OLAP
Cognos provides an automatic support for handling time dimensions which is working very well. We will analyze the following measures from our tutorial business scenario:.
The time dimension levels in the PowerCube are depicted below: 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.
It will be handled automatically be cognos.
Every dimension requires a column tuttorial 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. 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.
It is addressed to data Define an output PowerCube 1. Time dimension is a special type of dimension. You can determine the impact that each area of your business has on overall results and tutrial that with other dimensions as you explore and analyze further.
Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing It allows creating new dimensions and modifying existing using an user-friendly graphical interface.
Each source can be expanded and it lists all available columns. Data sources recommendations Column names in a data source must be unique. To add measures to the model, follow the instructions below: There are two ways of implementing allocation:. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and powerplwy Cognos TransformerCognos Tutorial.
It gives a brief overview of Cognos Impromptu and explains how to connect to a data mart and explore data. We can see a new time dimension in the Dimension Map of the model: Cognos Powerplay Transformer model for the palm nursery business scenario: The default Cognos PowerPlay transformer window is composed of yutorial following windows depicted on the the screenshots below.