Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
omkarvamsip
Contributor II
Contributor II

Creating a Data Model

Hi All,

I need to design a datamodel in Qlikview.

My problem is i dont have fact table with keys pointing to other master dimension tables.So that I cannot able to design a Star schema to get better performance results. 

My schema which i designed is a Snow Flake schema and there is no fact. I am looking for suggestions to build a star schema.
Please find the attachment of my schema in which I mentioned actual keys pointing between tables.

Please suggest any technique on how to design a actual schema in qlikview

Thank you

Regards,

Omschema.png

 

schema 2.png

Labels (2)
6 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hi there,

Before we move on any further, the fields you are showing are only the ones in the picture? Don't you have any field of a date witch might show you some facts happening?

If these are the only fields you have there isn't any much to do with your Data Model. Maybe you consider the possibility to concatenate all tables to form a single table Data Model. 

Best regards,

MB

omkarvamsip
Contributor II
Contributor II
Author

Hi,

Thanks for responding..
we do actually have fields like date,id,unitid...etc in every table.
for example in Admission table, we have IPDNO,AdmissionDate......etc

miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey there,

It best to put every field in the example you've gave so we can grasp and find a way to make a fact table out of your tables. There can be a fact table witch the only link is a common date. This will give you a possibility to create a Master Calendar so you can workout in your Data Model. 

 Best regards,

MB

omkarvamsip
Contributor II
Contributor II
Author

Hi Miguel,

Please find the actual table view attachment. 

I brought some keys into Admission Table using join operations and tried to build schema. 

I want to make sure that did i followed right approach in designing datamodel.

miguelbraga
Partner - Specialist III
Partner - Specialist III

Hi again,

 

Just saw your full Data Model and I would consider leave the detail tables outside the fact table as they will be a dimension table, then concatenate all the other tables to create a Single Fact Table and if there is a common date to all tables besides the details tables rename it to a simple date. I strongly suggest you to try this approach as I could see that you have more than one fact table.

Best regards,

MB

omkarvamsip
Contributor II
Contributor II
Author

sure I will try this approach but i have doubt. are you saying that detail tables means Master Tables to left behind. Just like BedMaster,Department Master,Registration, Registration Details.
And to concatenate Admission, Visit..etc