Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement : When a User logs in he needs to be given access based on a Business Segment .This is true for all sheets except one. When he moves to say Sheet-Exception he needs to view all data. Is this possible? Are there any alternative solutions?
Yes - if you when you say "When he moves to say Sheet-Exception he needs to view all data" means that he will see all Business Segments but only the exception rows and exception fields.
The user has restricted access based on section access on the field - business segment. But when the user moves to a particular sheet user needs to see all data without restricted access.
Section Access does not connect to where in the application you will have restriction on what a user might access. Based on Section Access you give access based on rows and fields in the data model. Your data model is fully available on any sheet in the same way.
Could you explain what you mean by exception:
1) Is it an exception to the normal restrictions of what the user can access you mean?
2) Or is it exceptions in the business data?
Section Access does not connect to user interface like sheets. So no you can't modify the section access rules when the user moves into another sheet. What is possible to visualize in one sheet will also be possible to visualize in any other sheet.