how to relate 2 dimension to each other

Posted on 2011-10-26
Medium Priority
Last Modified: 2016-02-14
Dear all
I am working with SSAS using SQL Server 2008 R2
I have 2 dimensions and 1 fact table
In the dimension usage in the cube how can I relate the dimension 1 and dimension 2
Question by:RamzyNEbeid
  • 2
LVL 17

Expert Comment

ID: 37037724
You must have "keys" that relate Dims to Facts. So in your FACT table you should have a key that has the DIM name within it, or should to make things easier.

Is this what you mean..?
LVL 17

Accepted Solution

MIKE earned 2000 total points
ID: 37037796
You'll have to use the FACT and there should be keys for each DIM in the fact to link each DIM to the FACT. You will need to be very careful about duplicating records and so you'll need to know your data before you build your query or at least do some analysis to understand how the data within the DIMs relate to the FACT. (ie. one to one, or one to many)

In a correctly built Data Warehouse, you should have a one to one relationship and so the data should align correctly.....but trust me I've seen it all different ways.


Author Comment

ID: 37140780

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question