Where should the dimension table containing the primary key for dimension be added in the cube schema file

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>
... 
Feedback