Prompts and PowerCubes

[monsky]

I created a list report that contains a prompt at the Catalog level. This gets executed whenever I run the report. Now, I saved this report as an IQD file that I will use in PowerPlay Transformer. I created PowerCube model using this IQD but I don't get prompted whenever I generate the cube. So obviously the PowerCube doesn't get populated properly.

Do you guys have a solution for this?

 

[GJParker]

This kind of fnctionality is not supported in Powerplay Transformer, the way to do this would be to bring in all the data and filter the powerplay reports to only show the required data.

Another way couldbe to insert cube group and create a seperate cube for each set of data.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[CognosProfessional]

Try making your prompt a dimension in the model. Do not use the prompt in the report. Choose the dimension desired in the cube to get to the correct set of data in a ppr or ppx.

CP