Can anyone tell me their experience when dealing with multiple dates, from multiple tables where each table isn't joined at a row level?
Each table represents a different tab that the user sees so the dates are not linked in any way but most of the other selectors/filters are. For now, I have a calendar in a floating table, not connected to the rest of the application and link to corresponding dates of each tab using set analysis (i.e. Sum({<Year_Month_Table_Date_1 = P(YearMonth)>} NumValue).
This works but it does mean that I can't use simple filters for users to select, they all have to be Only({<Year_Month_Table_Date_1 = P(YearMonth)>} Selector).
Each table is linked using each user's personal data (no unique row ID that ties everything together). Can anyone suggest a way to create a single master calendar that I can connect to my fact table?
