binary load and section problem

[#1]

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  ?

[#2]

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]

Hi Jack,

This is because you are having section access restriction .

Thanks,

[sudeepkm · Accepted solution]

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.

[#5]

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

[nilesh_gangurde]

hi jack.

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

-Nilesh

[sudeepkm]

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

[#8]

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

[#9]

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]

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