I have a problem with my data model, and i'll be very happy to get ideas for a solution.
My module contains two main fact tables, "Finance Data" and "Sales Data".
The Finance table contains finance information like p&l, trial balance accounts etc,
and the Sales table contains the sales transaction in detail (including sales person, customer etc.)
The only connection between those tables is the Date, since i want that selecting a specific period on the module should give the results of both tables (Sales and Finance) for that period.
My problem begins when the user selects one of the unique dimensions of the fact tables:
For eaxmple, he selected Sales Person "David". Now, david worked only at january 2013, so the Finance table will also be affected and display only the data of january 2013. even though he do not want to filter by date at all.
You can concatenate a both tables and create a common calendar you can get a same period when selecting a calendar and another one is do you wnat to show finance data according to sales man......?,
if don t want you show above one model is use full for you.
other wise please provide a test data and explination on data.
