cross join with master calendar to fill missing dates
Hi,
I am creating a calendar view of some data using the pivot chat. I am fetching year, month, week of month and day of week to provide a calendar like view on some data. I need to show such view for one employee at a time. However, the problem is that not all employees have data for every date. Therefore, the pivot table has many missnig weeks and dates and is only showing data for which the employee has data
In normal circumstances, I could show missing or null values. However, When I select an employee as a filter, we could no longer show data for missing dates
I am thinking about applying a cross join of calendar to every employee. However, I suspect that it will decrease the performance a lot, though I believe it will resolve the problem
I believe that many people might have come across such situations and would like to know your appraoch to resolve this problem. Maybe you have an approach that will be resolve the problem but not at the price of drastic peformance decrease
sometimes there exists an easy way for such problems. You can select chart properties -> dimensions, then select your time dimension (for example year) and check the item "Show all values". So you will see for selected employees always every cardinality of your time dimension.
