please am having problem storing to qvd

[#1]

hello,

please correct my code to store into QVD

[JonnyPoole · Accepted solution]

Provide a title to the table that you want to store immediately preceding the LOAD line as follows;

ex:

replace:

LOAD

  "[Measures].[Aggregate Price  Commercial_planned]" as [Aggregate Price  Commercial_planned],

with

GasAndPower:

LOAD

  "[Measures].[Aggregate Price  Commercial_planned]" as [Aggregate Price  Commercial_planned],

------

then alter the syntax of your store command to this:

Store GasAndPower into GasAndPower.qvd (qvd);

[#3]

i got exactly the same error, check attached

[#4]

Note: am pulling data from SQL analysis server

[JonnyPoole]

If you remove the STORE command does your script work  ?

I also noticed you have a trailing ',' in the last line of your load which would normally cause an error.  Perhaps your table is not getting loaded and the real error is the load/SQL.  Can you check that ?

"[NGC Projects].[NGC Projects].[NGC Projects].[MEMBER_CAPTION]" as [NGC Projects],

SELECT

[#6]

Hello Jo,

My code runs perfectly but brings out saving to QVD error

[JonnyPoole]

Thanks very much.  Can you post all the script code including the store command ?