cherriesh


I have 2 tables: Fct_ServiceJob and Fct_ServiceJobItem. They are linked together by Service Job ID and CompanyID.

In dimension usage, I would specify that their relationship is regular. The thing is, i can only specify the ServiceJobID field as their link and i dunno how i can add the Company ID. Can i

Should I do the linking of these tables on the SQL views instead and call this view in analysis instead of setting it in AS

cherriesh




Re: Dimension Usage

Darren Gosbell


You would need to go into the dimension (which I assume is Fct_SeviceJob) and set the key column property of the key attribute to be CompanyID and ServiceJobID. When you have a composite key for the attribute, it will let you pick multiple columns for the relationship.







Re: Dimension Usage

Matt Tolhurst

Hi,

You need to define a composite key on the dimension, if you edit your dimension key. In the properties of the key in your dimension under keycolumns you can add new columns to the key. Your one being company_id. Once you have added one there when you look at the dimension usage it will asked for both ID's.

probably a better walk through:

http://msdn2.microsoft.com/en-us/library/ms175461.aspx

You might want to update the dsv to reflect the composite key of the dimension.

HTH

Matt

didn't see Darren's post but exactly what he said Smile