Skip to Content
avatar image
Former Member

Fill values into members of the EPM context pane

Hi, all,

is it possible to fill values into members of the EPM context pane from the inside of an excel sheet? In this excel sheet there should be an dropdown box.

How could this be achieved?

Thanks in advance and best regards

Gerd

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 09, 2015 at 06:15 PM

    Hi Gerd,

    Kindly go through the following link may be helpful

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2015 at 06:22 PM

    Hi Gerd,

    Yes it is possible you can set context member using VBA.

    You can use VBA for that use below code. just useĀ  drop down cell reference instead of (A1) and use you dimension names.

    Need Manual trigger

    Dim epm As New FPMXLClient.EPMAddInAutomation

    Sub change context()

    Dim CONNE As String

    CONNE = epm.GetActiveConnection(ActiveSheet)

    'To set context

    epm.SetContextMember CONNE, "CURRENCY", Range("A1")

    'To refresh

    epm.RefreshActiveWorkBook

    End Sub



    on context change (automatically)


    Dim epm As New FPMXLClient.EPMAddInAutomation

    Function AFTER_CONTEXTCHANGE()

    Dim CONNE As String

    CONNE = epm.GetActiveConnection(ActiveSheet)

    'To set context

    epm.SetContextMember CONNE, "CURRENCY", Range("A1")

    End Function



    Regards,

    sushant



    Add comment
    10|10000 characters needed characters exceeded