I’m trying to configure user access in so that certain metric values are hidden for specific users, while the table structure (rows and columns) remains visible.
For example, as shown in the screenshot, I want users to see the list of Countries, along with Cost and Gross Margin numbers — but the Revenue values should be completely hidden for them. Essentially, the user should still be able to see the row and column headers, just not the restricted metric data.
I tried setting up Data Access Rights based on Roles, but it either hides the entire row or still shows the Revenue numbers.
Has anyone implemented this type of partial metric-level masking? What is the best way to achieve this?
Thanks in advance!
Best answer by Chahat
Hi @Monika Chauhan ,
I hope , I have understood your question correctly.
Metric: Cost
Metric: Gross Margins
Metric: Revenue
These 3 metrics are at dimensionality: Country and all the users can see the data in the initial 2 metrics. To apply the access rights on revenue metric:
Create a metric with “Country” and “Users” List
Add the logic here in the above metric
Apply the rule configuration of this AR metric to the “revenue” metric only
Open the Revenue metric → settings → Access Rights → Access Rights rules section → Check which all rules are applied to this metric → There must be just 1 rule here
Once you will apply just 1 rule to the revenue metric, then the column/row headers will be shown to all the users and the values of revenue metric based on user role and AR metric
Make sure to apply the “Show empty rows and columns” feature in the table/grid
I hope , I have understood your question correctly.
Metric: Cost
Metric: Gross Margins
Metric: Revenue
These 3 metrics are at dimensionality: Country and all the users can see the data in the initial 2 metrics. To apply the access rights on revenue metric:
Create a metric with “Country” and “Users” List
Add the logic here in the above metric
Apply the rule configuration of this AR metric to the “revenue” metric only
Open the Revenue metric → settings → Access Rights → Access Rights rules section → Check which all rules are applied to this metric → There must be just 1 rule here
Once you will apply just 1 rule to the revenue metric, then the column/row headers will be shown to all the users and the values of revenue metric based on user role and AR metric
Make sure to apply the “Show empty rows and columns” feature in the table/grid
