Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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  ?

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

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.

View solution in original post

10 Replies
Not applicable
Author

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
Master III
Master III

Hi Jack,

This is because you are having section access restriction .

Thanks,

sudeepkm
Specialist III
Specialist III

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
Author

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

nilesh_gangurde
Partner - Specialist
Partner - Specialist

hi jack.

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

-Nilesh

sudeepkm
Specialist III
Specialist III

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

Not applicable
Author

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
Author

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 .

jonathandienst
Partner - Champion III
Partner - Champion III

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