SQL Server Performance Forum – Threads Archive

How to build Hierarchy Dimension with mapp table

In my database (Core DataWarehouse), relationships of tables are implemented by mapping tables.
Ex:
There are 3 tables:
A(A_ID,A_NAME,…)
B(B_ID,B_NAME…)
C(C_ID,C_NAME,…) I have hierachy: A <- B <- C (A is the top node, B is a child of A, C is a child of C).
In database, there is no physical relations between A, B and C. The logical relation is described in a mapping table (*) such as:
———————————-
A_ID B_ID C_ID
———————————-
A1 B1 C1
A1 B2 C2
…. Can I build a hierarchy dimension of A, B, C?
I also try to create source view but no way to describe the hierachy. So I don’t know how create cube with this hierarchy dimension. (*) There are some reason that I must to using mapping table.

---

]]>