a MDM Scenario Regarding accessing and displaying data

[Former Member]

Hi All,

If there is a scenario such that there is a Manufacturer field from Main table[ Products ], has some vaues say A, B, C, etc. A suppose belongs to India, B to USA, C to UK, etc respectively. Then how can we do this that if a user is assigned to Manufacturer A, then that user should be able to see all the values even from B and C manufacturers also, But User should be able to modify the data which belongs to manufacturer A only.

Can Anybody please help me in this regard As to how can I achieve it in MDM.

Edited by: Gaurav Kumar Sharma on Mar 10, 2010 11:41 AM

[Former Member]

Hi Gaurav,

If you are not allowing selection of Manufacturer B or C for user belonging to Manufacturer A.

Then what is the need/benefit of showing him/her Manufacturer B and C values?

-- Shaailesh.

[Former Member]

Hi Shailesh,

Actually this was asked by a client as a query asking whether is it possible or not?

So I tried many a combinations but was not able to do these things.

Anyways Thanks for your input.

Regards

Gaurav Kumar Sharma

[Former Member]

Hi gaurav,

Did u try whatever i suggest or its inefficient for u.

Thanks

Sudhanshu

[Former Member]

Hi Gaurav

This is not possible using standard MDM roles and constraints.

As a workaround if you are using Portal as UI this can be achieved by designing some delta tables which will have access information based on key attributes.

best regards

Ravi

[Former Member]

Hi All,

Is it possible??

Create a role that have only read access to all records and create each another roleN that have read write access to corresponding manufacture like for each manufacture there is a read write role for corresponding records(we can achieve by namedsearch).

Finally assing user for manufacture A to both role A and read role

user for manufacture B to both roleb and read role

(i think it take the union of both roles).

I will try on my system tomorrow and update u on same sp for a mean time if u get cahnce please try it if it looks good,

Please suggest something better if possible.

Thanks,

Sudhanshu

[Former Member]

Hello Gaurav Kumar Sharma

Create validator IF( manufacturer.[Record]=manufacturer.[ A ], TRUE,FALSE) and set its property "Automatic execution= Error"

Regards

Kanstantsin

[former_member205403]

Hi Kanstantsin,

This validation will be applicable to all the Users and how we will check whether user who has logged into MDM belongs to Manufacturer A and should have access to modify records of manufacture A only. And any user B or C other than Manufacturer A should not have access to modify these records. I doubt if this kind of requirement can be fulfilled.

With this validation User B can modify records belonging to C Manufacturer.

Please let me know your comments.

Regards,

Shiv

[Former Member]

Hi Shiv

Yes.You are right.

I don't know repository schema for clear recommendations.

If manufacture is taxonomy or LUT you can create permissions for role

and then delegate role to one or several users.

In that case user can see only his manufactures and that validation will be work.

you can add UserStamp field to repository and create spesial LUT(users,manufactutre)

and match UserStam value and LUT -(but you should fill LUT previously)

Regards

Kanstantsin

[Former Member]

Hi ,

What is this LUT??

Thanks,

Sudhanshu