Insight Enterprise v8.6 has now been shipped to clients. This release contains some major enhancements to experience study functionality by incorporating the Life Year method, commonly used in Europe, and adding dependent joint life studies.
After a short break and cake to celebrate, work commenced on v8.7 which will further enhance Long Term Care Functionality.
A full description of the changes introduced in v.8.6 can be found here.
Insight DBA Shahriar Nikkhah (Nik) is a contributor to the new SQL Server MVP Deep Dives book released this week.
Nik works with SQL Server Integration Services (SSIS) and is one of the leading professionals in this field. SSIS is critical for loading data to Insight Enteprpise and Insight Experience, so it is important that our staff remain at the leading edge of this technology.
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]
This document provides a summary of changes that have taken place between the v8.6 release and the previous release (v8.5).
Joint First and Joint Last rates are calculated for up to 5 lives. Each joint life is modeled as a separate coverage which should have identical status and termination reason group. The Policy Termination study is based on the primary life for calculating exposure, actual and expected. Joint Life attributes (JointLife, JointNumber, JointOrder) have been introduced to facilitate joint analysis. Joint life functionality can be calculated at policy and coverage level if required.