View 1 contains dimensional data such as gender, type of owned an automobile, etc.
View 2 contains measures which require a sum aggregation that can be broken up by date.
So if Thomas was a man who owned a lexus and came into the shop in march, april, and may...
View one would contain a record which specified:
Record Key, Thomas(Column: name), Man(Column: gender), Lexus(Column: automobile)
View two would contain:
Record Key, March(Column: Date), 1 (Column: WorkDone [displayed as a 1 or a 0])
Same Record Key, April(Column: Date), 1 (Column: WorkDone [displayed as a 1 or a 0])
Same Record Key, May(Column: Date), 1 (Column: WorkDone [displayed as a 1 or a 0])
I want my cube to be able to filter on the dimensions such as view_one.gender and view_one.automobile, but also to show the measure of SUM( view_two.WorkDone ) during a certain month.
We could then see how many men who owned Lexus's and got work done in the month of May.