on 02-20-2014 5:58 PM
Hello Experts,
Is there any way to sort transactional data in a BPC report?
We are doing it with a VBA code but it's rewriting report definitions.
Regards,
Nadine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nadine,
Please, read help in this document http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf
Especially - 16.2 Data Sorting, Ranking and Filtering
B.R. Vadim
P.S. It's under "Actions and Options Specific to the Current Report"
Hello Vadim,
What I need is not sorting members, its sorting a value that is in a combination of members.
I think this sorting that I get with report definition sorting functionality is just sorting members and not the "signedata" that cames from the cube.
Please, read help once more!
It's exactly about values sorting!
Vadim
Your requirements are not clear!
Please describe the sorting logic! Looking on the 2 desired lines it's hard to understand the idea...
Also look at this option "7. To perform the sort in each level of the hierarchy, select the Sort Inside Level option."
Many thanks Vadim!!
We tested and it works fine!!
Good news
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.