topic Re: Create a star schema data model in QlikView

Create a star schema data model

Chandra3 — Tue, 15 Feb 2022 02:33:42 GMT

Hi all

I'm new to qlikview , here i want to create a star schema data model. Help me how to solve this

EX:

here my scenario is :

Table1: Fact table: [Confirmed Cases], [Active Cases], [Cured/Discharged], Death

Table2: Dimension1: [S. No.], Date, Month, Year

Table3: Dimension2: Querter, Region

Table4: Dimension3: //Month, Year as Year_wise, Querter

Table5: Dimension4:[S. No.]as s_no, Date,Region

After loading data i was fixed synthetic keys, then i want create this a star schema dat model how?

Thanks and regards

chandra3

Re: Create a star schema data model

anat — Tue, 15 Feb 2022 03:36:55 GMT

as per your metadata there is no relation between Fact and dimension tables

Re: Create a star schema data model

Harvey — Wed, 02 Mar 2022 03:31:55 GMT

@MyBalanceNow wrote:

Hi all

I'm new to qlikview , here i want to create a star schema data model. Help me how to solve this

EX:

here my scenario is :

Table1: Fact table: [Confirmed Cases], [Active Cases], [Cured/Discharged], Death

Table2: Dimension1: [S. No.], Date, Month, Year

Table3: Dimension2: Querter, Region

Table4: Dimension3: //Month, Year as Year_wise, Querter

Table5: Dimension4:[S. No.]as s_no, Date,Region

After loading data i was fixed synthetic keys, then i want create this a star schema dat model how?

Thanks and regards

chandra3

Identify a business process for analysis(like sales).
Identify measures or facts (sales dollar).
Identify dimensions for facts(product dimension, location dimension, time dimension, organization dimension).
List the columns that describe each dimension.

Re: Create a star schema data model

sachin961 — Fri, 19 May 2023 11:10:28 GMT

Hi,

In Fact table should have some Id field so that you can connect with other Dimension table then you can only make star schema.