Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
squashjunkie
Starting Member
9 Posts |
 Posted - 2007-04-23 : 08:58:03
|
I have a fact table that contains sales line items for 10 different companies. In the Fact table each sales line item is uniquely identified by invoice no, line num and site key.The dimension table that I need to join to, contains each item that can be sold via one of the 10 different companies. This table has a primary key made up of site and item code. This is because one item can be manufactured by more than one company.As I am new to SSAS, how can I best join these tables? If I join the fact and dimension tables in my data source view there is a link set sales.site -> products.site and sales.itemcode -> product.itemcode.I then of course need to have this correctly reflected in my cube, but am not sure on how to link the dimension once i have created it. I created the dimension with hierachy as per the site/product group/item code, but if i link this dimension with a regular relationship i can only link via one column. Can anyone help this novice? Thx"Do or do not. There is no try" |
|
|
|
|
|
Dimension and fact tables