topic Re: Creating a Data Model in QlikView

Creating a Data Model

omkarvamsip — Sat, 16 Nov 2024 04:50:56 GMT

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,

Re: Creating a Data Model

miguelbraga — Fri, 04 Jan 2019 09:44:52 GMT

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,

Re: Creating a Data Model

omkarvamsip — Fri, 04 Jan 2019 09:55:20 GMT

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

Re: Creating a Data Model

miguelbraga — Fri, 04 Jan 2019 10:14:18 GMT

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,

Re: Creating a Data Model

omkarvamsip — Fri, 04 Jan 2019 10:17:20 GMT

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.

Re: Creating a Data Model

miguelbraga — Fri, 04 Jan 2019 10:21:34 GMT

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,

Re: Creating a Data Model

omkarvamsip — Fri, 04 Jan 2019 10:35:03 GMT

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