join condition

[cognos05]

Hi All,

In cognos fm I used to have a join condition manually defined between 2 tables like this

( dwh_security.security_level ='Territory' AND vw_f_billings_all.Ship-To Territory ERP Code = dwh_security.security_value )
OR
( dwh_security.security_level ='Area' AND vw_f_billings_all.Ship-To Area ERP Code = dwh_security.security_value )


But in Data Modules looks like I can only join 2 fields from each table in there

Is there a way to explicitly say the conditons.

[bus_pass_man]

You define security filters on the schema.
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/t_ca_mdlg_secure_data.html