Thanks for the information - a couple of follow-up questions if you dont mind my asking.
- How are you handling getting the data from Cerner's hosted datacenter into your warehouse? Exports? Is it automated?
- Where does QlikView fit in with the warehouse and Cognos?
If it would be easier to have a quick chat let me know,
We have extracts that our DBA runs and schedules against the oracle tables depending on the type of extract-- I'm sure with strict regulations from Cerner (we are hosted). We are new to QlikView so we are/will be using it in situations where the capabilities of a Cognos report would be exceeded for logic and ease of display (heavy analysis apps, dashboarding). If you would like more info, send me an email beth.lindholmATchildrensmn.org