Section access twice inside the script

Mon, 07 Dec 2009 20:44:04 GMT

Hi,

I want to put the section access code twice inside the script of one QV document.

This is as bellows:

QVtab1:

LOAD "USER_ID",

"USER_NAME",

"USER_ACCESS",

ABSORPTIONBYPERIOD,

REPORT2,

REPORT3,

REPORT4;

SQL SELECT *

FROM "USER_REPORTS_MENU_VW1";

QVTab2:

LOAD "USER_NAME",

"USER_ACCESS",

"LOCATION_NUM",

PNO,

"SUPPLIER_NUM",

"SCENARIO_NUM";

SQL SELECT *

FROM "PRO_LOC_SP_SC_DATA_SECURITY_VW";

//implementing security

SECTION APPLICATION;

//IMPLEMENTING NTLOGIN

Section Access;

Load

upper(USER_ACCESS) as ACCESS,

upper(USER_NAME) AS NTNAME,ABSORPTIONBYPERIOD,

REPORT2,

REPORT3,

REPORT4

Resident QVtab1 ;

Load

upper(USER_ACCESS) as ACCESS,

upper(USER_NAME) AS NTNAME,LOCATION_NUM,PNO,SUPPLIER_NUM,SCENARIO_NUM

Resident QVTab2 ;

Section APPLICATION;

Load USER_NAME,ABSORPTIONBYPERIOD,

REPORT2,

REPORT3,

REPORT4 Resident QVtab1;

Load USER_NAME,LOCATION_NUM,PNO,SUPPLIER_NUM,SCENARIO_NUM Resident QVTab2;

But this is failing to open the document.

Here the first level is for report level security and second one is for data security inside the document.

Will anyone please provide me some solution for the same?

Thanks & Regards,

Mahasweta

topic Section access twice inside the script in QlikView

Section access twice inside the script