Skip to Content
0
Jun 30, 2022 at 05:14 AM

DWC - Time Dimension Hierarchy for Calculated Dates

293 Views

Hi,

I am trying to create a Time dimension hierarchy using SAP.TIME.VIEW_DIMENSION_DAY, which is working fine when I am associating it with a single date column.

My model has multiple calculated dates in it.

So, I have tried doing this, but am not sure if its correct.

image.png

image.png

How do I define hierarchy for all the date?

Would be grateful if anybody can help me with this.

Thanks in Advance.

Attachments

image.png (18.0 kB)
image.png (11.6 kB)