Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Problem with QvSAPOLAPConnector

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);