Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
quriouss
Creator III
Creator III

Cannot use SAP-BW formulas as data source

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?

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Should the field be qualified with quotes AND square brackets?

     LOAD

     [Measures.LongTechnicalName1] as [Net Price],

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
quriouss
Creator III
Creator III
Author

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