COGNOiSe.com - The IBM Cognos Community

Hi all,
i am getting a problem with Text Box Prompt,My User wants to enter Multiple values

I created the text box with multiselect,if my user select more than one value then the report keeps on running and throwing the query execution time out error

If i entered one value the data is populating in less than a minute

Any Help?

Thanks,
kvchow

What does your filter expression look like? Is your source relational? What does the generated SQL look like?

Quote from: kvchow on 05 Jan 2015 07:06:58 AM
Hi all,
i am getting a problem with Text Box Prompt,My User wants to enter Multiple values

I created the text box with multiselect,if my user select more than one value then the report keeps on running and throwing the query execution time out error

If i entered one value the data is populating in less than a minute

Any Help?

Thanks,
kvchow

Hi,

Have you used the 'IN' operator for your filter expression ?

Regards

Hi Lynn and raghuvir

My source is Relatinal and filter is having IN operator

Thanks,
Kvchow

Quote from: kvchow on 06 Jan 2015 07:38:14 AM
Hi Lynn and raghuvir

My source is Relatinal and filter is having IN operator

Thanks,
Kvchow

You will need to provide more information. I previously asked about your generated SQL. Did you compare to see any differences when one value is selected vs multiple values? I also asked what your filter expression looks like although you only commented that it has an IN operator without actually posting any further information on what it looks like.

Perhaps you should work with your DBA to have them monitor what is going on when you run the report with one value vs multiple.

Hi Lynn,
i created a ticket and asigned to DB2 team,after 4 days i got the reply from those guys,we can't do anything from DB2 side and no need to create any index they said like that

i want to enter multiple course swith in (text box prompt) to see which one is completed with in the given date range,if i enter more than one its keep on running and giving me the query execution time exceeds more than 2700 seconds

Any idea?

Thanks,
Kvchow

Hi kvchow,

Can you copy and paste your filter expression please? I imagine it's something along the lines of:

[Course Name] in ?promptCourse?

but it will help if we can see the actual text.

C