Skip to Content

modifying connection from BW to OLAP

Hi,

I have an existing Analysis for Office workbook whose datasource is connected to BW(using SAPLOGON.INI connection).

Now i want to replace the above connection with existing OLAP connection in BI platform.

Any idea how to replace the connection of the data source from BW to OLAP connection.?

The reason why i need to perform the above task is ,i need to schedule the AFO workbook in BI platform and with BW connection, i am getting error while scheduling.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 13, 2017 at 08:54 AM

    I recommend setting up the OLAP connection in the CMC; your BI administrator should do this. Please see YouTube at https://www.youtube.com/watch?v=s_Jap4WM7Hc&feature=youtu.be

    There is a video at https://archive.sap.com/documents/docs/DOC-20625

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2017 at 07:16 AM

    Hi Tammy,

    The OLAP connection is already created in CMC.

    My question was , how to replace the existing BW connection with OLAP connection in AFO?

    I have a workbook which has a BW connection that has has to be replaced with OLAP connection.

    I have other workbooks which are already connected to OLAP connection.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24, 2017 at 09:44 AM

    Hi Tammy,

    Thank you !

    I was able to change the connection by clicking on the button circled in red below

    Add comment
    10|10000 characters needed characters exceeded