Integration AFO with SAP Disclosure Management

[Felipe_Barbosa]

Hello guys,

I am integrating AFO with SAP DM to load data from SAP GR. 

I understand that this AFO will be written locally with the datacache (excel file), however it is currently pointing to development. How do I change this connection when I send the transport from development to production?

I found this note that shows how to change it, but would I have to do it manually on each AFO. If I have 300 AFOs in datacache, will I need to manually adjust each one? Is there no option to do it in mass? 

2448743 - How to replace the system of an existing Analysis Office workbook

https://me.sap.com/notes/2448743/E

Would this be different if I used queries? Since it would be pointing to a connection created in SAP DM and then I can change it in mass via change datalink.

Tks,

Felipe B.

SAP Disclosure Management 

@Marc_Kuipers , @Olga_Vasileva , @guido_nachtigall 

[guido_nachtigall]

Hi Felipe,

DM does not have direct access to AFO files.
I also do not know how to change the connection automatically (per macro?).
You should ask about this in the AFO forum.

Kind regards,

Guido