on 12-22-2016 11:12 PM
Hi Experts,
I am trying to generate the connection name for EPM functions in excel. I validated the connection name with VB code GetActiveConnection, its similar but still it gives me Error - "#Error, no current connection". Is there any change in the connection name in 10.1 ?
VBA Output -
_FPM_BPCNW10_[epmserver]_[environment]_[model]_[false]_[false]
Excel Cell
_FPM_BPCNW10_[epmserver]_[environment]_[model]
Trying to use the Connection Name in EPMDimensionList but it gives me same error.
EPM Add in Pack 21
BPC 10.1 SP 10
Regards
Bhawick
Hi Vadim,
In the landscape we have multiple systems so the Connection Name can't be same across the business users, so i am trying to look into the option of generating the connection name similar to VB API so that i dont have to rely on the local connection names.
I read it in some of your posts that _FPM_BPCNW10* is an option to do it. Let me know if i am missing anything here.
Regards
Bhawick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
P.S. If you want to specify the connection name in EPM Excel formula - just use the connection name defined in the connections dialog.
For example I have a connection to environment SIM, model INFILE. The connection name is:
"INFILE - SIM"
Formula will be:
=EPMDimensionType("INFILE - SIM","A")
For VBA connection string is different...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
EPM SP21 is old, upgrade is required...
For the rest please explain what do you want to achieve - test case!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.