on 2017 Apr 13 8:36 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tammy,
I have an existing AFO workbook, wherein the connection is via SAPGUI and its already saved.
When i try to refresh the workbook, it asks for the SAPGUI credentials
Now i want to replace this with an OLAP connection in the AFO workbook.
I donot find any option to replace the connection for existing data source.I can add a new data source connected to OLAP in the existing workbook.
After replacing with OLAP , it should ask for the below credentials (web service URL).
Hope you are clear now
Hi - have you tried this option, discussed in this thread? See https://archive.sap.com/discussions/thread/3473915
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
10 | |
9 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.