Prompt taking too much time

[kejalg]

Hi,

I am showing 5 prompts in a report.

3 - Type-in
1 - filepicklist(4 rows)
1 - Catalog picklist (20 rows)

This report takes 3 mins to show just the prompts. Can any one guess what the problem would be.

Thanks in advance
Kejal

 

[griffindm]

The culprit is probably the Catalog Picklist. Try replacing the definition for just that one to 'Type in" and see if that speeds up the prompt execution.

With Catalog Picklists, a select distinct SQL clause is generated in the background. If the table is large and not indexed on the requested column, performance will suffer.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[kejalg]

Hi Dave,

Thanks for the response. The table itself is having just 20 rows and I run the query with distinct clause in the backend. It's taking not even a second. Is there anything else I should look into.

Regards
Kejal

 

[griffindm]

As I previously suggested, try replacing each of the prompts with constants and see what effect it has on the time to display prompts. Neither a type in or a file-based prompt should delay the report. The only delay for either I could think of would be time to resolve the location of the file name given.

Let us know what you find.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com