Section Access Script load issue

[Anonymous]

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

[tresesco]

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.

[ashfaq_haseeb]

Hi,

Does your Application.qvw

Had section access.

Regards

ASHFAQ

[Anonymous]

Hi Ashfaq/Tresesco,

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

Thanks & Regards

Jeba

[ashfaq_haseeb]

Hi,

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

Regards

ASHFAQ

[#6]

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

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

Section Access dont support optimized qvd load

[tresesco · Accepted solution]

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;

[Anonymous]

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

[tresesco]

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()'.

[jagan]

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.