How to link an Analysis worbook to an Excel database ?

[former_member644785]

Hello BI experts,

The users would like to know if there is a way to link an analysis workbook to an Excel Database ?

From their Excel database, they'd  like to refresh datas coming  from BO
Thank you in advance for your answer

Regards,

Nicolas

[Former Member]

Hi Nicolas,

If I get you right with "From their Excel database, they'd  like to refresh datas coming  from BO" you want to use characteristic values to insert in the variable prompt of a Bex query included in an AO workbook?

You can do this with VBA functionality, e.g.:

Dim lResult As Long

lResult=Application.Run("SAPSetVariable",
"0BWVC_COUNTRY", "DE", "INPUT_STRING", "DS_1")

Please check the AO help document for all the Details...

Regards, Martin

[TammyPowlas]

I suppose if you store the Analysis Workbook in the same location this could work. Have you tried that?