Thought Media No Comments

The screen shot below is a simple example of MDX code in our calculation editor.

Here we are calculating the ratio of Actual to Expected claims calculated weighted by benefit to the Actual to Expected claims weighted by benefit.

i.e. [measures].[A/E Exits by Benefit]/ [measures].[A/E Exits by Count]

A ratio greater than 1 means that the A/E ratio weighted by benefit is greater than that weighted by count and so the policies with larger benefit amount have a higher (worse) A/E ratio than those with a lower A/E ratio. In this example we have called it benefit skew and used an arrow icon in the display settings to illustrate the direction of the skew (we could have used any of the icons available in Excel or shown the actual ratio).

The point of this is not how useful this metric is, if we felt it was universally applicable we would have included it as a standard metric. It is intended to illustrate how easily MDX code can be used to develop non-standard metrics and through the Insight calculated measure functionality make these available to all users.

Leave a Reply