Section access based on fact data

SunilChauhan — Tue, 05 May 2015 08:33:18 GMT

Hi all,

Hope you all doing good!

I have below scnario

Table1:

ID1 ,Dept

1 , Corp

table2:

ID2,Dept

1,Corp

after concatinating above Two tables i have data like below

ID1 ,Corp ,ID2 Corptable1,Corptable2

1,Corp,Blank ,Corp ,Blank

Blank,Corp,1,Blank,Corp

I doing section access on Corp field

which is working good but when i select Corp in dept field

fro table one Dept have two values

Dept

Corp

Blank

and same for table 2.

My requirement is if i give section access for Dept=Corp

then Corp should be in dept in first and second table not blank.

required your valuable help on this.

above example is for two table but i have 6-7 table with same situation please suggest.

Thanks

Sunil

Re: Section access based on fact data

SunilChauhan — Tue, 05 May 2015 10:36:36 GMT

any reply on this please?

hubertdudek — Tue, 05 May 2015 11:01:03 GMT

are you using data reduction option for document/server ? it will remove unnecessary data