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

Problem with QvSAPOLAPConnector

Dear all,

I have a problem with the automatic script generated when I connect to SAP BW.

I use the assistant to generate the scripts.

My first script to download the cube BW in the QVD file :

[F/QUERY1]:
Load *;
Select PseudoMDX D (
Dimensions (
[0CUST_SALES A] ([20CUST_SALES], [50CUST_SALES], [2ZZNAME4], [1ZZNAME4])),
Measures (
[5D0AXOZZELRBUV0N2FM40G5B8].[1TRKY0IQYBVOTCAJN4UDQR81Z]), //Volume
From F/(QUERY1));
Store * from [F/QUERY1] into TEST.QVD;
Drop table [F/QUERY1];

No problem with this step.

My second script to load the QVD file :

LOAD [Client - Hiérarchie standard Niveau 01 (Key)],

     [Client - Hiérarchie standard Niveau 01 (Text)],

     [Client - Hiérarchie standard Niveau 01 - [20CUST_SALES]]],

     [Client - Hiérarchie standard Niveau 01 - [50CUST_SALES]]],

     [Client - Hiérarchie standard Niveau 01 - [2ZZNAME4]]],

     [Client - Hiérarchie standard Niveau 01 - [1ZZNAME4]]],

     VOLUME

FROM

(qvd);

 

When I run this script, I have an error : "From not existing". I see that the character ']' are more manifold that the character '['. But if I delete the character, I have an error too. Why the automatic script is generated with errors ? how to solve ? I can't be alone with this problem...

Thanks in advance.

1 Reply
Not applicable
Author

I have found the solution :

I must translate the automatic code like this :

LOAD

    "Client - Hiérarchie standard Niveau 01 (Key)",

    "Client - Hiérarchie standard Niveau 01 (Text)",

     "Client - Hiérarchie standard Niveau 01 - [20CUST_SALES]",

     "Client - Hiérarchie standard Niveau 01 - [50CUST_SALES]",

     "Client - Hiérarchie standard Niveau 01 - [2ZZNAME4]",

     "Client - Hiérarchie standard Niveau 01 - [1ZZNAME4]",

     VOLUME

FROM

(qvd);