topic Re: How to confirm fact and dimensions in a dimensional data model using QlikView in QlikView

How to confirm fact and dimensions in a dimensional data model using QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Please anyone explain how to confirm fact and dimensions in a dimensional data model using QlikView.

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

vinieme12 — Mon, 26 Dec 2016 13:04:05 GMT

what do you want to confirm?

if you want to learn what are FACTs and Dimensions, Google it!

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

Anonymous — Mon, 26 Dec 2016 13:09:51 GMT

Thanks for your reply. I want to confirm which table belongs to fact and which tables belong to dimensions while creating a dimensional data model (star schema).

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

Anonymous — Mon, 26 Dec 2016 13:14:10 GMT

I know what is fact and dimension. Please could you say me whether the above data model belongs to which category. I don't know whether this is a perfect dimensional data model. That's why I'm asking.....

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

vinieme12 — Mon, 26 Dec 2016 13:20:56 GMT

all looks good except one thing, the KPI table,

All employees may not have the same KPI's this can't be linked by MonthName, It has to have the Employee Element.

if you have monthly KPI's then create a combination of EMPID+Month for each KPI to link to Employee Table

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

Anonymous — Mon, 26 Dec 2016 13:27:10 GMT

Thank you. But I'm not providing KPI to each employee. It is for the whole organization. If this is the case means, the data model is right or not? and also which schema will it belong to? (Star or snow-flake)

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

vinieme12 — Mon, 26 Dec 2016 13:44:40 GMT

Are you sure ALL Employees have the Same KPI? An Admin and Financial Analyst cannot have same KPI's can they?

what you have is a Snow Flake schema; don't worry too much about schema's unless you have serious performance issues or if you think you can improve it further!

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

Anonymous — Mon, 26 Dec 2016 14:01:39 GMT

Yes I'm sure, this has KPI only to employee count in the organization. So, I think there will be no issues if I proceed further. Thank you so much for your reply.

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

vinieme12 — Fri, 06 Jan 2017 15:48:06 GMT

If your query is resolved, please close the thread by marking a response as Correct.

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

MindaugasBacius — Mon, 09 Jan 2017 10:10:16 GMT

I guess you cannot expect the straight forward answer as there are no definition. Basically, majority uses Star or Snow-flake as it is known from experience that those are the most effective ones to QlikView environment.

This is the simplest table that explains data models:

Also, take a look at this blog post:

https://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Re: How to confirm fact and dimensions in a dimensional data model using QlikView

parimikittu — Mon, 09 Jan 2017 10:29:10 GMT

Hi,

The data model shown is a good. The Total Table is the fact as it gives something which we are about measure like billing hour,billing amt and Rest of the tables are dimensions as there are describing about the Fact data like project type, orginisation type.