Syntax Error - Loading PseudoMDX from a QVD - SAP OLAP Connector

[#1]

Hi

My Query using the SAP OLAP Connector is the following:

[NP_M09/QNP_M09_001_REV]:
Load *;
Select PseudoMDX D (
Dimensions (
[0ME_ITEMNO] () ,
[0ME_ITEMTYP] () ,
[0ME_ITEM_CA] () ,
[0ME_ITEM_NO] () ),
Variables (
[0TYEAR] (I [0CALMONTH].[201409]:[0CALMONTH].[201409])),
From (NP_M09/QNP_M09_001_REV));
Store * from [NP_M09/QNP_M09_001_REV] into NP_M09-QNP_M09_001_REV.QVD;

This works fine, but when I store the data into a QVD and load the table back into my application I get the following:

LOAD

   [[0ME_ITEMNO]] - Item Number Level 01 (Key)],
[[0ME_ITEMNO]] - Item Number Level 01 (Text)],
[Item Type - Item Type Level 01 (Key)],
[Item Type - Item Type Level 01 (Text)],
[Item Category - Item Category Level 01 (Key)],
[Item Category - Item Category Level 01 (Text)],
[[0ME_ITEM_NO]] - Item Number Level 01 (Key)],
[[0ME_ITEM_NO]] - Item Number Level 01 (Text)]

FROM

(qvd);

I receive an error on lines 1, 2, 7 and 8. This is due to the extra square brackets created when loading the data from a QVD.

I’ve tried manually removing/adding square brackets for example:

LOAD [[0ME_ITEMNO] - Item Number Level 01 (Key)],
[[0ME_ITEMNO] - Item Number Level 01 (Text)],
[Item Type - Item Type Level 01 (Key)],
[Item Type - Item Type Level 01 (Text)],
[Item Category - Item Category Level 01 (Key)],
[Item Category - Item Category Level 01 (Text)],
[[0ME_ITEM_NO] - Item Number Level 01 (Key)],
[[0ME_ITEM_NO] - Item Number Level 01 (Text)]
FROM
[D:\QVDev\Newspapers\Magen.Vadivelu\News_BI\AdsData - SAPBW\NP_M09-QNP_M09_001_REV.QVD]
(qvd);

But this just causes the whole line to error.

Please assist – Any help would be appreciated.

Regards,

Magen

[jaimeaguilar]

Hi,

Have you tried

Load *

FROM
[D:\QVDev\Newspapers\Magen.Vadivelu\News_BI\AdsData - SAPBW\NP_M09-QNP_M09_001_REV.QVD]
(qvd);

I think it should work in this case

regards

[Anonymous]

Quotation marks will do the job, for example:

"Item Type - Item Type Level 01 (Text)"

[#4]

Hi Yaniv

I tried that but it gives me the error - "Field not found -  [[0ME_ITEMNO]] - Item Number Level 01 (Key)]".

Any other possible solutions?

Regards,

Magen

[#5]

Hi Jaime

Thanks, ive tried that and it works, BUT i need to join this table to another table,

hence i need to script the name of the field.

Regards,

Magen

[Anonymous · Accepted solution]

Please notice the small difference -

Here's what you need to type:

"[0ME_ITEMNO] - Item Number Level 01 (Key)"

(a pair of square brackets only for the InfoObject technical name)

In order to understand clearly which name was given to each field, I suggest that you load once all the fields from the QVD (load * from ZZZZZ.qvd) and display a list box for each field - you will be able to see it's full name in the Caption Tab (in the list box properties)

Yaniv

[#7]

Thanks Yaniv!!

That worked perfectly!!

Regards,

Magen

[Anonymous]

Great:) my pleasure

Please mark question as answered