Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
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, September 1, 2016 3:43 PM
Points: 41, Visits: 82
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?

Post #969320
Posted Monday, January 19, 2015 9:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, February 27, 2016 8:38 AM
Points: 1, Visits: 15
The intermediate attributes should have the same number of Key columns as the reference dimension attribute and the data types of the key columns should also correspond.
Post #1652423
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse