Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Row-Level Filter Setup in OAC Semantic Model
Hi ,
I’ve developed a report based on a Semantic Model subject area in OAC. We have 10 plants, and I’d like to restrict the data visibility based on the logged-in user.
I have a separate table that manages user and plant details. In my dataset, I used this table to filter data, and it’s working as expected. I also used the same table in the Semantic Model to retrieve the plant details for the logged-in user.
The plant detail column is numeric. I collected all the plant IDs into a single column (e.g., 1,2,3,4) and assigned it to a session variable. However, I’m unable to apply this session variable as a filter in the logical layer.
Could you please let me know how to assign the WHERE condition in the logical layer for this kind of setup?
Thanks,
Jay
Best Answer
-
Hi,
You turned a list of IDs into a string, not fully sure why. If you have multiple plant IDs for a single user, you shouldn't concatenate them into a string.
You can define a session variable being the list of plant IDs the user has access to.
You use the row-wise initialization to assign a list of values to the session variable: (look at "Initialize a Variable with a List of Values").
Then you can use that session variable to set the row-level security in your semantic model, or even directly in the WHERE block of the logical table source of your tables containing the plant ID.
3
Answers
-
Thank you so much for your immediate support. I followed the note and created the list session variable. Now all my reports are working with the proper data filters.
Thanks,
Jay1 -
Great it did work :)
0