Cognos transformer

COGNOS TRANSFORMER TRANSFORMER ● ● ● ● ● ● ● ●

A transformer is a windows based component which allows to create a multidimensional database known as CUBES A cube is a multidimensional database which allows you to store the ​DATA in a multidimensional array format Cognos MDD – Multi dimensional database A cube contains pre calculated aggregates hence the data retrieval is more faster than DMR model (Dimensionally Modeled Relation) A cube provides faster retrieval of data and secure access to the data The cubes which are created using ​cognos​ are known as POWER CUBES A power cube is created and saved with an extension .mbc (model based cube) A cube is created from the following data sources

Impromptu Query Definition Cognos Package MS-Access MS-Excel Flat files Cognos Architect File (.xml file) ● ● ● ● ● ● ●

A cube is created with dimensions and measures A DIMENSION is a broad group of descriptive data about the major aspects of a business A dimension is created with levels A level describes detail data to a dimension The levels are defined from highest level granularity to lowest level granularity There should be one to many relationship between the levels A MEASURE defines a quantitative analysis in DMR. It is a measure dimension.

CREATION OF A LIST REPORT​ : ● ● ● ● ● ● ● ●

Create a list ​report​ with the following items in ​Go Sales​ and ​Retailers package Product line Product type Product name Order date Quantity Revenue Save the report as Productrevenue

Creation of Model​: ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ●

Start programs] IBM Cognos10 Click on IBM Cognos Transformer From the menu bar, Select file Click on ​new Click on ​next Type the name as Productrevenue model ( .pyj ) Click on next Select data type source – Report Click on next Select the browse tab From the Go Sales and Retailers Select the Productrevenue report Click on ​OK Click on Next Select the ​Query​1.0 Click on add tab to add the query items Click on OK Tab– à Click on Finish

CREATION OF MODEL

File — new—-.>

Click on next—-

Give name as New Model1 Click on Next

Select Data source type : Report Click on Next

Go to Browse tab

Select Listreport1——

Click on next—–

Select the query1.0 Click on Add tab— Click on ok tab

Click on finish

Creation of Cube: ● ● ● ● ● ● ● ● ● ● ● ● ● ● ●

Select the power cube window From the tool bar Click on + symbol (insert power cube) Type the power cube name as Productrevenue cube (.mdc) Click on ​browse tab To select the location power cube Click on browse tab Select to location Click on ​OK Enter password Click on OK Enter the confirm password Click on OK From power cubes window Select the cube (productrevenue cube)

● ● ●

Right click Click on create selected power cube Click on OK

CREATION OF CUBE

Select Power Cube Window From the tool bar click on + symbol (Insert Power Cube)

Click on Browse tab—–

Click on OK Tab—– Enter Password—–

From power cube window, Right click on sales cube——Click on create selected Power Cube—- Click on OK—

Create package for Cube: ● ● ● ● ● ● ● ● ● ● ● ● ● ● ●

From power cubes window Select the productrevenue cube Right click Click on publish power cube as data source and package Click on OK Click on Next Click on Next Select ​create a sign,​ on that the everyone can use group Enter password Confirm the password Click on test the connection Click on ​test Click on ​finish Click on ​OK

CREATE PACKAGE FOR POWER CUBE ● ● ●

From PowerCubes window, select the cube Right click Click on Publish Power Cube as Data Source and Package

Click on OK Tab

Click on Next ——

Click on Next——

Windows Location of Cube is d:\documents and settings\administrator\my documents\transformer\powercubes Click on​ Create a signon​ that the Everyone group can use Enter Password And Confirm password Click on Test the connection

Click on Test

Click on Finish

Click on OK

From cognos home page ● ● ● ● ● ● ● ● ● ● ● ● ● ●

Select author advanced reports Select the package productrevenue cube Select the crosstab Click on OK Drop the year 2004 2005 2006 (Order date – Year – Members -2004/2005/2006) Drop the product name (Members – Product name – Trialchef canteen/Trialchef cookset/Trialchef cup) Drop the Revenue on measures Run the report from IBM Cognos (​Cognos Tutorila​) content Cube max size – 50 GB Data warehouse – up to Terabytes Update the cube to refresh the data Open the report from the cognos by selecting package & report Select the report Run with options

● ● ● ● ●

Save the Report Run OK Refresh (On top of the page) view the output version (save the report, view the details , Report outputs – Yes)