Problem with QvSAPOLAPConnector

Tue, 04 Sep 2012 08:26:33 GMT

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.

Re: Problem with QvSAPOLAPConnector

Mon, 24 Sep 2012 11:57:07 GMT

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

topic Problem with QvSAPOLAPConnector in QlikView

Problem with QvSAPOLAPConnector

Re: Problem with QvSAPOLAPConnector