Manohar Paleti

My photo
Hyderabad, AP, India
Working as a BI Consultant, Served for various organizations as an OBIEE Developer by building the BI Solutions for Business Decision Making..

Thursday, January 20, 2011

Differences B/w Chronological Key and Logical Key

Hi  Guys,

we know functionality of both the keys..
can someone explain what are the differences between these two Pls..

Thanks,

2 comments:

  1. chronological key is the key which uniquely identifies the data at particular level. chronological key is mostly used in time dimensions where time series functions are used.

    where as logical key is the key which is used to define the unique elements in each logical level.A logical level may have more than one level key. When that is the case, specify the key that is the primary key of that level.It is used to specify the columns which is used for drill down and which is used as primary keys.

    ReplyDelete