Skip to Content

Generating Connetion Name for EPM Add in to BPC 10.1

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 23, 2016 at 04:19 AM

    EPM SP21 is old, upgrade is required...

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2016 at 06:29 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2016 at 04:55 PM

    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

    Add comment
    10|10000 characters needed 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!