Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to setup Dimension Usage for referenced Dimension Expand / Collapse
Author
Message
Posted Friday, August 13, 2010 5:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 12, 2013 8:23 AM
Points: 41, Visits: 81
I have a Sales cube defined and working with several measures related to a customer dimension. This is all working fine as of now.

One of the attributed of the Customer Dimension is a Sales Rep ID.

I now need to be able to query the cube and get results by Region.

So I Created a Sales Persion Dimension w/ two attributes of Rgion and Sales person and added the dimension to the cube. The problem is in setting the Dimension usage for this new dimension. There is no direct relationship of the Sales Person dimension to the fact table except through the Customer Dimension.

In my estimation this should be a referenced relationship type. I have the Relationship type = referenced, reference dimension = Sales Person Dim, Intermediate Dimension = Customer Dim, and Reference dimension attribute = sales persion. When I click on the Intermediate dimension attribute I expect to have an option of selecting the Salesperion attribute from the customer but it is not in the dropdown list.

What am I missing here?

Thanks,
Don
Post #969320
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse