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

Not showing correct values in the filter

Started by srinivas.inbox83, 20 Jan 2014 11:34:25 PM

Previous topic - Next topic

srinivas.inbox83

Hello every one ,

I have a table with primary key(JOB ID) and along with I have some other columns like status id, version id, manager id ... I haev another table with columns Drop ID and Drop desc .. we get description for status , version and manager by joining respective columns with Drop ID like
status ID = Drop ID --> status desc , version ID= Drop Desc--> version Desc now my table has columns.....I am creating a model query subject with Prim Key and other columns as descriptions...now my table has columns PK, Status, Version and Mgr .. now when I am trying to create a query studio report  JOBID , status, Version and apply filter on status it is showing in the filter (list of values look like prompt in QS) all descriptions instead of giving distinct values for status ...
but in report it is showin the values for status description only...when I use only one column status again it is giving all descriprtions and I can see no join is forming in query when I open  with RS like simply select status desc from drop table...

Please help me out