The Quest for the Holy Grail: OLAP Approaches for Calculating Actuarial Measures

At Highmark Inc. Online Analytical Processing (OLAP) is used to provide access to large amounts of data stored in Highmark's data storage system, the "Enterprise Data Warehouse." A common actuarial metric is the calculation of Per Member Per Month cost, or PMPM. The numerator in this ratio is total claims cost in dollars. The denominator is total members enrolled, including members who have no claim costs and are not represented in the numerator. This metric is a challenge in standard OLAP reporting tools because the numerator and denominator represent different populations at different levels of summation.

Provided by: Highmark Topic: Big Data Date Added: Mar 2010 Format: PDF

Download Now

Find By Topic