Attributes & its Types

[Former Member]

Attributes

Types of Attributes:

1. Ø  Display Attributes.
2. Ø  Exclusive Attributes
3. Ø  Navigational Attributes
4. Ø  Time dependent Attributes
5. Ø  Time dependent – navigational attributes
6. Ø  Compounding attributes
7. Ø  Transitive attributes

1. Display Attribute: Any info object if Attribute only check box selected it becomes display attribute

Ø  It is stored in Attribute table - /P

Ø  It gives the present truth in the reporting

Ø  It will completely depend on the Main Characteristic

2. Navigational Attribute: Whenever the attribute want to act as characteristic at query level we use navigational attribute

Ø  It gives present truth

Ø  It is stored in - /X

Ø  Navigation attribute should be ON with description

Ø  Whatever we can do with a normal characteristic in a query, we can do that with navigational attribute in the reporting

Ø  Naming convention of navigational attribute à Main characteristic name _ attribute name

Ø  This navigational attribute should be taken into the info provider (Ex: DSO, CUBE, Multi Provider) & Info object should be ON so that it enables for reporting otherwise it is not available for reporting

3. Exclusive Attribute: The attribute only check box is deselected

4. Time Dependent attribute (Display Attribute + Time Dependent Property): (Select the time dependent check box)à When we have the value of characteristic changing based on time period, we model these info object as time dependent attributes – which enables to maintain the different values w.r.t 2 more fields (Date From & Date To)

Ø  Time dependent attributes will be stored in -/Q

Ø  Key date will define what value it has to bring from the time dependent attribute table

5. Time dependent Navigational attribute

Ø  It is both Time Dependent & navigational

Ø  It is stored in table - /y

6. Compounding Attribute:

Ø  Superior level of attribute

Ø  When the value of one info objects depends on the value  another info object

Ø  Example: I have two plants, PLANT 1: M1, M2, M3, PLANT 2: M1, M2, M3

Ø  Here Material is compound of PLANT

Ø  Compounding attribute will act as part of primary key to all your attribute, text & SID table

Ø  Ex: 0MAT_PLANT, 0REASON_CDE_0COMP_CODE.

Ø  Compounding attribute will degrade loading performance

7. Transitive Attribute:

Ø  2^nd level of navigational attribute

Ø  If one navigational attribute will have another navigational attribute

Ø  How do you find delta Process of Data Source?

Ø  ROOSOURCE TABLE

Ø  Detail level of Delta information: RODELTAM

Ø  Early Delta Initialization (It will enable for LO): In info package update tab you can see a radio button Early Delta Initialization - If you execute the early delta initialization, the source system update can continue and data can be written to the delta queue while the initialization request is being processed.

Regards

Anil Kumar Thalada