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 .

Author: Milmaran Fezil
Country: Netherlands
Language: English (Spanish)
Genre: Science
Published (Last): 27 July 2007
Pages: 284
PDF File Size: 17.71 Mb
ePub File Size: 3.46 Mb
ISBN: 213-3-24977-719-5
Downloads: 54565
Price: Free* [*Free Regsitration Required]
Uploader: Malami

To add measures to the model, follow the instructions below: We will analyze the following measures from our tutorial business scenario: Time dimension Time dimension is a special type of dimension. 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.

First a percent of total of powerplau allocation base measure is calculated and based on that figure, the corresponding values for allocated measure are calculated. Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing Solutions for issues and Tips on customizing the c Variable costs allocated dynamically by quantity: Enter ther first day of a particular year yyyymmdd – year value in this setting is not important.

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.

Cognos Tutorial Trainings Powerplay Movies Analysis Studio Quick

You can determine the impact that each area of your business has on overall results and compare that with other dimensions as you explore and analyze further. You can change the report properties so the default action is to open the report in PDF format in a Report Viewer. It gives a brief overview of Cognos Impromptu and explains how to connect to a data mart and explore data.


Other measures can be calculated. The Dimensions Map after adding the products dimensions looks like depicted below: Avoid changing or switching tutroial in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Choose the first day of the week. PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: There are also 9 flash movies with guides on how to work with cognos.

Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of

A Transformer Model can be also created using a wizard with AutoDesign function or manually. You can use IBM Cognos Connection to work with entries such as reports, analyses, queries, agents, metrics, and packages. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Do you want months in the time dimension?

Put a name for the PowerCube: Customers and Customer Region. The time dimension levels in the PowerCube are depicted below: Users learn how to utilize the Report Studio Customers dimension with the source data preview: To add measures to the model, follow the instructions below:.

Measures allocation real-life example in Cognos In the cohnos example we will analyze revenue, constant costs and variable costs.

Fixed costs – calculated per the whole year. Cognos ReportNet navigation – with introduction, system navigation and There are two ways of implementing allocation: The tutorial shows how to: The dimensions will have the following hierarchy: We can see a new time dimension in the Dimension Map uttorial the model: There are two ways of implementing allocation:. Justcog Cognos forums Cognos discussion forums where Cognos users may find relevant information in resolving cognos issues. Copyright interview questions Design by: Managing Your Reports After you create one or more reports, you can manage them for yourself and others.


IBM Cognos Transformer

Different type of Cognos Logs. About Me Siva Mandala. Gross revenue – the source data stores sales records on a daily basis.

Prompt Expressions between R Cognos Tutorials And Trainings. Split between the two Each source can be expanded and it lists all available columns.

Regardless of the default action setting, a report consumer can choose to open the report in either PDF format or interactive format.

Do you want quarter-years in the time dimension? PowerCubes provide secure and fast data access. 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. 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.

Keep 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.