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.

       

      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?