user groups/profiles for every country!!

[Former Member]

Hi,

I have user groups for every country in CMC and Universe security.

Like

     For India           -     India-Group-Rows

     For Australia     -     Australia-Group-Rows

User requirement is - he want access for both countries.

if i grant access to both Groups to get access, it's not working.

Reason:  WHere clause 

Country='India'

and

Country='Australia'

[Former Member]

If you are using IDT with Data Security Profiles, set the "Row Restriction Aggregation" level to "Less restrictive (OR)' in the Data Security Profile Options.

This will combine the DSPs with an OR between them instead of an AND (most restrictive, and the default, but not what you want in your particular case).

If you are using UDT or pre-BI4 Designer, check out how to do the same thing here:

[Former Member]

Thanks Emily.

If we enable the below settings, hope it works.. thanks..Let me try

Thanks,

Bhaskar

[nscheaffer]

I have not really done much with universe security, but seems to me that you should be using OR rather than AND since it is not logically possible for the country to be both 'India' and 'Australia'.  Try making your where clause this...

Country='India'

and

Country='Australia'

Noel

[Former Member]

Noel,

Two countries - two groups , so it will automatically add AND to the query. So it's not working..

I think we need add single group to the both countries.

Thanks,

Bhaskar 

[nscheaffer]

Can you please provide a screenshot?

Noel

[former_member201488]

I would suggest a restriction like this:

...applied to a new custom group.

HTH

NMG