Initial data reduction based on section access

[Anonymous]

We have a dashboard deployed with section access. Previously, we had data for 2014 and 2015. As per the section access, each users can just see their own data.

We updated the DB with 2016 and when I refresh the App and save it, the 2016 data is not showing up in the access point. When I uncheck the Initial data reduction based on section access, then the 2016 data shows up but all the users are able to see all the data. Please advise what's the fix.

[swuehl]

Can you elaborate how your section access table and the reduction fields / link to your section application table look like?

[#3]

Is the Strict Exclusion checked?

When you check in the Access Point, what is the Access for that ID? Is it Admin or User. If it is User, what is the Reduction applied applied to that user? can you be more specific.

[Anonymous]

Here is the screenshot and the script. If I uncheck initial data reduction, I can get 2016 but all users are able to see the data.

Binary [\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\01_Extract_QVW\patient.qvw];

Section Access;

LOAD UPPER(NTNAME) as NTNAME, 

     UPPER(ACCESS) as ACCESS,

     UPPER(PROV_ID) as ProviderID_Selected

FROM

\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\QVD\Extract\PatientAccess.QVD

(qvd)

WHERE 1=1;

Section Application;

[Anonymous]

Here is the screenshot and the script. If I uncheck initial data reduction, I can get 2016 but all users are able to see the data.

Binary [\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\01_Extract_QVW\patient.qvw];

Section Access;

LOAD UPPER(NTNAME) as NTNAME, 

     UPPER(ACCESS) as ACCESS,

     UPPER(PROV_ID) as ProviderID_Selected

FROM

\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\QVD\Extract\PatientAccess.QVD

(qvd)

WHERE 1=1;

Section Application;

[#6]

Could you please share definition of your Section table. and what is the reduction link?

[Anonymous]

Hi Santosh,

Has the data format changed? If formats are not same, Section Access will not work.

Has users reduction of dates or years?

Kind regards

[rrsrini2907]

Hi Santosh,

Check your section access reduction field and the section application field values, the 2016 might be filtered as part of your section access reduction

or the section application doesn't have the relevant value for that 2016 year.

Regards,

Srini.

[swuehl]

I think you should capitalized field names, also for the reduction field:

UPPER(PROV_ID) as PROVIDERID_SELECTED

(also need to rename the field in section application.

I still don't see how your reduction field values are linked to your section application table.

[Anonymous]

There is a data tier which has the below script

SecurityProvider:

LOAD NTNAME,

     USER_ID,

     NAME,

     PROV_ID as PROV_ID,

     Practice as Practice,

     [QlikView App],

     Access as ACCESS,

     Active

FROM

[\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\ExternalData\Section Access.xlsx]

(ooxml, embedded labels, table is Section_Access)

WHERE [QlikView App] = 'Patient_Experience_Provider' AND Active = 'Y' ;

STORE SecurityProvider INTO [\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\QVD\Extract\PatientExpProvider_Access.QVD];

DROP TABLE SecurityProvider;