section access - multi-field data reduction

[#1]

I wonder if any one can help me.

I already have section access built in around the country the user is in, however, I now need an addition security added around the division (office) the user is in.

Does any one know of a way to do this or any examples out there that I can use?

[Anonymous]

http://www.youtube.com/watch?v=yADMnvEvGEg

hopes it will help you

[rajni_batra]

add one more column named as division if u r applying section access through excel file.

[#4 · Accepted solution]

Hi John,

There is one thing that took me a couple of hours to figure it out,

When you are reducing by two fields you need to have the exact combination of values between the two fields

at least once in your data.

e.g ;

Data:

     Country, Dividion

     USA, MM

     USA, FI,

     ISR, MM

     ISR, CO

So if you reduce by USA, CO   or ISR, FI   the reduce will fail.

Hope it helps.

Regards

Yigal

[Miguel_Angel_Baeyens]

Hi John,

Check the example codes in this post, this other post, this thread, among many others! All them discuss section access with two reduction fields, and one of those fields being at a greater level (say country > region, for example).

Hope that helps.

Miguel