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: Arashakar Guzshura
Country: Poland
Language: English (Spanish)
Genre: Science
Published (Last): 6 January 2004
Pages: 327
PDF File Size: 1.36 Mb
ePub File Size: 18.6 Mb
ISBN: 272-8-49479-846-2
Downloads: 1187
Price: Free* [*Free Regsitration Required]
Uploader: Nezahn

Reporting and OLAP

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. Every dimension requires a column on 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.

Put the PowerCube file name: It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Justcog Cognos forums Cognos discussion forums where Cognos users may find relevant information in resolving cognos issues.

PowerPlay Studio

Copyright interview questions Design by: To add measures to the model, follow the instructions below: How to treat a week which spans a month? Variable costs – monthly detail level in a source data.


But at this stage we don’t want to have Customers tutorrial by Region, Country and then by Segment becuase it would be not intuitive for the end users.

Follow the steps below to add a new dimension: About Me Tutoria, Mandala. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Each source can be expanded and it lists all available columns.

Newer Post Older Post Home. The data source properties window also allows users to choose the cogns type, point to the right file or database server and set up a number of processing options, like: This options allows users for instance to report fiscal years starting from 1 March. Cognos provides an automatic support for handling time dimensions which is working very well.

Cognos Tutorial Trainings Powerplay Movies Analysis Studio Quick

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. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Split between the two PowerCubes provide secure and fast data access.

Users can browse the source data by using Data Source Viewer. It is a high Choose the first day of the week. The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results. Different type of Cognos Logs.


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. The time source data is in the DT column in the model. Posted by Siva Mandala On 1: The final model structure is shown below: The tutorial shows how to: Do you want quarter-years in the time dimension?

Cognos PowerPlay Tutorial

You can change the report properties so the default action is to open the report in PDF format in a Report Viewer. User Classes – define the security.

Time dimension Time dimension is a special type of dimension. Keep in mind that Cognos cubes are static and building a PowerCube is a repetitive process cubes may be refreshed every day, every month cotnos even once a year.

Define an output PowerCube 1. Both viewers provide access to report options such as drill through and the ability to open the report in PowerPlay Studio.