Search results for query: *

Thanks. Well I dont know what the user response will be after I roll out reports written on top of this datamart. At this time, all I am doing is conceptually looking ahead on what they may want to report on and at the same time, keeping in mind the volume. Hope the above plan proves to be good.

John I went ahead and implemented a small change to the claim accumulating snapshot. I removed child level measures from the above snapshot so that this table will only hold all claim centric financial numbers for every claim everyday. The above measures are also reported granular level of...

John I may need some additional clarification regarding claim accumulating snapshot. In my current design, I do not include Claim Status in the claim dimension. Instead, my accumulating snapshot has all the details of the claim including current status, when opened, closed, all current...

John, I an in te process of creating the accumulating snapshot for claim that contains several claim relasted business metrics such as Gross, Incurred and Net Reserves etc. Some are at claimant level and some are at claim lever. In creating the snapshot, do we need to create a dimention with...

Hi John In the same context, events within the check processing such as INVOICE_DATE,PAYMENT_STOPPED_DATE, CHECK_VOIDED_DATE, PROCESS_DATE etc..these dates can be included in the fact table and filled in depending on Context of the transaction. I could create a payment transaction type with...

Hi Thanks again. I am beginning to like the methodology. We recently implented a system for policy handling (without claims portion) and I think this approach will be a lot better than that. If I am going to create RECEIPT, PAYMENT, RESERVE AND SALVAGE dimensions, wont the rowid of these...

Hello Thanks for your response. I plan to check the retention time requirement from the business. If I understand this correctly, the Transaction Type Dim is essentially a VAL TABLE (Lookup Table sortof) which lists the possible transactions types that can happen with regards to a claim. So it...

Folks Reading up on Kimball DW Toolkit and I am trying to understand the part where he suggests the methodology for Claims Processing: Businss Process is Claims Transactions with three fact tables, Claim Transactions, Claim Accumulating Snapshot, and Accident Event. The dimensions are the same...