topic Re: DataModel in QlikView

DataModel

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

Hi All,

i have 3 tables with same columns so i want to create a data model as star schema how can i do this? i dont want single table data model ..... i want star schema model.

TableA

TableB

TableC

Thanks

Sony

Re: DataModel

soniasweety — Wed, 29 Aug 2018 05:24:52 GMT

what is the best approach? Tresesco B

Re: DataModel

marcus_sommer — Wed, 29 Aug 2018 05:27:15 GMT

Just with the given information the single table would be the best. Why should it be a star-scheme?

- Marcus

Re: DataModel

Anonymous — Wed, 29 Aug 2018 05:37:10 GMT

Hi,

Why does it need to be a star schema?

You can concatenate into one table. If you really need a star schema, create the keys you want to use and the rename the rest of the fields to be different from the other tables

Re: DataModel

arvind1494 — Wed, 29 Aug 2018 05:37:18 GMT

If you have 3 tables with same columns then why do you want star schema

my advise is to use single column..

Re: DataModel

soniasweety — Wed, 29 Aug 2018 05:40:53 GMT

the use requirement is he want to see as star schema not in single table.

like in Qvd generator only we need to create seperate fact and dimension tables.

Re: DataModel

arvind1494 — Wed, 29 Aug 2018 05:42:50 GMT

Fine

then tell me which column are key's in that 3 tables

Re: DataModel

soniasweety — Wed, 29 Aug 2018 05:47:57 GMT

in the above example

A is ID column which is key in all three tables

rest are dim and measure columns

Re: DataModel

arvind1494 — Wed, 29 Aug 2018 05:54:10 GMT

TableA:

Load A as key,B,C,D,E from TableA;

TableB:

Load A as key

B AS B.B

C AS B.C

D AS B.D

E AS B.E FROM TableB;

TableC:

LOAD

A AS KEY

B AS C.B

C AS C.C

D AS C.D

E AS C.E FROM TableC;

Re: DataModel

agastya — Wed, 29 Aug 2018 05:57:25 GMT

My approach is

create star schema

if u don't want single table in this case rename field name treat as separate table.

Re: DataModel

soniasweety — Wed, 29 Aug 2018 05:57:34 GMT

so it will be creating the three different tables with single key column am i right?

from there i want to segregate the separate dimension tables how can i do that?

Re: DataModel

dx_anupam — Wed, 29 Aug 2018 06:06:14 GMT

Hi Sony,

As currently all tables have same column name its concatenating all the table to create a single table. This is default behavior of Qlikview.

To overcome this you can use qualify function. It will replace all column name of table adding suffix to it as "Tablename.columnname" . Just Un-qualify primary key column. It will create association between the table and form a star schema.

Regards,

Anupam

Re: DataModel

BalaBhaskar_Qlik — Wed, 29 Aug 2018 06:29:13 GMT

From the Above, Separate dimension tables created like below:

TableA, TableB, TableC are the separate Dimension tables, connected by Key(A).

Like in the below image, Sales, Docs, VisitActivity are three Dim tables connected by DocID dimension.

Re: DataModel

BalaBhaskar_Qlik — Wed, 29 Aug 2018 06:31:22 GMT

Hence you're having less no.of tables, Data model won't be more bigger than above mentioned.

Re: DataModel

soniasweety — Wed, 29 Aug 2018 07:09:47 GMT

thanks all for your great responses let me try and update you

Re: DataModel

MarcoWedel — Wed, 29 Aug 2018 21:37:03 GMT

Seems an odd requirement.

Maybe you can distinguish the source tables by adding an additional SourceTable field that specifies the data source and (auto-)concatenate the tables nevertheless.

hopt this helps

regards

Marco

Re: DataModel

qlikviewwizard — Thu, 30 Aug 2018 01:41:13 GMT

Hi,

Try like this.

TableA

B as B1

C AS C1

D AS D1

E AS E1

TableB

A AS AA

B as B2

C AS C2

D AS D2

E AS E2

TableC

A AS AA

B as B3

C AS C3

D AS D3

E AS E3

Re: DataModel

soniasweety — Thu, 30 Aug 2018 04:05:07 GMT

Hi marcowedel

balabhaskarqlik

1.what i have done is i have loaded 3 tables and bydefault auto concatenation happened and treated as single table

then after i stored in one QVD.

2. I have loaded that qvd again with dimension and fact columns and stored as seperate qvd's in QVd generator

in main app i have loaded all these qvd's.