Friends,
When the Dimension table and the Fact Table(also called as Measure Group Table) are related through some other dimension table then that type of relationship is called as Referenced Relationship Type. Lets take a small example from AdventureWorks database.
I am taking the following tables to demonstrate Referenced relationship type.
1) FactInternetSales – Fact/Measure group table
2) DimProduct and DimProductSubCategory – Dimension tables
In this case FactInternetSales and DimProduct tables have foreign key relationship on the column “ProductKey” and hence to fetch Product wise sales then the query looks like –
Select EnglishProductName,sum(sales_Amount) from FactInternetSales
INNER JOIN DimProduct on FactInternetSales.ProductKey = DimProduct.ProductKey
Group by EnglishProductName
Now if you wish to get data at Subcategory Level then the query looks like –
Select EnglishProductSubcategoryName,sum(sales_Amount) from FactInternetSales
INNER JOIN DimProduct on FactInternetSales.ProductKey = DimProduct.ProductKey
INNER JOIN DimProductSubcategory on DimProductSubcategory.ProductSubcategoryKey = DimProduct.ProductSubcategoryKey
Group by EnglishProductSubcategoryName
If you observe the above query then it is clear that We are not using any column to display from DIMPRODUCT table but still we are using it to give reference between DimProductSubcategory table and FactInternetSales tables.
We used INNER JOIN to join FactInternetSales and DimProduct tables and the same relationship can be provided in SSAS cube which is called as Regular Relationship Type. As we cannot give regular relationship type between FactInternetSales and DimProductSubcategory tables as they dont have KEY to join(in other words not directly related), we can use REFERENCED Relationship type to relate those two tables. If we want to relate the above query with SSAS Cube implementation then DimProduct and DimProductSubcategory tables are Dimension Tables in Cube and FactInternetSales is Fact Table . PFB the screen with out providing relationship between dimension and fact.

Now lets see the steps to be followed to provide Regular Relationship Type between a dimension(DimProduct) and a Measure Group(FactInternetSales). Use the Define Relationship dialog box to define a relationship between a cube dimension and a measure group in Cube Designer. You can display the Define Relationshipdialog box by clicking … on a cell in the Grid pane on the Dimension Usage tab in Cube Designer.
2) Select the attribute that defines the granularity of the measure group with respect to the dimension. This attribute is usually the key attribute of the dimension.(ProductKey in our case).
3) Then it automatically displays Dimension Table and Fact Table.
4) It also displays the Dimension Table columns in RELATIONSHIP GRID and you have to select appropriate Measure Group Columns.
PFB the screenshot of the same.

5) After selecting Measure Group Columns click OK.
We set the relationship between InternetSales and Product using Regular relationship type. Now lets see how to give referenced relationship between FactInternetSales and DimProductSubCategory. Before going to that following things should be in mind while giving referenced relationship type.
1) The dimension which is acting as Intermediate should be created first.
2) The columns that are required to join the fact and second dimension should be selected as Attributes in the Intermediate dimension. From the above SQL query it is clear that my DimProduct dimension(which acts as bridge between fact and subcategory) requires a min of two columns as attributes and i.e ProductKey to join with Fact and ProductSubcategoryKey to join with DimProductSubcategory Dimension.
Now please find the steps below to give referenced relationship –
1) Select the relationship Type as “Referenced”.
2) Select the intermediate Dimension(In our case it is Dim Product).
3) Select the attributes from both the dimensions which forms a relationship between these two dimensions(In our case it is ProductSubCategoryKey).
4) Materialize option is checked and leave it as it is.
5) Click on OK.

