how to apply filter based on loggedin User

Question

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.

User_6K1A3 · Answer

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

Joshua C. Stewart · Answer

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.