Problem with Complex Section access implementation . Help Needed !!

[shekhar_analyti]

Hi All ,

Attached is sample qvw and data .

Here is my requirement .

1) Each Store has its manager and manager's employee ID .

   So if a manager of particular country logins into application then he/she should have access of "Store Manager" sheet with his data        only

2) Country head should have access to All the sheet but data of only its county and all the stores under his country .

3) Sales Manager should have access to Sales sheet

4) Hr Manager should have access to HR sheet only

Note : USERID is Mnager Name and Password is employee ID of manager .

I tried but It did not work properly with below code

[shekhar_analyti]

Hi Antonio ,

Thanks for highlighting that . But i am confused now .

Actually STORE for Keriv Bojo should be all the stores under Germany i.e De . And its Emp_ID is DE10099 .

I thought data reduction will take care of   "*"  in above case and will automatically consider all stores under it .

Lets assume that there is no such sheet called user profile . USERID  is Name of Mangers and PASSWORD is its store numbers .

And we have to build section access using datasheet from different countries and Country Head and DP Head.xlsx .

How to revamp the whole Section Access ?

Thanks & Regards

Shekar

[antoniotiman]

Why

"STORE for Keriv Bojo should be all the stores under Germany i.e De " ?

STORE for Keriv Bojo is '*' and isn't possible get COUNTRY because Country comes from STORE field (other USER).

Can I get Country from Emp_Id field -> left(Emp_Id,2) (only for ACCESS ADMIN) ?

If Yes Then See Attachment.

[shekhar_analyti]

This is something what i wanted and was struggling with for some time .
But only thing is that you , used User Profile sheet which i created for my own use . Actually Instead of User Profile

sheet , Country Head and DP Head sheet was to be used to achieve above result where

Sales	KL Kapoor	IN100171
Hr	Kaite Bakeson	RU100121

KL Kapoor could only access HR Sales sheet of app and Kaite Bakeson could only access HR sheet of app , along with above mentioned functionality that you have is your last attachment .

Thank You Very Much for helping me so far . 

[antoniotiman]

KL Kapoor  -> sheet  Sales

Kaite Bakenson -> sheet HR

and sheets Country Head and Store Manager ?

See Attachment

[shekhar_analyti]

Thanks Antonio for reply

I guess the last attached qvw is not accepting Manager User IDs example - Keriv Bojo

KL Kapoor being sales head should have only access to sheet sales of all country not Just India .

Similarly Kaite should have only access to HR sheet and all the data irrespective of her country .

[antoniotiman]

HI,

I'm sorry, I don't understand.

What is Your final expected result about all USERID,ADMIN,KL Kapoor and Kaite ?

[shekhar_analyti]

Hi Antonio ,

Sorry for delayed response .

So I will now give my requirement from scratch .

Need a build section access where

1) Country heads will have access to all sheets of the application , having data relevant to their country .

2) DP (Department Head) should have access to respective sheet .

Example - KL Kapoor is Sales Head . He should have access to only Sales sheet of application with data of all countries . Note: Though he is from India , still he being sales head should have access to all the data in sales sheet, irrespective of country . Same Goes for HR head Kaite Bakeson.

3) Each store has store manager . So each store manager should have access to all the sheet with data of their own stores

Note : We have to use data sheet of all countries and data sheet with name country head and dp head . Please ignore user profile sheet (as I created it by copy pasting USER Name and password)

In order to achieve this functionality in a single application , do we have to revamp whole load script again ?

Thanks & Regards

Shekar

[shekhar_analyti]

Hi Antonio ,

Any thoughts in requirement . Let me know i am not able to make myself clear .

Thanks & Regards

Shekar

[antoniotiman]

Who are Country Heads and Department Heads ?

Can You provide new file User_profile ?

[shekhar_analyti]

PFA ...