That’s it .. It is as easy as this .. Happy Coding !!
Regards,
Roopesh Babu V
I am very impressed with your writing baccaratsite I couldn’t think of this, but it’s amazing! I wrote several posts similar to this one, but please come and see!
what is the best ed drug: ed pills that work quickly – erectile dysfunction treatment
hims ed pills: best otc ed pills – ed pills online pharmacy
Viagra Generika kaufen Schweiz: Viagra rezeptfreie bestellen – Viagra rezeptfreie Schweiz bestellen
Viagra homme sans prescription: Viagra sans ordonnance 24h Amazon – Viagra Pfizer sans ordonnance
Acheter viagra en ligne livraison 24h: Viagra en france livraison rapide – Viagra gГ©nГ©rique sans ordonnance en pharmacie
viagra acquisto in contrassegno in italia: viagra generico sandoz – viagra consegna in 24 ore pagamento alla consegna
viagra para mujeres: viagra para mujeres – comprar viagra online en andorra
SildГ©nafil Teva 100 mg acheter: Viagra homme sans ordonnance belgique – SildГ©nafil 100 mg prix en pharmacie en France
Viagra pas cher paris: Viagra homme prix en pharmacie – Viagra homme prix en pharmacie sans ordonnance
sildenafilo precio farmacia: sildenafilo 50 mg precio sin receta – sildenafilo cinfa sin receta
https://drugswithoutdrprescriptions.com/# viagra mexican pharmacy
farmacia gibraltar online viagra: sildenafilo cinfa 100 mg precio farmacia – viagra online cerca de zaragoza
sildenafilo 50 mg precio sin receta: farmacia gibraltar online viagra – viagra para mujeres
https://viasenzaricetta.com/# viagra online spedizione gratuita
https://viasenzaricetta.com/# pillole per erezione immediata
http://clomidsale.pro/# can i order cheap clomid tablets
http://cytotecsale.pro/# cytotec online
https://doxycyclinesale.pro/# doxycycline uk online
http://clomidsale.pro/# get cheap clomid pills
medication from mexico pharmacy: pharmacies in mexico that ship to usa – mexican drugstore online
cheapest online pharmacy india: best online pharmacy india – best india pharmacy
mexican border pharmacies shipping to usa [url=http://mexicopharm.pro/#]buying from online mexican pharmacy[/url] reputable mexican pharmacies online
mexican mail order pharmacies: mexico pharmacies prescription drugs – medicine in mexico pharmacies
п»їbest mexican online pharmacies: mexican online pharmacies prescription drugs – medicine in mexico pharmacies
mexican pharmaceuticals online [url=http://mexicopharm.pro/#]medicine in mexico pharmacies[/url] best online pharmacies in mexico
medication from mexico pharmacy: mexican drugstore online – mexico drug stores pharmacies
mexican pharmaceuticals online: medicine in mexico pharmacies – medicine in mexico pharmacies
online shopping pharmacy india [url=http://indiapharm.pro/#]trusted india online pharmacies[/url] india pharmacy
world pharmacy india: indian pharmacy online – indian pharmacy online
mexico pharmacies prescription drugs: best online pharmacies in mexico – mexican rx online
indian pharmacy paypal [url=https://indiapharm.pro/#]trusted india online pharmacies[/url] buy medicines online in india
doxycycline hyclate: buy doxycycline hyclate 100mg without a rx – buy doxycycline without prescription uk
mexican rx online: medicine in mexico pharmacies – mexico drug stores pharmacies
buy cipro online without prescription: cipro – ciprofloxacin over the counter
canadian drug prices: canadian pharmacy prices – pharmacy canadian
zithromax for sale online: zithromax for sale usa – zithromax online pharmacy canada
how to buy doxycycline online: doxycycline 50mg – 100mg doxycycline
canadian pharmacy antibiotics: online pharmacy canada – canadian drugstore online
zithromax 500mg: order zithromax without prescription – zithromax capsules price
mexico drug stores pharmacies: reputable mexican pharmacies online – mexico pharmacies prescription drugs
zithromax 1000 mg online: buy zithromax no prescription – zithromax online usa no prescription
canadian pharmacy india: top 10 pharmacies in india – india pharmacy
http://overthecounter.pro/# over the counter essentials united healthcare
antibiotics over the counter [url=https://overthecounter.pro/#]best ed pills over the counter[/url] over the counter ed medication
https://overthecounter.pro/# uti medicine over the counter
https://overthecounter.pro/# over the counter muscle relaxers cvs
http://overthecounter.pro/# over the counter viagra
nausea medication over the counter: over the counter ed medication – uti over the counter
http://overthecounter.pro/# bronchial inhalers over the counter
http://overthecounter.pro/# best over the counter sleeping pills
http://overthecounter.pro/# over the counter eczema cream
over the counter sleep aids that work: wellcare over the counter ordering – best over the counter cold medicine
canadian pharmacy store [url=http://pillswithoutprescription.pro/#]canadian online pharmacy no prescription[/url] price prescriptions
new ed drugs: ed pills for sale – ed medications online
ed medication: herbal ed treatment – pills for ed
https://edpills.pro/# male erection pills
http://edpills.pro/# cheap ed pills
canadian prescription filled in the us [url=http://pillswithoutprescription.pro/#]canadian online pharmacy no prescription[/url] compare prescription drug prices
Patients may ignore certain AEs that they are having or may not be aware of what AEs are important to report cialis from usa pharmacy If the flap becomes inflamed, it can prevent proper healing
http://edpills.pro/# erection pills online
cheapest ed pills [url=http://edpills.pro/#]over the counter erectile dysfunction pills[/url] erection pills online
ed meds: buy erection pills – the best ed pill
india pharmacy [url=http://indianpharmacy.pro/#]pharmacy website india[/url] online shopping pharmacy india
https://indianpharmacy.pro/# world pharmacy india
http://indianpharmacy.pro/# pharmacy website india
http://indianpharmacy.pro/# top 10 pharmacies in india
Online medicine order [url=http://indianpharmacy.pro/#]world pharmacy india[/url] best india pharmacy
http://indianpharmacy.pro/# best india pharmacy
http://edmeds.pro/# medicine for impotence
http://pharmst.pro/# international online pharmacy
pharmacy order online: canadian online pharmacy no prescription – modafinil online pharmacy
otc ed pills [url=http://edmeds.pro/#]the best ed pills[/url] generic ed drugs
pharmacy drugstore online – international pharmacies that ship to the usa order prescriptions
http://fastdeliverypill.com/# online ed drugs no prescription
overseas online pharmacy – international pharmacies that ship to the usa safe canadian online pharmacies
canadian pharmacies recommended by aarp – international pharmacies that ship to the usa canadian pharmaceuticals online
https://fastdeliverypill.com/# no prescription canadian pharmacy
canada meds: international pharmacies that ship to the usa – canada pharmacies online prescriptions
legitimate canadian mail order pharmacy – legitimate canadian mail order pharmacies trusted canadian online pharmacy
mexican drug pharmacy: order prescription medicine online without prescription – canadian drugs online viagra
cheap canadian cialis online – certified canadian online pharmacy canada online pharmacies
canadian pharmacies that sell viagra – legitimate canadian mail order pharmacies canadian online pharmacy reviews
compare prescription drug prices: prescription drugs without prior prescription – canadian drugs pharmacies online
canada online pharmacies – meds without a doctor s prescription canada canada pharmacy estrogen without prescription
canadian drugstore reviews – international pharmacies that ship to the usa canada drug stores
http://cialiswithoutprescription.pro/# costco cialis