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:

·         2nd 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.