Regular Relationship Type in SSAS

244
10712

Friends,

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

I am taking the following tables to demonstrate Regular relationship type.

1) FactInternetSales

2) DimProduct

The above two tables have foreign key relationship on the column “ProductKey” and hence to fetch data from both the table the query looks like –

Select * from FactInternetSales
INNER JOIN DimProduct on FactInternetSales.ProductKey = DimProduct.ProductKey.

We used INNER JOIN to join the above two table and the same relationship can be provided  in SSAS cube which is called as Regular Relationship Type. If we want to relate the above query with SSAS Cube implementation then DimProduct table is the Dimension Table in Cube and FactInternetSales is Fact Table and the Regular relationship Type is the JOIN which we provided in the above query. PFB the screen with our providing relationship between dimension and fact.

No Relationship given

No Relationship given

Now lets see the steps to be followed to provide Regular Relationship Type between a dimension and a fact. 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.

1) Select the relationship Type as “Regular”.

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.

Setting Regular Relationship

5) After selecting Measure Group Columns click OK.

That’s it .. The regular relationship is set between a dimension and fact table.

Note – If you provide relationship between dimension table and fact table in SSAS DSV(Data Source View) and the relation ship is direct then Regular will be automatically set by SSAS Server when we add Dimension and Fact. So the best and easiest way is to give relationship in DSV level.

Regards,

Roopesh Babu V

