Fill values into members of the EPM context pane

[Former Member]

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

[Shrikant_Jadhav · Accepted solution]

Hi Gerd,

Kindly go through the following link may be helpful

Shrikant

[Former Member]

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