Chronological key

Chronological key is the key which is uniquely identifies the data at particular level whereas logical key is the key which is used to define the unique elements in each logical level.

Logical Level can have more than one key. When that is the case, specify the key that is primary of that level.

All other dimensions don’t care about the order of the values in it.

e.g. In Region_Dim the values are north, south, west and east. Here nobody wants to see whether north comes first or south comes first. i.e. no order is required here.

In the case of Time Dimension there needs to be a particular order for all the values present in it.

e.g. 2010 is earliest and 2004 is older. Dec-10 is earliest and jan-10 is older. i.e. the values in the time dimension needs to follow a particular sorting order. So the chronological key is the key which tells the OBIEE that the data is incrementing based on the chronological column.

For defining a dimension to be a Time dimension, we need to have a chronological Key.