PRE_FILTER usage with Row level security

[HUIL]

I have a couple of calculated fields that uses PRE_FILTER
Basically I use this fields to get:
Service_Cost_Total >> minOver({Total_Services_Cost}, [day], PRE_FILTER)
and
Support_Cost_Total >> sumOver({GD Support}, [day], PRE_FILTER)
Then I use both on a single formula that I have as a column in a table
Support Total >> ({AccountSupportCost}*{Service_Cost_Total})/{Support_Cost_Total}

the dashboard contains a lot of different ‘Account’, so in my view the ‘Support Total’ calculation shows correctly because I can access all ‘Account’.
But the issue is that I use RLS so the individuals can see only the ‘Account’ they belong to, and for ‘Support Total’ they are not seeing the correct total, looks like that they have the Service_Cost_Total.

I am not very familiar with this PRE_FILTER / PRE_AGG calculations, but it worked on my view so I need to understand how make this to work for the users viewing this dashboard

[Giridhar.Prabhu]

Hi @HUIL

You may refer to the following article that explains the Level Aware Calculations in detail.

Level-Aware Calculations: Tips and Best Practices

[Level-Aware Calculations in Amazon QuickSight] Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals. The sample dataset referenced by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to per…

Coming to your question the RLS restricts access to data and that will happen before any other computations since the objective of security is to only give access to what the user should see. The Total from that persective of the Total for data the user has access to.

So, for example if I have access to Country India my total will be only for India though my dataset has data for Regions Europe, Asia and Africa. The person who should have a global view and has access to all data will see the overall total.

The PRE_FILTER and PRE_AGG have no role to play in the row level restrictions.

[Brett]

Hi @HUIL,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @HUIL,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!