Hello,
I m using Cognos 10.1.1 version, When I setup the prompt info associating smaller view for the source column. The prompt page from Query studio does not use the smaller view to query the prompt instead it executes transactional view with distinct clause. The prompt page doesnt show quickly. The same works on Report studio.
I need to make it work on Query studio
Detailed example is available in attachement.
I tried applying the smaller view the "Filter Item Reference" option too but no luck.
Any help on this would be greatly appreaciated.
Thanks
Kranthi