I want to create time hierarchy on Business Layer. I created source table is contains MonthKey, Year, Half of Year, Quarter,Month columns.
I created hierarchy level and I selected level key for all level. I want to Identify the Primary Key for a Dimension Level, I can not select Primary Key Area. becuase primary key area is blank.
Why primary key is blank? What is wrong?