Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
adoteykwame
Contributor

star schema model

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

4 Replies
MVP
MVP

Re: star schema model

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)?

adoteykwame
Contributor

Re: star schema model

Capture.PNG

please find attached and help me accordinly. Thanks

MVP
MVP

Re: star schema model

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

Not applicable

Re: star schema model

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;

Community Browser