Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Where are Data Filters rules stored?

Received Response
1
Views
2
Comments
Manoj Dixit
Manoj Dixit Rank 6 - Analytics Lead

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.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

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

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    Thanks Thomas. The concerned resource has got sufficient idea.

    Regards,

    Manoj.