Qlik Community

QlikView Connectors

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

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

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

1 Solution

Accepted Solutions
yfe
Contributor III

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

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 Replies
jaimeaguilar
Valued Contributor II

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

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

yfe
Contributor III

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

Quotation marks will do the job, for example:

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

Not applicable

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

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

Not applicable

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

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

yfe
Contributor III

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

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

Not applicable

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

Thanks Yaniv!!

That worked perfectly!!

Regards,

Magen

yfe
Contributor III

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

GreatSmiley Happy my pleasure

Please mark question as answered