Skip to Content
avatar image
Former Member

Help With AddMemberToRowAxis

I am getting an automation error when using AddMembertoRowAxis API in EPM 10. I'm wondering if there is an issue with my syntax. The very similar SetContextMember works without a hitch. The reportID is the same as found Report Name in Report Editor screen correct?

Sub add_member_row()
Dim epm As New EPMAddInAutomation    
epm.AddMemberToRowAxis ActiveSheet, "003", "TIME:2017.JUN", 1
epm.RefreshActiveReport
End Sub

Sub change_context()
Dim epm As New EPMAddInAutomation
epm.SetContextMember epm.GetActiveConnection(ActiveSheet), "TIME", 
"2017.JUN"
End Sub
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 19, 2017 at 05:19 PM

    "I am getting an automation error" - screenshot, please!

    I have no issues with the same code with correct report...

    Add comment
    10|10000 characters needed characters exceeded