I have 3 Tables
as shown in image. There are three tables.
User Details is master table having all user information
Login details shows users who have logged in which also consist of dates.
Master calendar consist of all the dates between min and max date.
When i put section access based on a column. Which connect my User Details Table. It also reduces my date.
So from UI i only get those months for which i have data.Else it doesn't show..
Can any one help me on this?
i have used strict exclusion and reduce data also.
If you want to avoid this type of reduction, add dummy recordsto Login_Details that tie every reduction field value to every month in your calendar. A flag or another smart choice will eliminate those records from your UI.
What field is used for reducing data based on user account?
section access is being applied on "section access team lead" and for those team leads "authenticated users" field is getting filtered followed by date. We tried creating an outer join between the master calendar and Login details creating all the dates in the table thus created but it dint help. Do you think we need to change our data model to get the solution. If yes then how?
No, I don't think you should change your data model.
What you can do is add dummy records to your Login_Details table with all possible combinations of Authenticated User and [Day of the month] that are not already there. Those records will block the reduction of certain months that had no real Logins from particular users.
If you do want to change your data model (it may be fun to try something new), you could create a link table between User_Details and Login_Details that translates an Authenticated User into a key composed of Authenticated User and Date. Depending on your data range and number of users, this may become a large but highly compressible table. It should contain all possible user/date combinations, not just the ones that occur in Login_Details. Then attach your calendar to the same table.
BTW if you do not need single date granularity in your calendar (only weekly or monthly reports), you can reduce your calendar to a week/month/year list. Keep the real dates in Login_Details however.
Oh and BTW: be careful with that big "Correct" button on each post. I do get 10 points that I don't deserve every time your press that button. Even if you remove the "Correct" marking afterwards. Better wait until you're really sure about the correct answer.