Overlapping week order issue

[Former Member]

Hello Guys,

I am facing one issue, On the X axis which reflect as timeline for me. As Year, Month, Week No - hierarchy. Now when it is about multiple years and the first week of new year is overlapping with last year's last month, that time the order of that week number looks invalid for last month of last year.

Please see below screenshot to get more clarity on what i am referring to.

I want to put that 1st week no at end of last month. How do i resolve this?

Kaustubh

[TammyPowlas · Accepted solution]

Kaustubh - I think you found a bug - I can recreate your situation below - could you please report this to SAP Support and open an incident?

[Former Member · Accepted solution]

Will do. Thanks for confirming.

Kaustubh

[Henry_Banks · Accepted solution]

Hi,

i have tested something very similar for a customer who reported this to support , and it is solved in the forthcoming SP23

in that case, it was a freehand SQL statement, with a Where clause "less than" date 1/1/YYYY.  In the preview and prepare room, it showed CW53 and CW1 (the latter, mistakenly) . 

However, when a time hiearchy was defined on said date column, the display was Ok in the visualise room.

Question - can you workaround the display problem using a time hierarchy enrichmen?

Regards,

H