I have a problem that has haunted me for a long time, it´s time to get it solved!
I have a database with customers and their engagements; an engagement is for example one insurance.
Each customer can have one or more engagements of different types and status.
Like this (simplified):
Now I want to design a FactTable “FactEngagement” that aggregates the PaidAmount with DateID, CountryID, TypeEngagementID
and StatusEngagementID as dimensions. In addition to the measure PaidAmount I want to know the number of Engagements and the number of Customers having those Engagements.
FactEngagement will look like this.
It should answer questions like:
How many active (status 1) engagements of type 1 do we have for January 2010?
How many Customers have active engagement
View Complete Post