IBM Cognos Transformer is a simple tool for modeling dimensional hierarchies and levels for PowerCubes.
We can use this data modeling tool or component to create a model, a business presentation of the information in one or more data sources. A model can contain any number of regular or calculated measures, together with logical groupings that use measure folders.
After you choose a supported product locale (language), add dimensional metadata, specify the measures(performance indicators) and apply custom views, you can
create PowerCubes based on this model. You can deploy these cubes to support OLAP reporting and analysis.A regular measure is numeric data in a transactional data source. A calculated measure is new numeric data that is derived from other measures, functions, and constants, such as Profit, which is calculated from the measures Revenue and Cost.A measure folder can group existing measures into a logical collection and, if needed, can be assigned a calculated value itself.