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

Need help in Querystudio Model

Started by gops210, 02 Dec 2008 03:44:54 AM

Previous topic - Next topic

gops210

Hi,

I have created a model for query studio in which i have a requirement like below..

I have 5 tables table1,table2,table3,tabble4,table5
i have created a standalone filter from table3 query item (table3.acctno),
the acctno is present in table4 also
whenever i pull any column from table4 along with standalone filter(from table3) it creates a join with table3
As per the requirement  we need to use the filter which should be dynamic to choose the acctno from the table which it has been pulled (for ex if i pull the acctno from table2 then the filter should from table2)