AnsweredAssumed Answered

Security Clause

Question asked by Rajini on Sep 24, 2012
Latest reply on Oct 18, 2012 by Rajini
Hi,

1) Open new Webi report
2) Open Investments universe
3)Open investments folder
4) Open Products folder
5)Select only "Product ID" from Products folder
6) Now check the SQL

you will notice that though the field is being pulled from RPT_PRJ_INVESTMENTS (inv_investments) , it automcatilly joins inv_products and RPT_PRJ_SECURITY_PRODUCTS.

When I create a new object and define it as Product ID from RPT_PRJ_INVESTMENTS, I dont get the INV_PROJECTS or RPT_PRJ_SECURITY_PRODUCTS.

How and why is the join automatically made in the out of box universe?

Thanks and Regards,
Rajini

Outcomes