topic Re: Section Access Script load issue in QlikView

Section Access Script load issue

Anonymous — Mon, 18 Aug 2014 05:08:36 GMT

Dear Experts,

I am trying to load the section access script to my lay out load.

This is the code I am using.

Binary Path\Application.qvw;

SECTION ACCESS ;

LOAD

      ACCESS,
     NTNAME,
    EmpID as %EMPID
FROM
Path\Test.qvd
(qvd);

SECTION APPLICATION ;
STAR IS *;

But the script is not executed.

Can any one guide me what is wrong here.

Thanks & Regards

Jeba

Re: Section Access Script load issue

tresB — Mon, 18 Aug 2014 05:11:29 GMT

May be your application which is being loaded using binary load already has a section access. If so, qv would not allow to have two sections with access rights.

Re: Section Access Script load issue

ashfaq_haseeb — Mon, 18 Aug 2014 05:17:44 GMT

Hi,

Does your Application.qvw

Had section access.

Regards

ASHFAQ

Re: Section Access Script load issue

Anonymous — Mon, 18 Aug 2014 05:20:33 GMT

Hi Ashfaq/Tresesco,

No,I checked my datamodel and it doesn't have section access any where.

Thanks & Regards

Jeba

Re: Re: Section Access Script load issue

ashfaq_haseeb — Mon, 18 Aug 2014 05:23:03 GMT

Hi,

In that case I recommend you to go through the attached document.

Regards

ASHFAQ

Re: Section Access Script load issue

Mon, 18 Aug 2014 05:56:20 GMT

Add to your "LOAD" "WHERE 1=1":

LOAD * FROM MyQvd.qvd(qvd) WHERE 1=1;

Section Access dont support optimized qvd load

Re: Section Access Script load issue

tresB — Mon, 18 Aug 2014 06:50:37 GMT

Try like:

SECTION ACCESS ;

LOAD

     Upper(ACCESS) as ACCESS,
     Upper(NTNAME) as NTNAME,
    Upper(EmpID) as %EMPID
FROM
Path\Test.qvd (qvd) where 1=1;

Re: Section Access Script load issue

Anonymous — Mon, 18 Aug 2014 06:56:05 GMT

Hi Tresesco,

I am trying this and it seems it almost worked.

Could you please explain me what is the logic of 1=1.

Thanks & Regards

Jeba

Re: Section Access Script load issue

tresB — Mon, 18 Aug 2014 07:03:28 GMT

This is to make the load unoptimized as section access doesn't recognize optimized load.

Update:

Just a catch, I guess without 1=1 should work as well because the upper() itself is making the load Unoptimized. Just try without 'where' but with 'upper()'.

Re: Section Access Script load issue

jagan — Mon, 18 Aug 2014 07:10:01 GMT

Hi Dass,

In Section Access Optimized Load not works, when you load without where condition it is Optimized load, that is why we are just giving one dummy condition WHERE 1=1 to make it as non optimized load.

Hope this helps you.

Regards,

Jagan.

Re: Section Access Script load issue

Anonymous — Mon, 18 Aug 2014 07:15:53 GMT

Dear All,

Thanks a lot and it worked perfectly.

Thanks & Regards

Jeba

Re: Section Access Script load issue

vardhancse — Mon, 18 Aug 2014 07:43:23 GMT

Check that Document Properties->Opening

Initial Data reduction Based on Section Acess was enabled or not.

If not try to check and relaod.

Then your section access will filter the data.