P7- Creating Calculations Cognos Powerplay Transformer Cubes
Creating Calculated Measures and Category Counts.
1- Open the Cognos Powerplay Transformer
2- Right click the Measures Area, and click on New Measure
3- Set a name as Sales Cost
4- Click on the Type Tab and select Calculation.
5- Sales cost = Sales Quantity * Sales Amount
6- Click on OK. Sales Cost appears in the measure list.
7- Again Create a new Measure
8- Set a name as Product Count. Click on the Type Tabe and Click on Category Count.
9- Select the dimension and Level for which you need the count.
10- Now we need to create cube.
11- Right click Cube Tab Area. Insert Powercube; Give a name. It is stored as .mdc. Set a path.
12- Right click again the powercube and create powercube.
13- The cube is generated successfully.
SO THATS IT....