Is there any way to restrict the data shown in visualization based on user in Oracle Analytical clou
SummaryIs there any way to restrict the data shown in visualization based on user in Oracle Analytical cloud.
We have created a Visualization report in Oracle analytical cloud with three data sets.
We have a scenario to restrict the user to see their own data, data contains different regions/business units.
We are going with below approach.
--- Comparing user with application user and applying expression filter with user name. It will fetch data pertaining to that user.
--- In some scenarios its working fine and sometimes it's showing full data to user which he didn’t have access, Once we refresh the report then its filtering out the data as expected.