how to relate 2 dimension to each other

Posted on 2011-10-26
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
    LVL 17

    Expert Comment

    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

    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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    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.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now