Attributes are individual non-measurable analytical elements. Attributes
add context to data. These are qualitative descriptive data similiar to
Characteristics of SAP BW. For example, MATERIAL_NAME. There are three types of Attributes in Information Modeling:
- Simple Attributes are individual non-measurable analytical
elements that are derived from the data foundation. For example,
MATERIAL_ID and MATERIAL_NAME are attributes of a MATERIAL subject area.
- Calculated Attributes are derived from one or more
existing attributes or constants. The attribute is based on static value
or dynamic calculation. For example, extracting the year part from the
customer registration date, assigning a constant value to an attribute
which can be used for arithmetic calculations.
- Private Attributes are used to model Analytic Views and
cannot be used outside the view. Private attributes add more
information to the data model. Private attributes of Fact tables are
used to link to the subject area or dimensions i.e. Attribute Views. For
example, we create an analytic view ANV_SALES to analyze the sales of
materials, and select MATERIAL_ID as a private attribute from the
database table SALES_ITEM. In this case, MATERIAL_ID could be used only
for modeling data for ANV_SALES. We will learn about private attributes
later when we will design Analytic Views.
No comments:
Post a Comment