I'm new to SSAS.
I have dimensions: [Customer], [Date], [Group] (group is a dimension I use that allows me to group customers into predefined categories like frequency) and facts: [Daily Spend], [Monthly Spend Snapshot].
The monthly snapshot fact table I use mainly to hold the measures I use to rate the customer into categories defined in the [Group] dimension.
I don't understand how to relate the monthly snapshot fact table back to the daily spend fact table so I can display daily spend metrics.
I'll try to illustrate below:
[Monthly Spend Snapshot]