cancel
Showing results for 
Search instead for 
Did you mean: 

EPMLink functionality

tim_atkins
Participant
0 Kudos

Hi Everyone,

I have been trying to get the EPMLink funcion working. I have install EPM-Addin_40NET SP12 Patch 4. (this was supposed to fix certain things in it.) However, when I create it in a simple workbook. =EPMLink("DEV - Finance - BPC","SCENARIO_ANALYSIS.xlsx","Test Report") I get the following error:

Workbook does not exist: C:\Documents and Settings\Administrator\My Documents\PC_NW\Administrator\AppInfo\BPC\FINANCE\eEXCEL\Reports\Wizard\SCENARIO_ANALYSIS.xlsx

What I need to know is can the EPMLink funciton open a spreadsheet on the server (looks like it can't). Why does it open it from Reports\wizard folder?

Note 1754437 suggests there is a new funciont in SP12 patch 4, I can;t find that there. It also suggests you can open files from the server. This doesn not seem to be the case.

Does anyone have any other info on this functionality. The old EvHot funciton was frustrating that it could not open files from the server. I was really hoping that this had been resolved.

thanks so much.

Tim

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello Tim,

Try the EPMExecuteApi function instead (used to be EVMNU):

=EPMExecuteApi("OpenSpecificDocument","Test report","REPORTS\SCENARIO_ANALYSIS.xlsx","Company")

This should do the trick.

Hope this helps,

Eric

Message was edited by: Eric Hammer You also need to activate the "FPMXLclient" reference in the VBA editor, otherwise the function will fail to execute.

tim_atkins
Participant
0 Kudos

Hi Eric,

Thanks for the reply, That seems to work fine. The only question I have is can you specific what current view the report must open? i.e. user must click on a link for a profit centre, and the report must open off the server and the current view switched to that profit centre (or any other dimension member I need.)

thanks again

Tim

0 Kudos

Hi Tim,

I don't think this particular API handles the context.

There is another API that does (SetContextMembers).

Maybe by combining these two API you will reach the result you are looking for?

Best regards,

Eric

tim_atkins
Participant
0 Kudos

Hi Again,

So It seems to be working. the path needs to be REPORTS\xytx.xlsx etc. if it isn;t that, then it will look (it seems) at the local drive.
many thanks Eric

0 Kudos

Tim,

By curiosity, which function did work out with the context, the API or the EPMlink?

Best regards,

Eric

tim_atkins
Participant
0 Kudos

Hi Eric,

Sorry, got distracted. I got the EPMLink function working. (so I can opena report and set current view). The SP12 patch 4 EPM addin seemed to work, but I found that if the directory was not the same as the server, it defaulted to the local desktop. There is a new funciton called EPMLinkPath, but I am not sure exactly the differece.

Tim

Answers (0)