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.
