Single Application with Multiple configurations

[hobanwashburne]

I have a sales analysis application that is used by people in a variety of roles such as Regional Managers, Branch Managers, and Industry Specialists. I would like to build one application and selectively hide/show the relevant sheets. For example:

Configuration 1
Name: Admin
Description: All sheets shown
Reduce by Field: None

Configuration 2
Name: Regional Manager
Description: Sheets 1, 2, 3, 5, 7 shown
Reduce by Field: Region Name

Configuration 3
Name: Branch Manager
Description: Sheets 1, 2, 7 shown
Reduce by Field: Branch Name

Configuration 4
Name: Industry Specialists
Description: Sheets 1, 2, 5, 7 shown
Reduce by Field: Industry Name

Does anyone know of an example similar to this?

[florentina_doga]

use section access

[maxgro]

I think you have to mix

sheet level access

Sheet level access

and for multiple fields authorization

Data Reduction Using Multiple Fields

[swuehl]

You can have a look into

Data Reduction – Yes, but How?

following also the discussion about pros / cons of object based security (i.e. show / hide conditions) and referenced documents on section access.

If you absolutely want to hide sheets, you can create an appropriate show condition in sheet properties.

[buzzy996]

implementing section access is the solution for this.

some thing like below,

User Based Access (Sheet level):

Section Access;
Load * Inline
[ACCESS,USERID,PASSWORD
ADMIN,A,X
USER,U1,Y1
USER,U2,Y2
USER,U3,Y3
USER,U4,Y4
USER,U5,Y5];

Section Application;
Load * Inline [
USERID,Main,Sheet1,Sheet2
A,1,1,1
U1,0,1,1
U2,0,1,0
U3,0,0,1
U4,1,1,1
U5,1,1,0
];

[florentina_doga · Accepted solution]

please enter with user aa and password aa1

or

user bb and password bb1

or

user admin and password admin1