cancel
Showing results for 
Search instead for 
Did you mean: 

Help With AddMemberToRowAxis

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

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

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

former_member186338
Active Contributor
0 Kudos

Do you have TIME dimension in row axis??

Former Member
0 Kudos

yes, time dimension is in row axis

error:

former_member186338
Active Contributor
0 Kudos

I am able to execute exactly same code...

Try simple single report!