on 2017 Dec 01 8:22 AM
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?
Request clarification before answering.
Easy:
GetRowAxisMembers
Then:
RemoveMemberFromRowAxis
P.S. But there are number of limitations of this method.
Please describe your requirements and provide a sample report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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?
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.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.