Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Where are Data Filters rules stored?

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
-
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).
0 -
Thanks Thomas. The concerned resource has got sufficient idea.
Regards,
Manoj.
0