Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(
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
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
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
Quotation marks will do the job, for example:
"Item Type - Item Type Level 01 (Text)"
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
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
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
Thanks Yaniv!!
That worked perfectly!!
Regards,
Magen
Great:) my pleasure
Please mark question as answered