Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 4 tables. PDV,INC,SUI,DMM.
n°PDV n°Incident n° suivi
PDV x
INC x x
SUI x x x
DMM x x x
How can create the star schema with fact table like DMM and dimension around like PDV, INC, SUI ?
Thanks for your help.
Please find the attached file.
see if it is working for you.
HTH
Sushil
Hi Jud,
It is just not to ask for star schema ,but you shoyld first get familiar with schema ,,,fact Dimension...and all aothe data warehousihg terms.
So i am giving you some link and go through them all and then analyse a best plan for your structure .
http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/
One of the easy way for your modell is just nPDV as same in all and load all table with same name column renamed.
Thanks for your help Sushil.
Hi Son ofSardar.
Thanks a lot for your link.