And a thought about ties - If my ties are pretty straight (always 1:M, between 2 anchors and has no knots), in order to simplify ETL and quering for facts and dimensions is it ok to eliminate them?
Example: I have a Sale and Calendar anchors. By the book (if I'm getting this right) I have to create a tie between them and store date of sale in this tie. When I'll create Sales Fact Table in DSV I have to join Sale and tie to get CalendarKey.
What I'm thinking is - add CalendarKey as an attribute to Sale anchor. So Calendar anchor view will be my Dimension and Sale view will be my Fact table.
Thanks in advance!