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

Issue with the Prompt Query Filtering

Started by davidcognos, 19 Jun 2019 05:48:48 AM

Previous topic - Next topic

davidcognos


I have a separate table needed for the prompt query to pull client numbers and this table has no joins in FM model. The main query has the client number filter. When I run the report and select all the clients from value prompt, the revenue value is not coming correctly , but when I hardcoded these client numbers of the prompt query in Main query, then the revenue value is matching with the database query.  My query is that after selecting the prompt values from the separate table,  the filtering is not happening correctly , but when hardcoded the measure values reflects correctly.Any idea??

CognosPaul

How exactly are you building the filter? What's the full definition? Are you using a wizard or pulling the field in directly into the filter editor?