Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
swuehl
MVP
MVP

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

Anonymous
Not applicable
Author

Capture.PNG

please find attached and help me accordinly. Thanks

swuehl
MVP
MVP

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
Author

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;