Dimension --> Dimension --> Fact Relationships


#1

My data mode is like the following:

Fact:
salesfigure
productkey

dimproduct:
productkey
subcategorykey

dimsubcategory:
subcategorykey
subcategorydescrition

I’d like to be able to create a visualization grouped by the subcategorydescription, summing by salesfigure. I’ve modeled this such that the FKs are mapped but when I try to create the question, I only see the first relation to the fact table but not any further downstream. For example, I see dimproduct in the drop down but not dimsubcateogry. Is there a way to model and use these multi-level relationships?


#2

Hi @jake1
It sounds like you’re looking multiple joins. Does this issue sound similar?


#3

Yup, exactly. Guess I didn’t search long enough to find that. I gave it a thumbs up.