topic Re: Section Access script execution in QlikView

Section Access script execution

renjithpl — Mon, 21 Oct 2013 13:11:02 GMT

Hi All,

Perhaps, this is a basic thing, but would like to understand two things.

1. In the Edit Script, i have moved my Section Access script/tab to last.

Does it make any difference while execution.

2. Resident load or loading from QVD is faster. ?

Regards

Ren

Re: Section Access script execution

Gysbert_Wassenaar — Mon, 21 Oct 2013 14:18:55 GMT

1. The Section Access table needs to be created before loading the actual data

2. That depends. With large data sets loading from qvd can be faster than using a resident load. If you need an order by clause then a resident load is necessary. If you need to further process the data from the qvd file then an optimised load may not be possible and loading from qvd may be (as) slow as using a resident table. You'll have to test to be sure what works best in your situation.

Re: Section Access script execution

renjithpl — Mon, 21 Oct 2013 14:50:51 GMT

Hi Wassenaar,

Agree with number 2. Done!!

Number 1.

My question is, what if my section access code requires one field from a table which is excuting after Section access script.

Eg:

AllStateLevel:

Load Concat(DISTINCT STATE_LEVEL_UAM,',') as AllStateLevel

Resident Sales;

Let vAllStateLevel = peek('AllStateLevel', 0, 'AllStateLevel');

Section Access;

[SA TABLE]:

LOAD ACCESS,NTNAME,UPPER(NTNAME) as MAPPER,
Upper(NTNAME) as MAPPER_STATE_LEVEL,
UPPER(NTNAME) as MAPPER_TABS

FROM$(vSecurity)$(vTabletype);

Section Application;

[MAPPER State_Level]:

LOAD UPPER(MAPPER_STATE_LEVEL) as MAPPER_STATE_LEVEL,
If(STATE_LEVEL_UAM = '*', SubField('$(vAllStateLevel)', ',') , SubField(STATE_LEVEL_UAM, ',')) as STATE_LEVEL_UAM

FROM$(vSecurity)$(vTabletype_StateLevel);

In here, i need vAllStateLevel variable which is executing in my sales.

In this case, if i run section access script first, how its gonna consider this variable.?

Re: Section Access script execution

Gysbert_Wassenaar — Mon, 21 Oct 2013 15:51:55 GMT

In this case, if i run section access script first, how its gonna consider this variable.?

That shouldn't give any problem. The section access table doesn't need anything from AllStateLevel. And afaik section access can't be applied until all the application data has been loaded and all access paths can be calculated. But don't take my word for it. Test!

Re: Section Access script execution

hugmarcel — Wed, 31 Aug 2016 20:14:49 GMT

You write that

"1. The Section Access table needs to be created before loading the actual data"

I have some scripts where section access is in the middle of the script, having normal application load statements before and after the section access (they are loaded with partial load).

I have no problems using section access in such manner.

? Thx - Marcel