Object security - two conditional layouts

[#1]

I currently have the following section access logic applied to my QVW file and I am trying to apply the 2 different accesses (SIACCESS, EEMSACCESS) to two different objects.

So on one object I have the Layout > Conditional if(SIACCESS=1,1,0) and the other if(EEMSACCESS=1,1,0).  The issue is the security being used for both is from the SIACCESS or SIDATA...is there a way to have separate accesses applied.  i have also attached the .xls file referenced in the logic.

LOAD * INLINE [

    SIACCESS, EEMSACCESS

    1,1

    0,0

];



Section Access;

[Security Table]:

LOAD ACCESS,

     NTNAME, 

     SIDATA,

     EEMSDATA

FROM



(ooxml, embedded labels, table is Sheet1);



Section Application;

LOAD * Inline [

SIDATA, SIACCESS, EEMSACCESS

Y,1,1

N,0,0

];

[juc]

Hi Steve,

I think the problem here is that anytime you have a value of 1 for EEMS, you also have a value of 1 for SI:

Section Application;
LOAD * Inline [
SIDATA, SIACCESS, EEMSACCESS
Y,1,1
N,0,0
];

I think it would be better to control all access based off of one combined variable to be used in all show-hide conditions, rather than two.

SIDATA	EEMSDATA	CombinedVariable
Y	Y	3
Y	N	1
N	N	0
N	Y	2

In your show hide condition, you could have something like the following:

SI Charts:

=if(CombinedVariable=3,1,

If(CombinedVariable=1,1,0)

)

EEMS Charts:

=if(CombinedVariable=3,1,

If(CombinedVariable=2,1,0)

)

Hope this helps!

1. Thanks.

-Jesse