topic star schema model in QlikView

star schema model

Anonymous — Wed, 07 Nov 2012 12:55:10 GMT

Hi,

i have data in excel and i was hoping to design a star shema model but apparently there are no dimension codes to do that. Is there a way around it or i simply have to generate the codes myself in excel.

Thanks

Re: star schema model

swuehl — Wed, 07 Nov 2012 13:09:59 GMT

You shouldn't design a star schema just for the sake of having a star schema, so maybe you just don't need to do anything.

Can you describe the structure of your excel file? And what you are missing (or what you are planning to analyze)?

Re: star schema model

Anonymous — Wed, 07 Nov 2012 13:14:50 GMT

please find attached and help me accordinly. Thanks

Re: star schema model

swuehl — Wed, 07 Nov 2012 13:44:48 GMT

Just load your table in using the wizard from script editor.

Then you should be fine using such dimensions like Loan_Type, Officer, Branch with some aggregations like e.g. sum(Balance). What else do you want to use as dimensions? Maybe your dates, so have a look at Henrics recent blog post on how to add calendar tables to your data model.

Hope this helps,

Stefan

Re: star schema model

Wed, 07 Nov 2012 15:04:00 GMT

It's pretty easy to do with if you create a key on the detail table. it's as easy as doing

Detail:

Load

Rowno() as Key,

....

and then you can do code like this

[Applied Date]:

Load

Key,

[Applied Date],

month([Applied Date]) as [Applied Month],

...

Resident Detail;

//this removes it from the fact table and leaves it in the dimension table above

Drop Field [Applied Date] from Detail;