CREATING CUBES USING COGNOS POWERPLAY

Step 1: Start->Programs->Cognos8(Frame Work Manager) ->Frame work manager
Step 2:Create new project-> Press ok
Step 3: Select the design language for the project
Step 4: Select Metadata Source->Next
Step 5: Select data source from the list or create new data source->Next
Step 6: Select the object according to the requirement->Next
Step 7: Generate the relationship->Import
Step 8: Finish the process->Finish
Step 10: Publish the package
Step 11: Open transformer, go to file_New_Model name (User defined)->Next
Step 12: New data source (DHW name), Source type name (Select cognos package)->Next
Step 13: package name  (browse the package)->Next
Step 14: Check the auto design check box, click finish database.
Step 15: Right click on Dim map->choose Insert Dimension-> Write the dimension name
Step 16: Right click on Customer1-> Select insert level->Click on Source-> click on more->select Customer_id->click ok
Step 17: Right click on power cube-> Select Insert power cube-> Define cube name->Ok
Step 18: Right click on the cube & select create selected power cube
Step 19: Processing the Cube
Step 20: A new model will be genrated with Dimension map, data source, measure, power cube,singons.Data Sources Measures Cube
step 21: From the generated cube you can create whatever reports you need.