244 COMMENTS

  1. Very good advice. Appreciate it!
    [url=https://argumentativethesis.com/]tentative thesis statement[/url] writing a research thesis [url=https://bestmasterthesiswritingservice.com/]help writing a thesis[/url] thesis genorator

  2. Info clearly used..
    [url=https://essaytyperhelp.com/]helping essays[/url] help others essay [url=https://helptowriteanessay.com/]law essay writing service[/url] i need help writing my essay

  3. Nicely put. Regards!
    [url=https://englishessayhelp.com/]help writing an essay for college[/url] high school essay help [url=https://essaywritinghelperonline.com/]essay paper writing help[/url] college admissions essay help

  4. With thanks. Fantastic information!
    [url=https://bestpaperwritingservice.com/]paper writing services[/url] paper writing service search [url=https://bestonlinepaperwritingservices.com/]cheapest paper writing service[/url] where to buy resume paper

  5. Seriously loads of helpful information.
    [url=https://dissertationwritingtops.com/]ma dissertation writing service[/url] buy phd research proposal [url=https://helpwritingdissertation.com/]phd writing service[/url] research statement for phd

  6. This is nicely put! .
    [url=https://argumentativethesis.com/]service quality phd thesis[/url] thesis statement for explanatory essay [url=https://bestmasterthesiswritingservice.com/]phd thesis defense[/url] thesis about food service management

  7. Thank you! Lots of material.
    [url=https://essaywritingservicehelp.com/]urgent essay writing service[/url] uk essay writing service [url=https://essaywritingservicebbc.com/]cheap custom essay writing services[/url] resume writing services for customer service jobs

  8. Appreciate it. A good amount of write ups!
    [url=https://quality-essays.com/]pay to get essays written[/url] pay essay writer [url=https://buyanessayscheaponline.com/]pay someone to write essay[/url] buy essay writing

  9. You made your stand very well..
    [url=https://essayssolution.com/]pro essay writers[/url] essay writer for hire [url=https://cheapessaywriteronlineservices.com/]can someone write my essay for me[/url] cheapest essay writer

  10. Good write ups. Kudos.
    [url=https://studentessaywriting.com/]essay writing service no plagiarism[/url] best custom essay writing services review [url=https://essaywritingserviceahrefs.com/]best essays writing service[/url] cheap essay service

  11. Truly tons of good information!
    riversweeps online casino download [url=https://bestonlinecasinoreal.us/]gila river online casino[/url] caesars casino – free online slots machines games

  12. You actually explained this wonderfully!
    [url=https://ouressays.com/]buy term paper[/url] buy research paper [url=https://researchpaperwriterservices.com/]term paper writers[/url] research paper service

  13. You actually reported this fantastically.
    [url=https://phdthesisdissertation.com/]dissertation writing service[/url] dissertation writing help [url=https://writeadissertation.com/]write a dissertation[/url] dissertation writing uk

  14. With thanks, Good stuff.
    [url=https://service-essay.com/]custom papers review[/url] online research paper writing services [url=https://custompaperwritingservices.com/]best research paper writing service[/url] scientific paper writing services

  15. Kudos. Terrific stuff!
    [url=https://researchproposalforphd.com/]research paper writer[/url] make proposal [url=https://writingresearchtermpaperservice.com/]buy a research paper for college[/url] proposal thesis

  16. Kudos, I like this!
    [url=https://payforanessaysonline.com/]pay for paper[/url] pay to get essay written [url=https://buycheapessaysonline.com/]buy essay online safe[/url] order of essay writing

  17. Thank you. Terrific information.
    [url=https://essaytyperhelp.com/]help to write an essay[/url] college application essay help [url=https://helptowriteanessay.com/]college essay help online[/url] essays writing help

  18. Thanks. I appreciate this.
    [url=https://bestpaperwritingservice.com/]college term papers for sale[/url] online research paper writing services [url=https://bestonlinepaperwritingservices.com/]paying someone to write a paper[/url] writing papers services

  19. You expressed this fantastically.
    [url=https://helpwithdissertationwriting.com/]writing help[/url] best dissertation [url=https://dissertationwritingtops.com/]proquest dissertations[/url] dissertation abstracts

  20. Thanks a lot, I like this!
    [url=https://essaytyperhelp.com/]paperhelp[/url] need help writing an essay [url=https://helptowriteanessay.com/]help essay[/url] how to write a college essay

  21. You said it perfectly..
    [url=https://payforanessaysonline.com/]pay someone to write my college essay[/url] buy essays [url=https://buycheapessaysonline.com/]pay to write essay[/url] buy essay

  22. Very well voiced genuinely. !
    [url=https://ouressays.com/]write my term paper[/url] custom research paper writing services [url=https://researchpaperwriterservices.com/]parts of a research proposal[/url] custom research paper writing services

  23. Seriously lots of good advice!
    [url=https://studentessaywriting.com/]legit essay writing service[/url] assignment writing service [url=https://essaywritingserviceahrefs.com/]college essays writing[/url] affordable essay writing service

  24. You made your position quite well!.
    [url=https://argumentativethesis.com/]college thesis[/url] thesis writing service [url=https://bestmasterthesiswritingservice.com/]thesis proposal example[/url] define thesis

  25. Thanks. Excellent information!
    [url=https://payforanessaysonline.com/]pay for college papers[/url] pay for college papers [url=https://buycheapessaysonline.com/]pay for essay papers[/url] order essay

  26. Amazing quite a lot of amazing tips!
    [url=https://customthesiswritingservice.com/]thesis paper[/url] write a thesis [url=https://writingthesistops.com/]thesis creator[/url] example thesis

  27. Regards, Ample stuff!
    [url=https://essaytyperhelp.com/]help with my essay[/url] how to write a college essay [url=https://helptowriteanessay.com/]argumentative essay[/url] essaypro

  28. Regards, Loads of facts.
    [url=https://argumentativethesis.com/]phd thesis database[/url] thesis creator [url=https://bestmasterthesiswritingservice.com/]good thesis[/url] argumentative thesis statement

  29. Appreciate it! Ample advice.
    [url=https://englishessayhelp.com/]essaytyper[/url] essay writer [url=https://essaywritinghelperonline.com/]essays help[/url] argumentative essay

  30. Wow quite a lot of awesome info!
    [url=https://homeworkcourseworkhelps.com/]my homework[/url] homework help cpm [url=https://helpmedomyxyzhomework.com/]my homework[/url] reddit do my homework

  31. Helpful data. Cheers.
    [url=https://essaypromaster.com/]pay someone to write my paper[/url] cheap paper writers [url=https://paperwritingservicecheap.com/]persuasive essay writer[/url] essay writers online

  32. Excellent information. Kudos!
    [url=https://customthesiswritingservice.com/]thesis titles[/url] argumentative thesis statement [url=https://writingthesistops.com/]argumentative thesis[/url] research thesis

  33. antabuse tablets price south africa [url=https://disulfiram.charity/]can you buy antabuse over the counter in south africa[/url] buy disulfiram canada

  34. You mentioned this superbly.
    [url=https://argumentativethesis.com/]argumentative thesis statement[/url] argumentative thesis [url=https://bestmasterthesiswritingservice.com/]tentative thesis[/url] doctoral thesis

  35. Regards! Ample content.
    [url=https://theessayswriters.com/]ai essay writer[/url] essay writer review [url=https://bestcheapessaywriters.com/]do my essay[/url] who can write my essay

  36. Fantastic data. Thanks a lot!
    [url=https://studentessaywriting.com/]write essay service[/url] free essay writing service [url=https://essaywritingserviceahrefs.com/]best online essay writing services reviews[/url] essay writing service 3 hours

  37. Nicely put. Appreciate it!
    [url=https://homeworkcourseworkhelps.com/]should i do my homework[/url] do my finance homework [url=https://helpmedomyxyzhomework.com/]do my math homework[/url] cpm homework

  38. Thank you, Wonderful information.
    [url=https://hireawriterforanessay.com/]essay writers[/url] essay writers [url=https://theessayswriters.com/]essay writer review[/url] what should i write my college essay about

  39. Really a lot of helpful tips!
    [url=https://argumentativethesis.com/]thesis proposal example[/url] example thesis [url=https://bestmasterthesiswritingservice.com/]define thesis[/url] research thesis

  40. Nicely put. With thanks!
    [url=https://ouressays.com/]proposal writer[/url] termpaper [url=https://researchpaperwriterservices.com/]proposal research[/url] college term papers

  41. Awesome information. Appreciate it!
    [url=https://essaytyperhelp.com/]help writing essay[/url] essays help [url=https://helptowriteanessay.com/]the college essay guy[/url] help with essay writing

  42. Wow quite a lot of fantastic information!
    [url=https://quality-essays.com/]pay for paper[/url] pay to write paper [url=https://buyanessayscheaponline.com/]pay for research paper[/url] pay someone to write your paper

  43. You have made the point!
    [url=https://payforanessaysonline.com/]pay for research paper[/url] pay someone to write my college essay [url=https://buycheapessaysonline.com/]buy essay papers[/url] buy an essay

  44. You actually said that effectively.
    [url=https://writinganessaycollegeservice.com/]essay writing practice[/url] reliable essay writing service [url=https://essayservicehelp.com/]service to others essay[/url] best resume writing service 2020

  45. Appreciate it. Quite a lot of data.
    [url=https://researchproposalforphd.com/]proposal essay[/url] research proposal cover page [url=https://writingresearchtermpaperservice.com/]online proposal[/url] cheap research paper writing service

LEAVE A REPLY

Please enter your comment!
Please enter your name here

− 5 = 2