Sort items in table by measure using SAC live connection to SAP HANA cloud

[former_member572650]

Hello,

We have created a calculation view in SAP HANA cloud that uses the hierarchy function to get the order of items in the view. We have set up a live connection in SAC (US region) to HANA cloud and then we create a story with a table using the sort order metric:

The result: Works as expected

But using the same calculation view in SAC tenants located in Saudi Arabia and Europe doesn't work. The view is fetching the data with the correct order, but SAC can't sort it in ascending or descending order correctly:

I hope team you have some clue to solve it.

Thanks!