COGNOS POWERPLAY TUTORIAL PDF
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 .
|Published (Last):||22 June 2005|
|PDF File Size:||11.40 Mb|
|ePub File Size:||17.17 Mb|
|Price:||Free* [*Free Regsitration Required]|
Do you want to generate categories?
Use Cognos 10 Business Insight-Preview and highlig The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.
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. Do you want days in the time dimension? It lets you examine many combinations of the key dimensions and measures in your data.
How to treat a week which spans a month? Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs.
IBM Cognos Transformer
Enter fognos first day of a particular year yyyymmdd – year value in this setting is not important. Time dimension is a special type of dimension. We will analyze the following measures from our tutorial business scenario:. It is addressed to data Do you want years in the dimension? We can see a new time dimension in the Dimension Map of the model: It gives a brief overview of Cognos Impromptu and explains how to tutodial to a data mart and explore data.
We will analyze the following measures from our tutorial business scenario: If a model contains multiple data sources, then the columns can be duplicated. The time source data is in the DT column in the model. Copyright interview questions Design by: If not needed, we suggest to generate them based on the data and do not generate a category for each day.
Source data typically comes 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. Managing Your Reports After you create one or more reports, you can manage them for yourself and others.
Solutions for issues and Tips on customizing the c Regardless of the default action setting, a report consumer can choose to open the report in either PDF format or interactive format. The dimensions will have the following hierarchy:. About Me Siva Mandala. CSV or Excel output limitatoins Cognos: Every dimension requires a column on a lowest level of the dimensions hierarchy tutorrial an ID column is at the bottom At least one measure must be derived directly from a source column.
Define an output PowerCube 1.
Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Fact less Fact Table? Customers dimension with the source data preview: The final model structure is shown below: Gross revenue – the source data stores sales records on a daily basis.
Product and Product Segment. The Dimensions Map after adding the products dimensions looks like depicted below: You can use IBM Cognos Connection to work with entries such as reports, analyses, queries, agents, metrics, and packages. Optionally, for PowerCube data sources, the administrator can choose to automatically generate a package when they create the data source connection, eliminating the need to create the package in Framework Manager.
Users may filter the report, drill up, down, slice and dice and the figure will remain constant.
The measure will be allocated. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. The most active forums are: In the following example we will analyze revenue, constant costs and variable costs.
Powedplay is a high We will get into more details on that options later on in this tutorial. Using Framework Manager, a modeler builds a model from the data source and then publishes packages to make the data available to report authors.
Cognos TransformerCognos Tutorial. Prompt Expressions between R Justcog Cognos forums Cognos discussion forums where Cognos users may find relevant information in resolving cognos issues. Go to the PowerCubes window and press Insert key 2. Fixed costs – calculated per the whole year. Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with tutorrial, sample solutions and a guide to develop data warehouse models in Cognos.
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 tutoroal using a wizard with AutoDesign function or manually.
But at this stage we don’t want to have Customers grouped by Region, Country and then by Segment becuase it would be not intuitive for the end users.