Designing a Clinical Data Mart (Part 2) - Clinical Multidimensional Cube
In this session we will approach creating an Analysis Services cube for our previously designed Clinical Data Mart (CDM). The cube will allow for us to query against patient encounter measures, based on date range and related dimensional filtering. We will show how to implement Many-to Many relationship type for the Diagnosis and Procedure dimensions.
Tags: design