Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

binary load and section problem

I am using binary load .  when I use the section application in qvw file after binary load,I find some data missing . It is ok after reload it and then  I save the qvw file and open it, the data still miss(see temp1 ). if I reload in the qvw file ,the data is ok (see temp2).  what reason  ?

Tags (2)
1 Solution

Accepted Solutions
sudeepkm
Valued Contributor III

Re: binary load and section problem

You may have to check your Section Access logic and fields. Section Access follows the section access table strictly that mean if in your data if you have certain field values as null or blank and that has not been taken care (to some default values) then while using section access those data could be ignored.

10 Replies
Not applicable

Re: binary load and section problem

Hi Jack,

Do you have any section access to restrict access data in you qvw files ? either the source or the target one.

Fabrice

amit_saini
Honored Contributor III

Re: binary load and section problem

Hi Jack,

This is because you are having section access restriction .

Thanks,

sudeepkm
Valued Contributor III

Re: binary load and section problem

You may have to check your Section Access logic and fields. Section Access follows the section access table strictly that mean if in your data if you have certain field values as null or blank and that has not been taken care (to some default values) then while using section access those data could be ignored.

Not applicable

Re: binary load and section problem

I know section affect it .  I use admin user the same.  I don't use the dimension

nilesh_gangurde
Valued Contributor

Re: binary load and section problem

hi jack.

just check how mucha access u have, its fine that you are opening the document as admin.

-Nilesh

sudeepkm
Valued Contributor III

Re: binary load and section problem

Can you please give the snapshot of your section access table script along with few data.

Not applicable

Re: binary load and section problem

the section is as following ;

SECTION ACCESS;

USER_ACCESS:

LOAD ACCESS,

     USERID,

     PASSWORD,

     USERGROUP1,

     USERGROUP2,

     USERGROUP3

FROM $(DIRB)\权限用户表.xls

(biff, embedded labels, table is 用户列表$);

SUB LOADRIGHT(USERGROUP,RIGHT_NAME,RIGHT_TABLE)

SECTION APPLICATION;

STAR IS *;

$(RIGHT_TABLE):

LOAD USERGROUP as $(USERGROUP) ,

     if($(RIGHT_NAME)='YES','*',$(RIGHT_NAME)) as $(RIGHT_NAME)

FROM $(DIRB)\权限用户表.xls

(biff, embedded labels, table is 分组权限$);

SECTION Application;

END Sub

Not applicable

Re: binary load and section problem

the data  is sill  missing  when I open  the document as admin .. I must reload and it is ok. ;I think it should not occur these data after  reloading  if section restrict data .

MVP
MVP

Re: binary load and section problem

Hi

Section access is applied when the document is opened, and not when it is reloaded, so the data restriction will not apply immediately after a reload. So if this security is important, you will need to limit the number of people who are able to perform a reload (typically administrator(s) and the QV service account).

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser