Where are Data Filters rules stored?

Question

Hi,

We are on OBI EE 11.1.1.7.0.

Our BI reporting application consists of OBI EE and another technology.

Could you please let me know where the Data Filters rules (defined in Identity Manager) are stored - the Oracle BI RPD or the schema created using RCU?

Also, is there any way where we can expose the Data Filters rules to some other third-party application so that we can re-use the same data filter rules in that application, as well?

Thank you.

Regards,

Manoj.

Manoj Dixit · Answer

Thanks Thomas. The concerned resource has got sufficient idea.

Regards,

Manoj.

Thomas Dodds · Answer

If you want 'sharability' in your data filters then your best approach is to implement as database tables and affect the row filtering via joins.  Depending on how you implement data filtering you can have it part of the metadata in the RPD -- but if you do it this way; then they other reporting system will have to connect to BI server (via odbc) and pass in logical SQL (similarly as the Presentation Server does).  This way does work, but you need to develop the logical queries before hand (which defeats a lot of efficiency).