Dimensional query - rule no.1...Join on the surrogate keys

For every star that you want to query, join the fact table to its dimensional tables. So, for example:

SELECT ...
FROM sales_fact sf, date_dim dd, store_dim sd, product_dim pd
WHERE
sf.dd_sk = dd.dd_sk
AND sf.sd_sk = sd.sd_sk
AND sf.pd_sk = pd.pd_sk