COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: nfldbunker on 27 Jul 2009 07:37:12 PM

Title: medical modeling and cognos
Post by: nfldbunker on 27 Jul 2009 07:37:12 PM
hi

Anyone used cognos to model healthcare data and produce cubes and or reporting data. Any issues and or concerns, tips or suggestions.

greatly appreciated

Title: Re: medical modeling and cognos
Post by: redmist on 28 Jul 2009 08:21:15 AM
I'm assuming by healthcare data, you mean data provided by some external vendor.
If the data consistency and and quality issues are taken care of by the ETL team, the issue that remains will be performance in both cube build time and access time.
you might have to consider splitting cubes or creating cube groups depending on the amount of data and performance.
Title: Re: medical modeling and cognos
Post by: twlarsen on 28 Jul 2009 10:32:54 AM
I support Cognos for a group of outpatient clinics, so I model healthcare data for cubes and reports.

Just like any other industry, you need to understand your business process, and what they need from reporting.

Do you have any specific questions? 

As far as using Cognos for healthcare data, if you've done your homework with your data, you shouldn't have any major issues.
Title: Re: medical modeling and cognos
Post by: nfldbunker on 08 Sep 2009 07:04:32 PM
hi

have you ever modeled 3m coding and abstracting data?
Title: Re: medical modeling and cognos
Post by: twlarsen on 10 Sep 2009 05:20:35 PM
I haven't modeled data from that program specifically.  But if it's healthcare coding data then you have specific dimensions such as ICD9's, CPT, HCPCS, Providers, dates and anything else your business specifically requires.

Your users of the system should relate to you what they are looking for, and for healthcare it's most likely going to be what I listed above.