Posts

  • 1-1 of 1
  • Sravan Jayannagari
    Is there any way to restrict the data shown in visualization...2
    Topic last edited September 11, 2019 by Sravan Jayannagari, tagged Analysis in Oracle Analytics public
    Title:
    Is there any way to restrict the data shown in visualization based on user in Oracle Analytical cloud.
    Summary:
    Is there any way to restrict the data shown in visualization based on user in Oracle Analytical cloud.
    Content:

    Hi,

    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.

    Please suggest. 

    Thanks,

    Sravan