Regular Relationship Type in SSAS

By
roopesh.valluru
-
178
9144

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

RELATED ARTICLESMORE FROM AUTHOR

178 COMMENTS

  3. Very informative article. Good for any SSAS novice.
    I like this website very much. Keep posting buddy.. Thanks for your sincere efforts.

    -Srinivas Indukuri

  6. If you have a risk for having an erection after taking Cialis try having additional sex before your Cialis session generic cialis online pharmacy The pharmacologic evolution that has occurred over the past several decades has directed the current understanding of the pathophysiology of the disease process

  7. If you have or have ever had heart problems such as a heart attack , heart disease, irregular heartbeat, angina, chest pain, narrowing of the aortic valve, heart failure, heart surgery, pulmonary hypertension including pulmonary arterial hypertension, stroke, low blood pressure, high blood pressure, a deformed penis shape Peyronie s Disease , priapism an erection that lasts for more than 4 hours , sickle cell anemia, multiple myeloma, leukemia, retinitis pigmentosa a rare genetic eye disease , severe vision loss such as NAION , bleeding problems, stomach ulcers, liver problems or kidney problems such as kidney dialysis , you may be at higher risk for adverse effects generic cialis vs cialis Check your insurance policy and local pharmacies for price information

  8. He was a visiting professor at the University of Patras in Greece in 1978, and was elected a Corresponding Member of the Academy of Athens in 2001 where he delivered his inaugural lecture in Greek generic for cialis They were employed as builders, ie, as carpenters

  34. This is nicely expressed! !
    canadian pharmacies-247 [url=https://canadapharmacies-24h.com]non prescription online pharmacy reviews[/url] best canadian mail order pharmacies

  38. Whoa many of excellent data.
    canadian pharmacy no prescription [url=https://canadianpharmacies-24h.com]pharmacy technician classes online free[/url] canada drugs direct

  40. Very well expressed indeed! .
    essay writers net [url=https://writingthesistops.com]what to write my college essay about[/url] custom essay writing services reviews

  50. pct nolvadex These included testosterone , dehydroepiandrosterone DHEA , letrozole Femara , recombinant LH rLH , recombinant hCG rHCG , estradiol , clomiphene citrate Clomid , progesterone , growth hormone GH , and coenzyme Q10 CoQ10.

  67. You stated that effectively!
    need help in writing an essay [url=https://homeworkcourseworkhelps.com]things to write a persuasive essay about[/url] help me write a personal statement

  70. Kudos! Useful information.
    prescription drug price comparison [url=https://canadianpharmacyonlinedb.com]canada pharmacies online[/url] pain meds online without doctor prescription

  75. You actually suggested this wonderfully!
    how to write a college narrative essay [url=https://altertraff.com]how to become a better essay writer[/url] writing assignment help

  86. You reported that exceptionally well.
    canada pharmaceuticals online [url=https://canadapharmacyspace.com]no 1 canadian pharcharmy online[/url] prescription drugs online without doctor

  102. You actually explained it wonderfully!
    how to write a good college admissions essay [url=https://service-essay.com]how to write a good conclusion to an essay[/url] website that writes essays

  120. You said that exceptionally well!
    price prescription drugs [url=https://canadapharmacyspace.com]drug costs[/url] international drug mart canadian pharmacy online store

  126. Thanks a lot. Wonderful information!
    on writing the college application essay [url=https://agbsl.pro]how to be good at writing essays[/url] letter writing help online

  133. 8 Baseline IGF binding protein levels ng mL Median range 4, 730 2, 430 6, 090 4, 260 1, 990 8, 880 Mean SD 4, 601 lasix tablet suburb is in its first year, and she says it took a lot of work to get there

  137. You actually expressed that well.
    canadian drugs without prescription [url=https://canadadrugspower.com/]overseas pharmacies shipping to usa[/url] canadian pharmacy online review

  140. Regards. Ample facts!
    drugs without a doctor s prescription [url=https://canadianpharmacyonlinedb.com/]how to find a reputable canadian pharmacy[/url] prescription drugs to speed up metabolism

  142. Useful advice. With thanks!
    pharmacy technician online degree [url=https://sopharmsn.com/]no prescription cialis canadian pharmacy[/url] tretinoin canada pharmacy

  143. Valuable info. Many thanks.
    can americans order pregabalin from canadian pharmacies [url=https://canadianpharmaceuticalsonlineus.com/]pharmacy online program[/url] global pharmacy canada legitimate

  147. Thank you, Helpful stuff.
    most trusted canadian pharmacies [url=https://canadianpharmacies-24h.com/]which canadian pharmacies are legit[/url] real viagra online canadian pharmacy

  148. You revealed that well.
    aarp approved canadian online pharmacies [url=https://onlinepharmacycanadahelp.com/]online colleges for pharmacy tech[/url] pharmacy technician online certification course

  150. You mentioned that effectively!
    legit canadian online pharmacies [url=https://onlinepharmacycanadahelp.com/]online schools for pharmacy technician[/url] online pharmacies no prescription

  152. Valuable write ups. Thanks a lot.
    online pharmacies without prescription [url=https://sopharmsn.com/]pharmacy technician job in canada[/url] reddit online pharmacy

  153. Superb facts, Thanks a lot!
    which canadian online pharmacy is the best [url=https://sopharmsn.com/]canadian online pharmacies ratings[/url] buy prescription drugs online canada

  158. You definitely made the point.
    canada pharmacy online [url=https://sopharmsn.com/]online pharmacy without insurance[/url] contact your pharmacy to fill this rx

  162. Also associated with increased risk for prostate cancer, pancreatic cancer, and GI tract malignancies can lasix be crushed mesterolone remedio levitra Robert Marimon, a 91 year old retired electrical engineer and World War Two veteran from Avon Lake, Ohio, said this was his planned first stop on a U

  163. As I am looking at your writing, baccaratsite I regret being unable to do outdoor activities due to Corona 19, and I miss my old daily life. If you also miss the daily life of those days, would you please visit my site once? My site is a site where I post about photos and daily life when I was free.

  171. The same trend is valid for the expression of miRNAs, where remarkable variations between patients samples of the same cancer subtype are also observed does doxycycline cover mrsa The intermediate RS was seen in a small number of patients, making it difficult to draw conclusions about the benefit of chemotherapy in this group

LEAVE A REPLY

Please enter your comment!
Please enter your name here

2 + 2 =