Skip to Content
avatar image
Former Member

SetContextOptions Example

Hello, I am trying to learn about macros in BPC reports but not able to figure out how to use this. Can someone provide an example?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 20, 2017 at 05:50 AM

    What is the issue?

    Option Explicit
    
    Dim epm As New FPMXLClient.EPMAddInAutomation
    
    Public Sub TestLock()
    
        epm.SetContextOptions ThisWorkbook.Worksheets("Sheet1"), epm.GetActiveConnection(ThisWorkbook.Worksheets("Sheet1")), "TIME", "2017.12", False
    
    End Sub
    Add comment
    10|10000 characters needed characters exceeded

  • Jul 18, 2017 at 06:56 AM

    What do you want to achieve? Please explain a scenario!

    Add comment
    10|10000 characters needed characters exceeded