Dnyanesh

• Mar 19th, 2006

 

To create a powerplay report

1)You have to create a IQD file from impromptu by saving IMR report as IQD

2)Use Frame Work manager model and externalise the query subject you want to use in powerplay transformer and powerplay

When you have the IQD file published to a location such as UNC

Go to powerplay transformer model and select new ,

select the data source name , and IQD file location either published from FM or Impromptu (saved as IQD)

You will see all the query items in the explorer then you can specify the dimensions like time and measures.

Then generate categories for the dimensions and measures .

Right click the cube and select create power cube , after that view the cube in cognos powerplay explorer.

We can also publish  the cube to PPES(Powerplay enterprise server)

Publish the cube to the upfront

Use powerplay web explorer to view the cube