0 Replies Latest reply: Jul 25, 2014 3:12 AM by Chandra kanth RSS

    Hierarchy problem

    Chandra kanth

      Hi,

       

      There is order table with order_date  (MM/DD/YYYY) column. There is no TIME table in Physical layer. I have Created TIME table in BMM layer with columns Calender Year,

      Calender Quarter, Calender Month, Calender Week, Calender Day (Detail level).

      For each column i have chosen Existing Logical Column as source that is order_date column from Order table in BMM layer.

      For calender year i have written formula: EXTRACT( YEAR  FROM OE.ORDERS.ORDER_DATE), similar way for other columns also.

       

      So far there is no problem. I have created dimension with this and made it TIME DIMENSION.

      Created logical levels (year, quarter,month,week,day) and assigned respective columns as said above.

      When i perform consistency check it's giving the following error. I could not understand how to solve this.

       

      [nQSError: 15001] could not load navigation space for subject area OE.

      [nQSError: 15037] Table, TIME, has multiple key level associations: [TIME.CALENDER YEAR,TIME.CALENDER QUARTER,TIME.CALENDER MONTH, TIME.CALENDER WEEK,

      TIME.CALENDER DAY] and [TIME.CALENDER YEAR,TIME.CALENDER QUARTER,TIME.CALENDER MONTH, TIME.CALENDER WEEK,

      TIME.CALENDER DAY].

       

      Regards,

      CK