cancel
Showing results for 
Search instead for 
Did you mean: 

Generating Connetion Name for EPM Add in to BPC 10.1

0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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 Kudos

Hi bhawick_jalali,

Were you able to get the solution for your issue? Even i'm stuck with the same issue.

former_member186338
Active Contributor
0 Kudos
jeevan.vasudevan

Please ask a new question! It's a bad idea to comment on 5 year old post.

former_member186338
Active Contributor
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

EPM SP21 is old, upgrade is required...

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