2 Replies Latest reply: Aug 20, 2015 6:17 AM by Simon Hogg RSS

    Cannot use SAP-BW formulas as data source

    Simon Hogg

      I have an SAP BW query which is working quite happily.



          "[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?