Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Model review

I would like some feedback on this data model I have created for my organization. The model contains about 110 million rows. The performance in Ajax is actually quite fast. I would just like to hear what people think about this type of design. I used the patients as the center of the snowflake and then branched off on hospital visits, ambulatory visits, and home health visits. I could not use a master calendar with this table, nor do I think I would want to, as I want to see all a patients visits say in the hospital, when I choose their ambulatory encounter.

I also had to reload many of the dimension tables, as the dimensions are attached to each fact table with a left keep. So if I use a resident pull from them, I only get those providers from that fact table. I just would like to hear what people think and I am open to suggestions on how to make this better!

0 Replies