Section Table by Resident load

[#1]

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 ?

[hic]

Probably because the autoconcatenate kicks in. Try using Noconcatenate on the last Load.

HIC

[#3]

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.

[hic]

You have a colon ":" after "Section Access". You should have a semicolon ";"

HIC

[#5]

Hi Henric , Typo mistake here.

currently I am using 11.2 SR2 version. Is there any reason why resident load is not working ?

[Anonymous]

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.

[#7]

The data already in Upper case , we are converting to UPPER Case already in QVD.

[Anonymous]

See my "edit"...

[#9]

Ok. I will try that and I will let you know.....

[hic]

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