Enable data protection at mutiple members of a custom dimension

811851 Jul 6, 2011 2:33 PM

Hi All,

I need to protect the data at some selected members of a custom dimension. Say AllCustom1 is a parent of Child1, Child2, Child3, Child4 and Child5. Now, we can save/protect data at either Child1 only or at all the members except Child1 as per the operators provided ( "=" or "<>"). The client requiremnt is to protect the data at Child1, Child2 and at Child3 only. Please let me know if that is possible. Also, all the four dimensions are occupied that is no other dimension is available for me to use.

Thanks in advance for your advice.

Edited by: 808848 on Jul 6, 2011 7:33 AM

1. Re: Enable data protection at mutiple members of a custom dimension

SH_INT Jul 6, 2011 2:51 PM (in response to 811851)

This is not possible with the out of the box data protection as it only lets you specify a single protection value. Unless your Child1, Child 2 and Child3 have some common substring that is not present in Child4 or Child5 or any member of the other dimensions then you will not be able to achieve what you are looking for.
Like Show 0 Likes(0)

Actions
2. Re: Enable data protection at mutiple members of a custom dimension

GCAPO Jul 11, 2011 3:05 PM (in response to 811851)

I suggest you turn on the security for Custom1 in HFM, assign each child its own security class, then assign security rights to users to mix and match (READ, ALL, None) the access needed. FDM will only allow a user to load data to the members if the user has ALL access to all intersections.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.