Home Forums Data Warehousing Integration Services Design Troubles - Patient Contacts Details to be displayed as Measure RE: Design Troubles - Patient Contacts Details to be displayed as Measure

  • You would definitely want to use SCD Type 2 for the contact info. I would personally never attempt to use these as measures, they are completely non-additive, and not even in the 'normal' sense of non-additive. 🙂 You should be able to use these as properties, basically attributes that are related to other attribute dimensions but not displayed/available to the end user, other than when hovering over the current attribute value (in say Excel or even PerfPoint).

    Ignoring the fact that you 'can' do the hover for the info, as your primary requirement is a report showing the contact info/details 'as-at' the Admissions date, I think what you have is more of a TSQL problem than a cube or even data warehousing one. As long as you're storing the contact info in a SCD II, then you should be able to hook it to your admissions data and produce the required report.

    Steve.