How to use the ".rankBy()" and ".sortByValue" in the analytics designer

[sanpe]

Dear experts,

can someone please explain me how to use the two functionalities ".rankBy()" and ".sortByValue" on a chart/table?

I'm trying to figure it out, but somehow it doesn't want to work on my chart (live HANA connection).

Chart_1.sortByValue("MyMeasureID",SortOrder.Descending);

Chart_1.rankBy("NotSureWhatToPutHere");

I guess these are quite new functionalities and it seems they are not yet included in the new edition of the Developer handbook.

Thanks.

BR

Peter

[avsalynin · Accepted solution]

sanpe

link

tenants' fast track will probably be available earlier than at the end of the year;)

[rk25350]

Please follow the below for rankBy..

Chart_1.rankBy({

rankOrder:RankOrder.Top,

structureMember:"structure based on which rank will be done",

value:5});

}

[avsalynin]

sanpe

based on what's noted here this will only work in optimized mode:

but for analytical applications this mode is not yet available (there is only for stories), so we expect it in the next releases of this year

p.s. added Api outstripped optimization mode:)

[sanpe]

Hi Aleksey,

yep, I was searching for the optimized format option in the settings and indeed couldn't find it.

In any case it's interesting, that these are are already available in the menu, but not yet functional...

[JBARLOW]

Rankby etc works with Charts - but only if your Analytic App is set to use Optimised view mode at runtime.

However as always with SAP 🙂 there's a downside........ An App using optimised view mode against a live BW connection won't render charts (amongst other things)

Bug or To be implemented feature....... or misaligned product dev teams..................