Sort data in Embedded Analytics Report

[former_member773632]

Hi All,

I have created an Embedded Analytics report and need to sort the final output records based on certain fields. When i execute my consumption view in RSRT Tcode it is observed that all dimension fields are coming in Ascending order. I need certain fields to be sorted and not all the fields. So I implemented AMDP Class with Order by statement and output is coming correctly when executed in Eclipse. But when the view is executed in RSRT and also in Fiori screen, all the fields are coming in Ascending order instead of the Order by fields.

Can anyone suggest any annotation or configuration in RSRT or Fiori to sort final records in Embedded Analytics Report.

issue.png

Thanks in Advance

Regards,

Jibin Thomas

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[guna91]

Can you try using @AnalyticsDetails.query.sortDirection with #ASC, #DESC annotation on respective fields.

[former_member773632]

HI guna91,

If i use this annotation then we have to implement BW query on top of it to make the sort work. I need directly in RSRT tcode.