Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
please correct my code to store into QVD
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);
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);
i got exactly the same error, check attached
Note: am pulling data from SQL analysis server
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
Hello Jo,
My code runs perfectly but brings out saving to QVD error
Thanks very much. Can you post all the script code including the store command ?