Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
how to apply filter based on loggedin User
Summary
Our use case to filter the data based on logged in user
Content
We have created a project/Visualization, but it shows all the data available in the database. We want to filter the data based on loggedin userId, I have tried to use the expression filter but couldn't find expression for loggedin UserId..
See the attached image:- we want to pass "John Doe" dynamically.
Answers
-
You might be better off setting a data filter at the RPD/Data Model Layer. However, this scenario would require a custom application for each user, which may not be tenable.
0 -
There is an Oracle Support document (How To Implement Data-Level Security In Oracle Analytics Data Visualization Data Sets (Doc ID 2396406.1)) that references this solution for data-level security:
"The recommended approach is to use the Enterprise Semantic model for data-level security (row-level) to be applied to a data visualization (dv) project. The project must use an RPD subject area as the data set. This is the most robust solution for enterprise and departmental use cases.
For self-service use cases, there is a limited approach that could work; however, it is not recommended as it is not as robust as the enterprise information model approach"Row(Data) Level Security Overview: https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/row-level-security.html#GUID-031DAE26-1CEC-40D0-97E7-6EFA0E87377F
Hope this helps!
Brian
0
