Post reply

Parent-Child hierarchy from 1 dimension

  • November 28, 2008 at 1:19 pm

    #203515

    Hi all,

    I'm new in the SSAS 2005 world and I'm trying to build my first cube. Now 'm struggling with a dimension. I have a dimension like this:

    LocationID Department ParentID

    0 Building A NULL

    1 Dept 1 0

    2 Dept 2 0

    3 Building B NULL

    4 Dept 1 3

    5 Dept 2 3

    6 Dept 1 3

    From this I need to create a Hierarchy

    Building

    Department

    In the table I set the prim key to LocationID and a FK ParentID to the same dimension. i tried in many way to get the hierarchy right but i didn't had any success,

    Perhaps can somebody help me to set this up .

    tia

    Eric

  • December 3, 2008 at 9:34 am

    #906987

    Did you try defining a parent-child hierarchy in the dimension itself? (ie ignore the table self-reference, simply set it up in the dim in the AS database).

    These are the 2k8 instructions for implementing a P-C hierarchy, the 2k5 ones will be in a similar subfolder of msdn.

    HTH,

    Steve.

  • December 3, 2008 at 9:35 am

    #906990

    Here's the 2k5 instructions...

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply