Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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