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.
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