topic Re: Cannot use SAP-BW formulas as data source in Connectivity & Data Prep

Cannot use SAP-BW formulas as data source

quriouss — Wed, 19 Aug 2015 13:25:25 GMT

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?

Re: Cannot use SAP-BW formulas as data source

jonathandienst — Wed, 19 Aug 2015 13:28:19 GMT

Should the field be qualified with quotes AND square brackets?

LOAD

[Measures.LongTechnicalName1] as [Net Price],

Re: Cannot use SAP-BW formulas as data source

quriouss — Thu, 20 Aug 2015 10:17:32 GMT

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