Types of Attributes
Attributes are nothing but the fields or properties of the master data.
Here we can create different kind of attributes. There are many kinds of attribute,
we create that according to our requirements.
Here we can create different kind of attributes. There are many kinds of attribute,
we create that according to our requirements.
1. Display Attribute
a. Any Info-Object, if we add to Attribute tab it will become as display attribute.
b. In reporting, display attributes are completely dependent on master data.
c. It always gives the present truth in reporting.
d. It stores in master data table i.e. /p table.
2. Navigational Attribute
Navigational Attribute Master Data.
/BIC/SENL_EID---------------→ SID Table
/BIC/SENL_ENM1-----------→ Navigational Attbr SID Table
Creating Transformations
Master Data in P Table
Now Create Info object for Transaction Data loading.
Transaction Data
Keyfigures
Without switching on Navigational Attribute
Tables generated without switching on Navigational Attribute
After switching on Navigational Attributes
Tables generated after switching on Navigational Attribute
Table Name
|
Description
|
/BIC/FENL_CU
|
Fact Table
|
/BIC/DENL_CU1
|
Dimension Table
|
/BIC/YENL_EID
|
Time Dependent Navigational Attribute
|
/BIC/XENL_EID
|
Time Independent Navigational Attribute
|
/BIC/SENL_EID
|
Sid Table ENL_EMPLOYEEID
|
/BIC/QENL_EID
|
Time Independent Master Data (Display Attributes)
|
/BIC/P/ENL_EID
|
Time Dependent Master Data (Display Attributes)
|
/BIC/MENL_EID
|
View of Master Data Tables: Characteristic ENL_EMPLOYEE ID
|
/BIC/MENL_ENM1
|
View of Master Data Tables: Characteristic ENL_EMPLOYEE NAME
|
/BIC/SENL_ENM1
|
Master Data IDs: InfoObject ENL_EMPLOYEE NAME
|
After loading Master Data the Values generated by these following Tables
/BIC/XENL_EID
|
Time Independent Navigational Attribute
|
/BIC/SENL_EID
|
Sid Table ENL_EMPLOYEEID
|
/BIC/P/ENL_EID
|
Time Dependent Master Data (Display Attributes)
|
/BIC/MENL_EID
|
View of Master Data Tables: Characteristic ENL_EMPLOYEE ID
|
/BIC/SENL_ENM1
|
Master Data IDs: InfoObject ENL_EMPLOYEE NAME
|
/BIC/XENL_EID
|
Time Independent Navigational Attribute
|
/BIC/MENL_ENM1
|
View of Master Data Tables: Characteristic ENL_EMPLOYEE NAME
|
/BIC/SENL_ENM1
|
Master Data IDs: InfoObject ENL_EMPLOYEE NAME
|
Transformation between Data source and Cube
Creating DTP
Output in Cube
3. Executive Attribute
All the depended objects we call it as Exclusive Attribute (If we take 0REGION as a navigation attribute , then 0COUNTRY will act as an exclusive attribute .)
We can use this attribute as a characteristic in the InfoCubes.
It always gives the fact value in reporting.
4. Time-Dependent Attribute
When we see the attribute value changing and if we want to maintain all the values of attribute with respect to different time interval we go for
All the Time-Dependent Attributes store in the /Q table
/Q table by default holds DATE-TO and DATE-FROM fields.
In /Q table DATE-TO field acts as a primary key.
We use DATE-TO field as key date in query property in the reporting.
5. Time-Dependent Navigational Attribute
It is a combination of Time-Dependent Attribute and Navigational Attribute.
6. Compound Attribute
In Compounding a Field or another Object is attached to an Info Object. A Compounding Characteristic is when object's definition is incomplete without the definition of the another Characteristic Info Object.
For the better understanding the Info Object - Location (0PP_LOCAT) has to be assigned with a Compound Info Object - Plant (0PLANT).
Here Plant(0PLANT) is the Superior Info Object of the Location(0PP_LOCAT)
The Info Object 0Plant has to be Installed/Created/ Activated first, later followed by Location(0PP_LOCAT)
While creating the Info Object itself we need to assign the Superior Object like below at Compounding Tab Page of Info Object.
All the depended objects we call it as Exclusive Attribute (If we take 0REGION as a navigation attribute , then 0COUNTRY will act as an exclusive attribute .)
We can use this attribute as a characteristic in the InfoCubes.
It always gives the fact value in reporting.
4. Time-Dependent Attribute
When we see the attribute value changing and if we want to maintain all the values of attribute with respect to different time interval we go for
All the Time-Dependent Attributes store in the /Q table
/Q table by default holds DATE-TO and DATE-FROM fields.
In /Q table DATE-TO field acts as a primary key.
We use DATE-TO field as key date in query property in the reporting.
5. Time-Dependent Navigational Attribute
It is a combination of Time-Dependent Attribute and Navigational Attribute.
6. Compound Attribute
In Compounding a Field or another Object is attached to an Info Object. A Compounding Characteristic is when object's definition is incomplete without the definition of the another Characteristic Info Object.
For the better understanding the Info Object - Location (0PP_LOCAT) has to be assigned with a Compound Info Object - Plant (0PLANT).
Here Plant(0PLANT) is the Superior Info Object of the Location(0PP_LOCAT)
The Info Object 0Plant has to be Installed/Created/ Activated first, later followed by Location(0PP_LOCAT)
While creating the Info Object itself we need to assign the Superior Object like below at Compounding Tab Page of Info Object.
Compounding Info Object Acts as a compounding Primary Key at the Master Data Table.
When a compounded Info object is included in an Info cube, all corresponding info objects are added to the Info cube.
If Location(0PP_LOCAT) is to be included in the Info Cube , Plant (0Plant) is automatically added to the Info Cube.
When a Compounded Info object is included in the DSO , all corresponding Objects are added to the DSO Key fields/Data Fields.
If Location(0PP_LOCAT) is to be included in the DSO , Plant (0Plant) is automatically added to the DSO.
If an info object is defined as an attribute, it cannot be included as compounding object.
The total length of the compounding info objects cannot exceed 60 characters.
An Info Object which is defined as an Attribute only setting cannot be included in Compounding object.
The Compounding Info Objects at BEx Report output will be 0PLANT/0PP_LOCAT.
If Location(0PP_LOCAT) is to be included in the Info Cube , Plant (0Plant) is automatically added to the Info Cube.
When a Compounded Info object is included in the DSO , all corresponding Objects are added to the DSO Key fields/Data Fields.
If Location(0PP_LOCAT) is to be included in the DSO , Plant (0Plant) is automatically added to the DSO.
If an info object is defined as an attribute, it cannot be included as compounding object.
The total length of the compounding info objects cannot exceed 60 characters.
An Info Object which is defined as an Attribute only setting cannot be included in Compounding object.
The Compounding Info Objects at BEx Report output will be 0PLANT/0PP_LOCAT.
7. Transitive Attribute
It is a second level of Navigational Attribute i.e. a Navigational attribute of a Navigational Attributes is called Transitive Attribute.
===============================================================
Attribute Only.
- It will act as an attribute only for ever.
- We can use the attribute only as a display attribute in reporting.
- We cannot use display attribute as a characteristic in the Info-Cube.
********************************