Skip to Content
0

Help With AddMemberToRowAxis

Jun 19, 2017 at 03:32 PM

59

avatar image
Former Member

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jun 19, 2017 at 05:19 PM
0

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

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Do you have TIME dimension in row axis??

0
Former Member

yes, time dimension is in row axis

error:

capture.png (22.0 kB)
0

I am able to execute exactly same code...

Try simple single report!

0