Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, I am facing very wired problem as my section access is not Working when I am creating the Section Table with Resident Load
Then I changed to QVD its working fine.
Here is my script (Resident Load):
TempSecurity:
LOAD NTNAME ,
ACCESS ,
DEPARTMENT
FROM BI_SALES_SECURITY.qvd (qvd) ;
//Adding some new departments to existing qvd
Concatenate (TempSecurity)
LOAD * INLINE [
NTNAME , ACCESS , DEPARTMENT
**** ,***** ,******
****,*****,*****
****,*****,*******
];
Section Access:
SectionTable:
LOAD NTNAME ,
ACCESS ,
DEPARTMENT
Resident TempSecurity ;
Section Application ;
The above script is not worked for me. The script executed with out any error and I tried and to open after reload I git Access denied Error.
So I create another qvw where I add the INLINE table and creates the new security qvd and Section Access worked.
Why Resident Load is not worked on SectionTable ?
Probably because the autoconcatenate kicks in. Try using Noconcatenate on the last Load.
HIC
I tried with breaking the Auto concatenation by changing the filed name in the TempSecurity table Like below:
TempSecurity:
LOAD NTNAME ,
ACCESS AS A,
DEPARTMENT AS B
FROM BI_SALES_SECURITY.qvd (qvd) ;
//Adding some new departments to existing qvd
Concatenate (TempSecurity)
LOAD * INLINE [
NTNAME , A , B
**** ,***** ,******
****,*****,*****
****,*****,*******
];
Section Access:
SectionTable:
LOAD NTNAME ,
A AS ACCESS ,
B AS DEPARTMENT
Resident TempSecurity ;
Section Application ;
This is one also still not working.
You have a colon ":" after "Section Access". You should have a semicolon ";"
HIC
Hi Henric , Typo mistake here.
currently I am using 11.2 SR2 version. Is there any reason why resident load is not working ?
Try using upper() function:
upper(NTNAME) as NTNAME
upper(ACCESS) as ACCESS
...
Edit: Section Access must use uppercase values. I recommend to always use this function in Section Access except the inline load. Even if you know that fields are already in uppercase in the database or excel or etc.
The data already in Upper case , we are converting to UPPER Case already in QVD.
See my "edit"...
Ok. I will try that and I will let you know.....
I agree with Michael on the Upper() function. And - no - I do not see why it shouldn't work.
Commenting the "Section Access;" statement is one good way to debug...
HIC