Hi Guys I am listing by ref some other blogs...Please correct me if there are any wrong answers.
Cheers...
What is Chronological Key?
Chronological key uniquely identifies the data at particular level. Chronological key is mostly used in time dimensions where time series functions are used.
What is Logical Key?
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 which is primary key of that level. It is used to specify the column which is used for drill down and which is used as primary keys.
What is level Based measure?
Level-based metrics means, having a measure pinned at a certain level of the dimension.
Cheers...
What is Chronological Key?
Chronological key uniquely identifies the data at particular level. Chronological key is mostly used in time dimensions where time series functions are used.
What is Logical Key?
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 which is primary key of that level. It is used to specify the column which is used for drill down and which is used as primary keys.
What is level Based measure?
Level-based metrics means, having a measure pinned at a certain level of the dimension.
No comments:
Post a Comment