on 09-14-2012 9:38 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.