2 Replies Latest reply: Nov 5, 2013 3:20 PM by hyperion_mike91 RSS

    Hyperion Interactive Reporting OCE setup for SAP BW

    hyperion_mike91

      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...

       

      Thanks,

      (point distributor) hyperion_mike91