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):||1 March 2012|
|PDF File Size:||14.31 Mb|
|ePub File Size:||2.69 Mb|
|Price:||Free* [*Free Regsitration Required]|
PowerCubes provide secure and fast data access. Poweplay 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. Main PowerPlay Transformer features: 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 Tutoriwl 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.
COGNOS Transformer tutorial ~ interview questions
PowerPlay Transformer application The default Cognos PowerPlay transformer yutorial is composed of the following windows depicted on the the screenshots below. Each source can be expanded and it lists all available columns.
Users can browse the tutoriak data by using Data Source Viewer. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.
User Classes – define the security. Signons – datasource connection information.
Cognos Powerplay Transformer model for the palm nursery business scenario: 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. Data sources recommendations Column names cognoe a data source must be unique.
If a model contains multiple data sources, then the columns can be duplicated. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
Every dimension requires a column on a lowest level of the dimensions tutoriql usually an ID column is at the bottom At least one measure must be derived directly from a source column. Other measures can be calculated.
Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: The data source properties window also allows users to choose the datasource type, point to the right file or database server and set up a number of processing options, like: We will get into more details on that options later on in this tutorial.
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. Time dimension Time dimension is a special type of dimension.
Cognos provides an automatic support for handling time dimensions which is working very well. Do you want years in the dimension?
Do you want quarter-years in the time dimension? Do you want months in the time dimension? Do you want days in the time dimension? Choose the first day of the week. How to treat a week which spans a month? Powfrplay between the two Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. This options allows users for instance to report fiscal years starting from 1 March. Do you want to generate categories?
If not needed, we suggest to generate them based on the data and do not generate a ckgnos for each day. The time dimension levels in the PowerCube are depicted below: Customers and Customer Region.
Each of the dimensions will have its own levels and categories and a single drill-down path. Follow the steps below to add a new dimension: Customers dimension with the source data preview: 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.
PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Tutoroal and Product Segment. The dimensions will have the following hierarchy: The Dimensions Map after adding the products dimensions looks like depicted below: Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.
When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay. To add measures to the model, follow the instructions below: Define an output PowerCube 1. Go to the PowerCubes window and press Insert key 2. Put a name for the PowerCube: Cohnos the PowerCube file name: Usually it is required to perform allocation when part of the data is available only on a higher detail level than coognos data.
There are two ways of implementing allocation: Users may filter the report, drill up, down, slice and dice and the figure will remain constant. 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. Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs.
Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. We will analyze the following measures from our tutorial business scenario: Gross revenue – the source data stores sales records on a daily basis. It will be handled automatically be cognos. Fixed costs – calculated per the whole year. The measure will be powrplay.
Variable costs – monthly detail level in a source data. This measure will be also allocated. We see below that fixed costs have been allocated in a constant fashion: Variable costs allocated dynamically by quantity: Posted by Siva Mandala On 1: A Transformer Model can be also created using a wizard with AutoDesign function or manually. The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.
Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Time dimension is a special type of dimension.
We can see a new time dimension in the Dimension Map of the model: Follow the steps below to add a new dimension:. The dimensions will have the following hierarchy:. To add measures to the model, follow the instructions below:. The final model structure is shown below: There are two ways of implementing allocation:. In the following example we will analyze revenue, constant costs and variable costs.
We will analyze the following measures from our tutorial business scenario:. Cognos TransformerCognos Ttuorial. Newer Post Older Post Home. About Me Siva Mandala. How to change the package for an existing report w Solutions for issues and Tips on customizing the c Different type of Cognos Logs.
Use Cognos 10 Business Insight-Preview and highlig Fact less Fact Table? Prompt Expressions between R CSV or Excel output limitatoins Cognos: Copyright interview questions Design by: