Regular Relationship Type in SSAS

By
roopesh.valluru
-
129
8810

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

129 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

41 − 34 =