how to create a fact table from multiple dimension tables in SQL server 2008(Visual Studio 2012)?
<p>I have four dimension tables named <code>Branch</code>, <code>Product</code>, <code>Supplier</code> and <code>Time</code>. I am taking all primary keys from these tables namely <code>b_id</code>, <code>p_id</code>, <code>s_id</code> and <code>quarter_id</code> to create my fact table. And I am adding another attribute named <code>total sell</code> based on another table named <code>Customer_Bill</code> which has <code>quantity</code>.  </p>

<p>I want to create the fact table with data such that I get values for all the fields.<br>
e.g. 1st branch with 3rd supplier sold 5th product in 2nd quarter and the amount is 34.  </p>

<p>can anyone please help? </p>