Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an SAP BW query which is working quite happily.
Load
"[Measures].[LongTechnicalName1]" as "Net Price",
"[Measures].[LongTechnicalName2]" as "Tax Amount"
...
But if I want "Total Amount" and create the formula in SAP-BW, the load script fails on;
"[Measures].[LongTechnicalName3]" as "Total Amount",
This is using the in-built SAP-BW OLE DB connector. Is there a restriction on importing formulas from SAP? Other MDX tools I have work fine with the query.
Any ideas/documentation?
Should the field be qualified with quotes AND square brackets?
LOAD
[Measures.LongTechnicalName1] as [Net Price],
No, I don't think that is the problem - my current method works quite happily for any Key Figures in BW, but it will just refuse to import any Formulas defined in BW