topic Re: Datamodel inital step in QlikView

Datamodel inital step

Mon, 30 Dec 2013 05:34:56 GMT

Hi,

Can any body tell me i have 15 tables in source like sl regarding used for bi.

then hat ill be the steps to design datamodel should we go to load all source tables as storing into VD

or will u do apply map like functions directly onto the source .

if u go applymap function after loading the db table using applymap on qvd s what is the use e are already all the data is loaded into qlikview.

so what is general aproach let me know

regards

Mahesh t

Re: Datamodel inital step

Anonymous — Mon, 30 Dec 2013 05:48:01 GMT

always in data base that is your QVD db that you have created there will be some transaction tables

and there will be Master tables just figure out which are your transaction tables.

When i say transaction tables or qvd that are those tables which contain facts like figure, volumes , quantity, amount , order date, Transaction dates fields ok.

your master table will have Id like OrderId, TransactionId etc which will be also present in transaction tables.

so just load one by one Transaction tables

like this

tab1:

load

'Tab1' as Flag

from tab1.qvd;

concatenate

load

'tab2' as Flag

from tab2.qvd;

in seprate tab in script load Master tables one by one without using Concatenate key word

you will see a star schema like model will be formed which is recommended model in QLIKVIEW..

PLEASE NOTE : i have created a flag by mysely so as to seprate each tables and use in Qlikview set analysis.

anant

Re: Datamodel inital step

sujeetsingh — Mon, 30 Dec 2013 06:26:30 GMT

Go tho this link for reference

http://community.qlik.com/docs/DOC-4556

Re: Datamodel inital step

Mon, 30 Dec 2013 06:51:06 GMT

Can u please give describe by giving example

what is master table and hat is transaction table why flag is useful.

regards

Mahesh

Re: Datamodel inital step

sanketkhunte — Mon, 30 Dec 2013 06:54:49 GMT

Anant really nice solution.

Hello Mahesh -: Here are the few steps we need to follow while creating Data Model in QLikview

1. Find out MASTERs and FACTs tables - with their relationships in your DW.

2. Create the QVDs by using OLEBD or OBDC,as required.

3. Place all QVDs in one folder.

4. Load all QVDs in one QVW and form relationship between these MASTER ans FACT tables with star schema. or any other

5. Reload the QWV and create the report.

Hope this help.

Thank

Sanket

Re: Datamodel inital step

Mon, 30 Dec 2013 07:12:06 GMT

Yaa i got some what clarification,let me confirm master table means dimension table.

is there any blog to see how to design sample star schema from given source.

regards

Mahesh

Re: Datamodel inital step

ngulliver — Mon, 30 Dec 2013 13:09:37 GMT

Hi, Mahesh.

If you go to the Quick Intelligence website (you've had a link sen to you in other recent posts) you will see a number of blogs including the use of ApplyMap, how to design your data model etc.

It's worth having a look through the range of subjects available there.

Regards,

Neil

Re: Datamodel inital step

Mon, 30 Dec 2013 14:47:48 GMT

Can u pls send me the link

regards

Mahesh

Re: Datamodel inital step

ngulliver — Mon, 30 Dec 2013 15:26:59 GMT

Hi,

http://www.quickintelligence.co.uk/qlikview-blog/

Regards,

Neil