Skip to Content
avatar image
Former Member

need to change dimension member in context based on the member property


When i select the one particular entity i.e. E_1100 , it having the currency property is INR, this currency has to change  the RPTCURRENCY dimension member i.e. INR. in the context member.

Context is locked for the users.

for example:

In context i have Entity dimension, RPTcurrency dimension

                           E_1100               INR.

In report user having the select parameter for the Entity Dimension. Now he has selected the E_1200  in the report , but it has currency property is USD

now the RPT Currency dimension should have to display the  USD in the Context.

Please anybody help me.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 13, 2015 at 10:54 AM

    Hi Surya,

    As you said when you are selecting entity E_1100 whose property currency is INR so this INR should change the context of RPTCurrency dimension.

    To achieve this, you can filter RPTCurrency based on the property value of Entity dimension (i.e. INR in your example).

    =epmcontextmember(,"RPTCurrency", "ID="&A1)

    where A1 is the cell having the currency property of Entity dimension which you can extract through EPMMemberProperty formula.



    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 05:35 AM

    Hi Surya,

    Kindly close the old thread if quires are resolved.

    How to close a discussion and why and The SCN Rules of Engagement

    About your query I am not sure that whether we can change/ override the context depending on other dimension member selection.

    You can add currency dimension in row axis and use "Dimension property" in edit report member selector. Hide that dimension in template


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Surya,

      You can also use another approach whenever you change the context member (entity) value of the cell A1 gets changed according to property that you have maintained. whenever you change context below vba code will execute and the context member  will changed accordingly automatically.

      You can use AFTER_CONTEXTCHANGE function

      First Enable FPMXLClient references and use below VBA code to change context automatically.

      Dim epm As New FPMXLClient.EPMAddInAutomation


      Dim CONNE As String

      CONNE = epm.GetActiveConnection(ActiveSheet)

      'To set context

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

      End Function

      Use your dimension names.

      Hope this will help you. 😊



  • avatar image
    Former Member
    Apr 14, 2016 at 08:39 AM

    Hi Surya the code that you have posted

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

    works with all version of EPM?

    I'm using EPM 10.0

    setcontextmeber seems that are not present in the API section

    could you advise me a different instructions?

    thanks a lot


    Add comment
    10|10000 characters needed characters exceeded