SQL Server Performance

How to build Hierarchy Dimension with mapp table

Discussion in 'SQL Server 2005 General DBA Questions' started by lnthach, Jan 24, 2005.

  1. lnthach New Member

    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.

Share This Page