Patent ID: 8626790

Claim:
A method of operating a computer system to generate reports from stored insurance data, the method comprising: operating a processor to interact with an insurance data warehouse including at least one data storage hardware unit storing insurance data according to a schema in which each of a plurality of dimension tables is associated with a fact table containing information regarding insurance policies, wherein the plurality of dimension tables include an insurance agency dimension table, an insurance master agent dimension table, an insurance policy holder dimension table, and an insurance policy dimension table; operating the processor to combine a first row of one of said dimension tables with a second row of the one of said dimension tables to produce a combined row in a non-persistent history restatement view, the combined row including a row identification key for the first row and a row identification key for the second row, the row identification key for the first row joining the combined row to fact data from a prior time period, the second row corresponding to a current time period that is later than the prior time period; and operating the processor to join at least a portion of the combined row to at least a portion of a corresponding row in a fact table associated with the one of said dimension tables, said fact data from said prior time period included in said corresponding row in said fact table, wherein the history restatement view automatically uses a current value of an attribute for a given entity to replace a previous value for the given entity and includes a query view row entry that includes said current value of the attribute of the given entity and a previous fact value for the given entity where the given entity had at least one prior value of the attribute different than said current value.