• 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.