Section Access with 2 Fields

[Anonymous]

I have 2 fields that I want to use for Section Access, MODALITY and TERRITORYNUMBER.  However, I get a loop (ambiguous joins) when both fields are defined in the Section Application.

This is the Section Application of my file with the 2 fields:

Section Application;
STAR is *;
DocSecurity:
LOAD * INLINE [
SAUSER, TABACCESS.ABOUT, MODALITY, TERRITORYNUMBER
SHC\SVC_SCRIPT,   1, *, 102
SHC\ROBYNR,   1, PET/CT, *
SHC\TESTLOGON2,  1, MRI, *
];

  Below shows the loop (dotted lines) with the 2 Section Application fields:

When I only specify 1 field, either MODALITY (see below)  or TERRITORYNUMBER in the Section Application, it works.

Section Application;
STAR is *;
DocSecurity:
LOAD * INLINE [
SAUSER, TABACCESS.ABOUT, MODALITY
SHC\SVC_SCRIPT, 1, *
SHC\ROBYNR, 1, PET/CT
SHC\TESTLOGON2, 1, MRI
];

How can I get both MODALITY and TERRITORYNUMBER to work for Section Access? 

I'm including a sample QVW named Scans Territory_Modality.qvw so you can see my data model along with the xls files that are included.

Any help would be greatly appreciated!  Thanks in advance.

[lironbaram]

hi

the script below will illustrate how to create two fields data reduction

the concept is to create to separate Data reduction fields in the section access , and to connect

each data reduction field to different field in the model

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,REDUCTION,REDUCTIONB

    ADMIN, ADMIN, 1234, A,A

    USER, AAAA, 1234,B,A

    USER, BBBB, 1234, B,B

];

Section Application;

STAR is *;

LOAD * Inline [

REDUCTION,Modality

A,*

B,MR

];

LOAD * Inline [

REDUCTIONB,TerritoryNumber

A,*

B,102

];

attach is the demo app

access the app once as user AAAA , password 1234

and secondly with user BBBB password 1234

[Anonymous]

Thank you very much for the info.  I'm going to try this and will let you know within the next day or so.