Tuesday, December 20, 2016

Types of Attributes

Types of Attributes:-
---------------------
1) Display Attribute:-
----------------------
* Completely Dependent on the Charectristic.
* It always gives the present truth.

2) Navigational Attribute:-
--------------------------
* It acts as a Charcteristic in the reporting.
* It always gives the present truth.
* Technical Name - YG_CNO__YG_CNAME.

3) Exclusive Attribute:-
-----------------------
* When we unselect Attribute only checkbox it becomes an Exclusive Attribute, So it can used as a Characteristic in the cube - giving fact.

4) Time - Dependent Attribute:-
------------------------------
* when we see the attribute value changing and if we want to maintain all the values of attribute with respective to different Time intervals we go for Time - Dependent Attribute.
* All Time dependent attributes will be stored in table  - /Q
* /Q table will by default holds DATE-TO AND DATE-FROM fields.
* in /Q table DATE-To filed will be acting as part of Primary Key.
* Value can be controlled by using Key date of the Query in the query properties.

5) Time Dependent NAvigational Attribute
-----------------------------------------

6) Compounding Attribute:-
--------------------------
* Superior Info Object
* When the Value of One Info Object is Dependent on the Value of Another Info Object - we go for compounding.
* 0SOURSYSTEM
Ex:- 0mat_plant

7) Transitive Attribute:-
---------------------------
* Second Level of Navigational Attribute.

Labels:

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home