How to write Section access Based on Measures ?

[shekhar_analyti]

Hi All ,

How to write Section access Based on Measures

Requirement :

1) If any of the managers opens the application then he/she should see only sales data of his own , highest sale and lowest sale in chart and then his position in text box .

   But should not be able to loss and revenue data .

2) If ADMIN opens the application then he/she should see all the 3 chart and data of slaes , loss and revenue .

3) If USER2 opens the application then he/she should see 1 chart showing and data of  revenue only  .

4) If USER3 opens the application then he/she should see 1 chart showing loss and data of  loss only .

Thanks & Regards

Shekar

[Peter_Cammaert]

You cannot base "Section Access on measures" because SA manages your data and some extra data model elements. You can however add flags to your SA data as pseudo-permissions and use them in the conditional show expressions of objects, sheets, dimensions and expression. Or you can use the OMIT feature to drop some of your facts for specific users. The expressions that use these facts will follow suit and disappear from your charts due to lack of data.

[shekhar_analyti]

Hi Peter ,

Thanks for reply .

It will be really helpful if you can attach sample using my qvw .

[shekhar_analyti]

any workaround loveisfail‌stalwar1‌

[Peter_Cammaert]

The technique is very well explained by Jagan here: Chart Level Access by user

The same trick can be used to show/hide dimensions and expressions.

[Anil_Babu_Samineni]

Is this you are expecting? I've table like below

If, Application Login from User for A. Are you looking for this?

And Table box is this?

[shekhar_analyti]

If A logins then sales of A , Sales B or D which is highest and sales of C (if its less than A),

Basically sales of user A and sales of another user which is maving Maximum sales and sales of user which is having minimum sales

[Anil_Babu_Samineni]

Sorry to say, Not getting anything.

From my data what would be the output if A login happened or share sample data set and explain bit more