How to multiple access control for 1 item

Is there any method of multiple access control for 1 item? ex.

Supplier List (with selective access)
	Supplier A
	Supplier B

Plant List (with selective access)
	Plant X
	Plant Y

Item List
		Plant(Property)	Supplier(Property)
	Item1	Plant X	Supplier A
	Item2	Plant X	Supplier B
	Item3	Plant Y	Supplier A
	Item4	Plant Y	Supplier B

User Settings
	Plant Write	Supplier Write
User 1	All Plant	Supplier A
User 2	Plant X	All Supplier

User 1 is allowed to access item 1 and Item 3 User 2 is allowed to access item 2 and Item 4 I can do single access control by setting hierarchy list ex. plant -Item but hierarchy can apply only one list so i cannot apply supplier list. i do not want to apply item, supplier, plant at the same time to same module.(cause to huge sparsity) i want to control this by selective access or filter function or something. is there any solution?

Accepted answers

harish_bk

Hi Ryohei

I guess its tough to get the hybrid list access in current product, you can try following below process

1) Create Vendor list as number list
2) Make Plant list as parent for Numbered list (Vendor)
3) You can have same name Vendor under different plants
4) Have a regular vendor list
5) Have a property in vendor list (Which is list formatted so you can select the name through drop down)
6) Define Security for Plants
7) Then build module using this numbered list where users can add any combination of vendor
8) Build one more moule with Vendor and Plant and then get the required data using sum funciton

Or vice versa

Hope this helps

All comments

harish_bk

sasakawar

Hello Harish,
Thank you for your quick response!
I tried yout proposal, but it's not enough to solve my situation.
User should access item level not only supplier or plant level.
(Sorry for complex requirements....)

ex
Inventory Module (Applying Item List and Time)

	16-Mar	16-Apr	16-May
Item1 (Plant X, Supplier A)	10	20	30
Item2 (Plant X, Supplier B )	30	40	50
Item3 (Plant Y, Supplier A)	60	20	30
Item4 (Plant Y, Supplier B )	70	30	20

User 1 (All Plant, Supplier A) should see…

	16-Mar	16-Apr	16-May
Item1	10	20	30
Item3	60	20	30

User 2(Plant X, All Supplier) should see…

	16-Mar	16-Apr	16-May
Item1	10	20	30
Item2	30	40	50

'** I had mistake in my 1st post, user 2 is allowed to access Item1 & 2, not Item 2&3

So I tried as follows

	Parent
Plant (reqular list)
Supplier (numberd list)	Plant
Item (regula list)	Suppleir

Tree look like as follows

Plant X
L	Supplier A
	L	Item1
	Supplier B
	L	Item2
Plant Y
L	Supplier A
	L	Item3
	Supplier B
	L	Item4

I tried to set selective access to Supplier Level but numberd list seems not be able to set selective access.
(it looks to be set, but it's automaticaly cleared without any messages)

do you have further idea?

harish_bk

Ahh this is tough to handle, but if this is not for security purpose and ease of using the system I have an idea,

1) Create a list having all the users
2) Create a module having all the users, plant, vendor and item
3) Then have a line item called access which is check box i.e., boolean format
4) For each user select the plant, vendor and item they have to see
5) Set up a filter based on this line item
6) Let same cube have all other line items required and you can work accordingly based on the user selected
7) You can set up access to the user list

Am not sure how it works but hope it works

sasakawar

Hello Harish,

thanks for you anoter suggestion.
I could solved the case with your first suggestion.

Lists are as follows

	Parent
Plant (reqular list)
Supplier (numberd list)	Plant
Item (regula list)	Suppleir

and

User setting is as follows

	Selective Access
	Plant	Supplier
User1(All Plant, Supplier A)		Plant X-Supplier A, Plant Y Supplier A
User2(Plant X, All Supplier)	Plant X

*At first i set 'All Plant' to plant selective access for user A, so supplier level selective access was automatically cleared.

Tanks you for your great contribution!!

Ryohei Sasakawa

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
ADO - S3 incremental load vs. full replace
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…