I have a dimension call Company with the following member
region (5)
district (15)
territory (25)

I have a Budget fact, which is being assign at the Territory level (the
lowest for the dimension previously describe. I do know the relation between
the territory in Budget and the Company dimension.
Question 1: Should i create 3 dimension one for each member in the company
Question 2: If I create only one dimension how can I ask the following
question.
List the
region
Distrinct
All Territories that belong the this hirerchy and its budget.

I try to create dimension with only region and District, and another
dimension with Territory. I then mapped the same territory to the Budget
fact, but when I ask the question to bring me the
Region
district
each individual Territory (not all of them, only the one that
belong to that hierarchy, I can not make it work.
Thank you in advance