Is IQD saved with data 1

[cogjai]

Hi
I am trying to generate a IQD file from Impromptu report. The idea is to create a Model and there after a cube and a powerplay report based on that. If i generate a IQD file, is it saved with data also. Because when i tried to see the cube and the powerplay report, its just showing the exact data of impromptu report which i generated with some prompts. I want to see all the data irrespective of the prompts given in impromptu. Shall anyone tell me how to achieve this.

Do I need to generate IQD file everytime i run the impromptu report with different prompt values. If not so, how can i filter out data in cubes and powerplay reports, which i can achieve in impromptu with prompts.

thanks in advance.

 

[GJParker]

The IQD file will save the SQL generated by the imr report including the entered prompt values.

If you want all the data in the cube then remove the prompts and select all the records.

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[cogjai]

Gary
Thanks for the reply. If i generate a cube with out any prompts, whether there is an option in Transformer model and cube or powerplay reports to restrict the data just like what the prompts do in impromptu report.

once again thanks for your reply.

 

[GJParker]

filtering is done in the finished powerplay cube by adding a dimension filter. The user can be prompted to add a filter by the use of a macro in the windows version of powerplay or by enabling dimension line filtering in the web version.

HTH



Gary Parker
Systems Support Analyst
Manchester, England