Insurance Claim Model

View previous topic View next topic Go down

Insurance Claim Model

Post  PugMaster on Thu Aug 04, 2011 4:03 pm

Hi

I have a Claims fact table that contains the total claim value paid with a time dimension based on the date the claim was first raised. This works fine but a claim can be ongoing and span over more than one year with many payments being made. The business want to know how much is paid each year(and drill down to quarter/month product etc) on claims regardless of the year the claim was first raised we do keep the payment date and amount paid in the source database but this is obviously in a different context and grain to the Claim facts we already have. is it acceptable to have another fact table more granular to the first but related by the claim surrogate key from the original fact table or is there a better way to build this?

If i do it this way i also need to build a cube but if i roll up the payments it will sum the total claim paid by the number of payments made in the 2nd fact table?

Hope i have explained this well enough for someone to be able to assist.

Kind Regards
Paul

PugMaster

Posts : 21
Join date : 2010-07-07

View user profile

Back to top Go down

Re: Insurance Claim Model

Post  rob.hawken on Thu Aug 04, 2011 5:04 pm

Nothing wrong with that approach at all, 1st can be considered a Claims Summary Fact and the 2nd Claims Payment Fact.

rob.hawken

Posts : 13
Join date : 2010-09-19

View user profile

Back to top Go down

Re: Insurance Claim Model

Post  Dave Jermy on Mon Aug 08, 2011 5:51 am

Absolutely! Having a claim payment fact table allows you to look at the payment data at its most granular level. With it, you could answer questions like "How long does it take for us to set a reserve/make first payment/make final payment?"

Dave Jermy

Posts : 33
Join date : 2011-03-24
Location : London, UK

View user profile

Back to top Go down

Re: Insurance Claim Model

Post  nash on Wed Aug 10, 2011 9:05 pm

As long as you are not joining the two fact tables (and are using conformed dimensions to do so), it should be fine.

nash

Posts : 18
Join date : 2010-03-12

View user profile

Back to top Go down

Re: Insurance Claim Model

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum