2 Replies Latest reply on Nov 5, 2013 9:20 PM by hyperion_mike91

    Hyperion Interactive Reporting OCE setup for SAP BW


      Can anyone help me find online a good example or best practices doc for connecting IR to SAP BW datasources.  Then, subsequently the recommended DAS configuration.  If anyone is aware of instructions for this online I would be most greatful...


      I tried the packaged OLE DB provider that comes with IR Studio, then the SAP BW OLE DB Provider.  I can see the SAP logon prompt (so this is working so far!), ID works and I can then a list of SAP BW objects that my ID has access to,  but when I select the Catalog I want to connect to I receive the following error:


      OLE Error: 80040e4d

      Error Source: MdmSap.2

      Error Description: Authorization failed


      With the ID I am able to login in and retrieve data using the BEx tool, Business Explorer - Business Analyzer (Excel Add-in) so the ID has access to the respective catalog.  Suggestions or input would be most appreciated...



      (point distributor) hyperion_mike91