Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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