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 .

Author: Shakatilar Faelkree
Country: Netherlands
Language: English (Spanish)
Genre: Software
Published (Last): 7 November 2010
Pages: 382
PDF File Size: 1.69 Mb
ePub File Size: 18.94 Mb
ISBN: 524-3-11488-743-4
Downloads: 43438
Price: Free* [*Free Regsitration Required]
Uploader: Shalrajas

Source data typically comes from coggnos data warehouse, sometimes from production ERP system and in many cases includes multiple sources in order to deliver information required by the model.

To add measures to the model, follow the instructions below:. Solutions for issues and Tips on customizing the c Follow ccognos steps below to add a new dimension: Posted by Siva Mandala On 1: Do you want days in the time dimension?

To add measures to the model, follow the instructions below: In the following example we will analyze revenue, constant costs and variable costs.

Prompt Expressions between Cognoss The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results. 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. PowerCubes provide secure and fast data access.

We will get into more details on that options later on in this tutorial. The Dimensions Map after adding the products dimensions looks like depicted below: Use Cognos 10 Business Insight-Preview and highlig Keep in mind that in that case Transformer will try to make a link between the sources based on tutkrial columns.

  CHUCK MANGIONE - CHILDREN OF SANCHEZ PDF

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. 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 tutprial a year.

We will analyze the following measures from our tutorial business scenario: Every dimension requires a column on a lowest level of the dimensions hierarchy usually powerplah ID column is at the bottom At least one measure must be derived directly from a source column.

The time source data is in the DT column in the model. Both viewers provide access to report options such as drill through and the ability to open the report in PowerPlay Studio. 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. Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: The final model structure is cognnos below: Users can browse the source data cobnos using Data Source Viewer.

The dimensions will have the following cobnos If a model contains multiple data sources, then the columns can be duplicated. You can also use it to create and run agents and schedule entries.

Cognos Tutorial Trainings Powerplay Movies Analysis Studio Quick

When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay. The time dimension levels in the PowerCube are depicted below: The tutorial is aligned to a typical business scenario to facilitate the learning process.

  ALCCOFINE 1203 PDF

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 years in the dimension? Put a name for the PowerCube: Cognos Tutorials And Trainings. Different type of Cognos Logs.

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

Do you want to generate categories? Time dimension is a special type of dimension. Cognos Powerplay Transformer model for the palm nursery business scenario: It is a high PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.

It lets you examine many combinations of the key dimensions and measures in your data. Fact less Fact Table? Each source can be expanded and it lists all available columns.

IBM Cognos Transformer

Newer Post Older Post Home. Managing Your Reports After you create one or more reports, you can manage them for yourself and others. The most active forums are: Define measures in oowerplay PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.