topic Re: create fact table in QlikView

create fact table

Fri, 27 Mar 2015 11:51:15 GMT

please download the attachment

and allow me to know .how to create fact table of these dimensions table

thanks in advance

Re: create fact table

Peter_Cammaert — Fri, 27 Mar 2015 16:26:47 GMT

There is just master data in your three tables, meaning that they translate into dimensions. But the facts come from different tables (missing in your picture) like sales records, or customer calls, or shipments. Do you have any tables like that?

Re: create fact table

pokassov — Fri, 27 Mar 2015 17:29:38 GMT

Fact:

NoConcatenate Load

resident

User;

Left Join (Fact)

Load

Resident

Target;

Left Join (Fact)

Load

Resident

TargetClient;

DROP Tables

User, Target, TargetClient;

Re: create fact table

buzzy996 — Fri, 27 Mar 2015 17:34:00 GMT

there is no fact data in ur table ,whichever u shoed all are the dimension data.

in simple words,

facts means measure's(keys to help understand the business)