Question Re: Sorting by date in SAP Analytics Cloud in Technology Q&A

Sorting by date in SAP Analytics Cloud

Former Member — Thu, 15 Jul 2021 14:52:34 GMT

I am struggling with a feature that should be simple and self-explanatory. Sorting - especially sorting by date.

I have a linked widget that shows cost details per posting date for a given WBS or Supplier. The details are correct, but I cannot sort the postings by date - they just appear randomly, which is not accepted by the user base - and there is no real explanation why such a basic thing is not working. Posting date is part of an hierarchy, but in flat representation,

Nothing happens when I sort the Posting Date field Highest to Lowest (or the other way around). All other columns have the default sort order.

I have seen it working at first - but then I needed to add a further column to the table and now the sort is gone. 😞

Does anybody have an explanation here?

Thank you,

Susanne

Re: Sorting by date in SAP Analytics Cloud

JBARLOW — Fri, 16 Jul 2021 10:44:12 GMT

If you set the date dimension in the table to display both ID & Description
Is the sort being applied to the ID?

Re: Sorting by date in SAP Analytics Cloud

Katryn_Cheng — Fri, 23 Jul 2021 21:45:18 GMT

Hi Maria,

How is it "linked"? Is it linked analysis or does the table have a blended model?

Is the Posting Date a Date dimension?

It would be helpful if we could see a screenshot of the behavior (with sensitive data blurred out of course). I am trying to get enough details to test it out on my end.

Re: Sorting by date in SAP Analytics Cloud

former_member837941 — Wed, 25 Jan 2023 16:05:42 GMT

Hi Maria,

Could you check this below link.

Changing Member Order | SAP Help Portal

Thanks,

Saurabh