Defining a Dimension Table with Primary Key for Dimension

When you are declaring the dimension table containing the primary key for the dimension, they should be declared in a lower-level tag, instead of directly in the hierarchy tab. For example, the following is not a valid declaration:

<hierarchy hasall="false" primarykey="time_id" primarykeytable="time_by_day">
...

It should be declared as follows:

<hierarchy hasall="false" primarykey="time_id">
<Table name="time_by_day">
</Table>
...