How to show Custom Totals in row

Question

Hi All,

Thanks in advance, need some help in the approach for below Business Use Case

Scenario: The team what to show Others Total in Row Level as shown below same.

Note: our SSAS Tabular Cube is using Row level security. Based on current login we check the access role and respective Active Directory Distribution list is added to the role.

EX: lets assume i am sales Person, i want to see my sales and the sales done by other team in the same location but when displaying the totals i need to show as others in row.

Location Sales
India 1000
India -Others 5000
Totals 6000

Answer 1

Hi,

Since you have implement row level security in you model, end user could not access other users Sales data. You would have to add an hidden aggregate table to this model.

For this example as you mentioned, we need to create a hidden table that the aggregated values obtained ignoring the entity that is subject to security filters. Then you could have the [All India Sales] - [India Sales 1] to get the [India -Others]. This kind of scene is called non visual total.

You could follow this guide and steps to resolve you problem : implement non visual totals.

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November