Fact Relationship Type in SSAS



When the Dimension table and the Fact Table(also called as Measure Group Table) are SAME then that type of relationship is called as Fact Relationship. Lets take a small example from a very well known database to most of us i.e AdventureWorks.

Lets take a scenario like “A user wants to see the number of products available based on Color Type”. In this case “xColor” is my Attribute and that column is from DimProduct table and hence DimProduct is our Dimension table and the measure/metric is “Count” of products which you can get from DimProduct table again and hence our Measure Group table is ALSO DimProduct table. So,

Dimension Table – DimProduct and Attribute – Color

Fact Table – DimProduct and Measure – Count of Rows.

If you write query for the same then it looks like the query given below –

select Color,Count(*) as “Number of Products” from DimProduct Group By Color

The above query returns you the count of products by each color. Now lets see how it looks like in Cube Designer. Remember this is the only Relationship type that you dont need to configure. When you add the dimension to the cube and when you define measure group with the same table that is is used to create Dimension then SSAS Server automatically detects and configures. PFB the screenshot showing the Fact Relationship given between DimProduct Dimension and DimProduct Fact.

Fact Relationship in SSAS
Fact Relationship in SSAS

So, You dont need to worry of giving Fact relationship as the head ache of giving relationship will be taken by SSAS Server.

That’s it .. Happy Coding .. 🙂


Roopesh Babu V


  1. Many thanks. Loads of tips!
    [url=https://essaywritingservicelinked.com/]essay writing websites[/url] essay writing service cheating [url=https://essaywritingservicetop.com/]cheapest essay writing service reddit[/url] do essay writing services work

  2. You mentioned this perfectly.
    [url=https://phdthesisdissertation.com/]buy my dissertation[/url] pay for your dissertation [url=https://writeadissertation.com/]write dissertations[/url] write my dissertation cheap

  3. Nicely put, Cheers!
    [url=https://domyhomeworkformecheap.com/]can i do my homework at barnes and noble[/url] can i use fiverr to do my homework [url=https://domycollegehomeworkforme.com/]do my homework for me[/url] do my math homework for me online free

  4. Thanks, I enjoy this.
    [url=https://essaytyperhelp.com/]professional essay writing help[/url] help writing essay paper [url=https://helptowriteanessay.com/]buy essay[/url] help with writing college application essays

  5. Very good facts. Many thanks!
    [url=https://quality-essays.com/]pay for an essay[/url] essay writing order [url=https://buyanessayscheaponline.com/]essay order of organization[/url] buy my essay

  6. With thanks, Fantastic information!
    [url=https://essaywritingservicehelp.com/]essay writing practice[/url] customer service email writing [url=https://essaywritingservicebbc.com/]top rated essay writing service[/url] law school essay writing service

  7. Thank you! I appreciate this.
    [url=https://payforanessaysonline.com/]buy essays online[/url] essays buy [url=https://buycheapessaysonline.com/]pay to write paper[/url] paying someone to write your paper

  8. You actually revealed this effectively.
    [url=https://writinganessaycollegeservice.com/]writing service[/url] writing essays service [url=https://essayservicehelp.com/]cheap essay writing service uk[/url] best cv writing service 2020

  9. buy prescription drugs without doctor [url=https://cheapdr.top/#]viagra without a doctor prescription[/url] best cure for ed