Attributes
Types of Attributes:
- Display Attributes.
- Exclusive Attributes
- Navigational Attributes
- Time dependent Attributes
- Time dependent – navigational attributes
- Compounding attributes
- 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.
No comments:
Post a Comment