If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Prompt in Union Query

Started by rg, 17 Jul 2010 09:50:05 PM

Previous topic - Next topic

rg

I have a report in which i am doing a union
query 3=query1 and query2
Query one has Region1 and territory1 from a query subject-1 and query 2 has region2 and territory2 from query subject2(alias shortcut of query subject1)
now the query three need two value prompts region and territory.
How do i  make the prompts if the use value region and territory is taken from union query it gives me an error.
please can somebody advice
thanks

Gollapudi

You can make a separate Union Query for prompt "Use Value" and "Display Value" only with Region and Territory