Thursday 10 April 2014

Types of Attributes:

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:
Ø  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