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,