SAP BPC 10 how to set members from array to row axis in report using API

[former_member440277]

HI experts!

is anybody knows how to set members from array to row axis in report using API? i know that is not best practice, but in current project it may be best solution then current. i found members AddMemberToRowAxis and RemoveMemberFromRowAxis of class EPMAddInAutomation. but there's impossible to delete all members from row axis before additing new members. although for sure there is, but I don't know how.

or is there a way to recognize members for row axis using the API?

[former_member186338 · Accepted solution]

Easy:

GetRowAxisMembers

Then:

RemoveMemberFromRowAxis

P.S. But there are number of limitations of this method.

Please describe your requirements and provide a sample report.

[former_member440277 · Accepted solution]

Thanke you for your answer, but there is no need to get members from the row axis. we already have array of members, which have to put to row axis. Like function EPMDimensionOverride, but for more then one dimension in row axis.

[former_member186338 · Accepted solution]

Then I do not understand your question!

If you know members in Row axis you can delete members using RemoveMemberFromRowAxis

The last member can't be deleted. You have to insert new member then delete the last member.

Another option is to enable Member recognition and insert members in cells.

[former_member440277 · Accepted solution]

Yes, the last member can`t be deleted and i thought, that there is a different way to additing override row axis. i still trying to delet members befor additing new, but i have error "Can not remove all members of a row axis". it may be the result of duplicated members in axis. befor deleting members i get array by GetRowAxisMembers and then remove their form axis by name.

and second quastion: how to enable Member recognition by API after inserting members to cells?

[former_member186338 · Accepted solution]

What is the first question?

"how to enable Member recognition by API after inserting members to cells?" - you have to enable member recognition before Member insert!

[former_member186338 · Accepted solution]

P.S. Can you explain the business requirements? Why do you need to generate axis in VBA????

[former_member440277 · Accepted solution]

Yes, "Activate Member Recognition" in Sheet Options, that's what I needed!

Thank you very much, Vadim.

[former_member186338 · Accepted solution]

Yes:

epm.SetSheetOption(ThisWorkbook.Worksheets("Sheet1"), 2, True)

[former_member440277 · Accepted solution]

we need two dimensions in row axis. the members of one of these dimensions linked to another "one to many". and it may be implemented using Selection Relationship: Dimension Property. but this way you can't add not linked members to second (another) dimension in row axis.

now i can create report in hidden sheet with linked members in axis. get them into array and then fill another array with members from first array and unlinked members.

members of second array will be row axis in report in visible sheet.

[former_member186338 · Accepted solution]

May be you can use 2 reports with shared page and column axis.

First report will be with the relationship by property and the second - to insert lines.