Hi,
I have multiple fact tables, which don't always have the same granularity of data. Some will give me data by day, some by week.
I have a dimension table with all dates, and all my factTables by days are linked to it.
To handle facts by week, I've created another DimDate with only Year|WeekNumber and a unique value called "YearWeek" which I related to the same value on my primary DimDate.
On all my dashboards, users can't go any deeper than the week. Therefore my slicers allow to slice on weeks, but because some tables have to be filtered using the DimDate>Week and some other by DimDateWeek>Week it's not efficient.
Is there a nice way to handle such an issue? For sure I'm not the first to have this issues but I haven't found any relevant answer yet to my problem.
Thanks!
I have multiple fact tables, which don't always have the same granularity of data. Some will give me data by day, some by week.
I have a dimension table with all dates, and all my factTables by days are linked to it.
To handle facts by week, I've created another DimDate with only Year|WeekNumber and a unique value called "YearWeek" which I related to the same value on my primary DimDate.
On all my dashboards, users can't go any deeper than the week. Therefore my slicers allow to slice on weeks, but because some tables have to be filtered using the DimDate>Week and some other by DimDateWeek>Week it's not efficient.
Is there a nice way to handle such an issue? For sure I'm not the first to have this issues but I haven't found any relevant answer yet to my problem.
Thanks!
