Datamodel inital step

[#1]

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

[Anonymous]

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

A,

b,

c,

'Tab1'  as Flag

from tab1.qvd;

concatenate

load

w,

s,

d,

'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

[sujeetsingh]

Go tho this link for reference

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

[#4]

Can u please give describe by giving example

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

regards

Mahesh

[sanketkhunte]

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

[#6]

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

[ngulliver]

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

[#8]

Can u pls send me the link

regards

Mahesh

[ngulliver]

Hi,

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

Regards,

Neil