Great i must be progressing as this was what i was thinking :-). My only reservation on adding a DimRole to the model was because the FactOrder grain is at...

yep

i read that review then and ordered a copy. Working through it just now. 😀

This post has been a valuable read for me. Im finally getting into a position where i can spend most of my time in data warehousing to build that experience...

thats great info but can i ask whats the benefits in having a row for every event that im wanting to track as opposed to a row for every users...

yes id be truncating the fact table before every load. I have such difficult with understanding fact tables :angry: i would have never thought about splitting the dates into the...

Hey thanks.

Im not doing an incremental load. so its a full load all the time so there wouldn't be a need to update the fact table they either have a...

Ok thank for the advice guys very helpful. Is this approach off having a sized and unsized record (and others if needed) preferably even tho it will double the rows...

Well i included color and size in the product dimension which worked fine until i discovered that we can have draft orders that have unsized product that we may want...

Great reply thanks.

I was thinking exactly the two options you mentioned. I was even thinking my table structure would be the cases when you go to a snowflak structure., But...

ok so when building my OrderFact table how do i get the relevant ProductKey from the product dimension to use in the fact table for each flavour of product that...

Thanks, yes is a bigger issue ill need to have a think about. I have been wanting to move over to a 445 calendar but this still wont solve my...

Thanks for your reply and sorry for taking so long getting back. My solution just now is to make week53 2015 to week1 2016. The data seem to fit but...

thanks,

yes having a guid like C828EB51-7A7B-40B1-A0CE-CF37559DC3F9 as a customer ref on a report is obviously overkill, so was looking for a shortened unique ref that could be generated from this...

so you cant switch between dev and live database from within your local environment as i can with my web trasnforms in my C# projects? i would have thought MS...

ah right got you. thanks for all the help 🙂