I have three groups
a,b,c
I have a user “x” who belongs to two groups b & c
In the universe I have three restrictions r1,r2,r3
and the restrictions are applied to a, b,c
i.e
r1 on a
r2 on b
r3 on c
“combine row restrictions using AND within a group hierarchies and OR between groups” has been selected.
If I “preview” the restrictions for user “x” it show up as r2 or r3 which is CORRECT.
However when I export the report to the CMC and run an ahoc query using webi, no restrictions are applied. If I make the user “x” a member of only one of the group then the corresponding restrictions are applied.
Any suggesstions
NBG (BOB member since 2005-07-18)