Help in section access problem

[ariel_klien]

Hi all,

I am using in my model section access to show specific data to a specific user.

In my model I have one tab that I want to show for a specific user all data

but in the others tabs this user will see what is permitted for him in the section access.

Any idea?

BR

Ariel

permition permition

[alexandros17]

The only way is loading data again and create another cloud not linked to the one used with section access

[ariel_klien]

Hi Alexander,

Thank you for your answer,

but what do you mean with "create another cloud not linked to the one used with section access"

BR

Ariel

[alexandros17]

If the field reducted from section access is for example "myField" you have to reload data with another table whose fields have different names from all the field you have (the table or tables don't have to connect to any of tables you have used yet) in this way you will have a set of tables totally disjoined from the tables you manage with section access, this data will not be recucted.

[ariel_klien]

Thanks,

But I want the data redacted for this user except 1 tab.

BR

Ariel

[ariel_klien]

Hi

Any suggestion anyone?

Ariel

[#7]

You can create flags. So to view a certain tab the user needs to have certain access rights, then you can add conditional show on the sheet.

Please see attached example.

I have commented out the section access, add your own NTNAME and reload the data. You should only see tab 1.

Go in to the script and change the flag value to 2 and reload the data now you should see tab 1 and 2.

Hope this helps.

[ariel_klien]

Hi Zohaibirshad,

Thanks for your help, but it doesn't what I need.

I need that x user will see all tabs with his data (not other users data) , but in the last tab (and only in the last tab) he will see all other users data + his own data.

I hope that is explaining my problem.

BR

Ariel

[#9]

Hi Ariel,

I understand.

Please see attached example. I have modified the Section Access.

The attached example is based on division. Add your own NTNAME and reload the data you will see sales for divisions 1 and 3 on MyData tabs and all sales by division on the AllData tab.

The data reduction is done on your NTNAME which returns the users division (s).

The division is added to a variable and used in Set Analysis in the straight table.

Hope this helps.

Thanks

Zohaib