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.