Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Hi Jack,
Do you have any section access to restrict access data in you qvw files ? either the source or the target one.
Fabrice
Hi Jack,
This is because you are having section access restriction .
Thanks,
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.
I know section affect it . I use admin user the same. I don't use the dimension
hi jack.
just check how mucha access u have, its fine that you are opening the document as admin.
-Nilesh
Can you please give the snapshot of your section access table script along with few data.
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
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 .
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