Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)?
please find attached and help me accordinly. Thanks
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
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;