I have a fact table with three columns:

Date
Amount
AdPlacementID

Our hierarchy looks like this:

BusinessGroup (parent child)
SalesPerson
Customer
AdPlacementID


I need a parent child dimension off of the BusinessGroup table, however I'm
having trouble getting at it.

I see two separate dimensions:

1. SalesPerson -> Customer -> AdPlacementID
2. BusinessGroup

I'd love to combine them into a single dimension called "sales", however
that doesn't seem possible. Separating them into two dimensions work only if
I include BusinessGroup into the fact table view.

True? Any other options?

Hi

Yes it is true. You have to create two dimensions.
The parent-child dimension can based only on two related field of one table.

Vladimir Chtepa

"Jesse O" <jesperzz (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:%238tAhGwRGHA.3972 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

So I'll have to include the BusinessGroup in the fact table view?


"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote

Anyone?

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Assuming that you're using AS 2205, you might be able to set up Business
Group as a Reference Dimension off the SalesPerson dimension, which will
presumably join to the fact table via AdPlacementID (if there is some
SalesPerson attribute that can join to the BusinessGroup P-C table).


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***