Cognos Transformer

IBM Cognos Transformer is a multi-dimensional data modelling tool. This tool is used for to create multi-dimensonal cube for business presentation of data.

Cognos transformer model can contain data from one or more than one data source. Model is used to support OLAP reporting and faster analysis of data.

A cube contains calculated and summarized data organized into dimensions and measures and can be viewed and analysed in IBM Cognos Analysis Studio.

IBM Cognos Transformer creates metadata file with .mdl extension, which generates a physical cube with .mdc extension.

Cognos Analysis Studio

IBM Cognos Analysis Studio is the web-based analysis component within IBM Cognos Connection. User can explore, analyze and compare the dimensional data using Analysis Studio. Analysis Studio provides access to dimensional, OLAP( Online Analytical Processing) and DMR (Dimensional Modeled Relational) data sources.

You can use Analysis Studio to compare and manipulate data to understand the relation between data and its relative importance. You can view performance indicator of your business.

Example- revenue, growth, product cost, or top performer. Analysis Studio provides filter, calculations, sorting and drill up and drill down support you need for analysis.

Using Analysis Studio, you can perform following task-

• Find and focus on items which are important to your business.
• Understand the trends in the market.
• Compare the data, such as details to summaries, or actual results to budgeted results.
• Assess performance by focusing on the best or worst results.
• Establish relative importance using calculations such as rank or growth.
• Share your finding and analysis with management.

Analysis created in Analysis Studio can be opened in Report Studio and used to build professional reports.