Skip to Content
0

Generating Connetion Name for EPM Add in to BPC 10.1

Dec 22, 2016 at 11:12 PM

208

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Dec 23, 2016 at 04:19 AM
0

EPM SP21 is old, upgrade is required...

For the rest please explain what do you want to achieve - test case!

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 23, 2016 at 06:29 AM
0

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...

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 27, 2016 at 04:55 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, you mix connection string in VBA and in EPM functions! Different things!

For multiple systems use different names in connection dialog when you create connections!

0