Ansicht
Dokumentation

ABENCDS_MEASURE_DIMENSION_APV - CDS MEASURE DIMENSION APV

Vendor Master (General Section)   General Material Data  
This documentation is copyright by SAP AG.

- Conceptual Background, Analytical Query

This topic explains some conceptual background of analytical data models.

Analytical Cube View

A CDS analytical projection view must always be based on an analytical cube view. The fields of an analytical cube view are interpreted as analytical measures and analytical dimensions.

• Analytical dimension:

Field of an analytical cube view that describes a characteristic of the view's subject and that can be used for grouping or filtering. For example if a view describes a sales order, the following columns can be dimensions: customer, date, region. Dimensions can have a foreign key association to a dimension view.

A dimension must have one of the following data types: CHAR, NUMC, DATS, TIMS, INT1, INT2, INT4, INT8, DATN, TIMN, UNIT, CUKY, LANG, CLNT, SSTR, RAW(16), UTCLONG.

• Analytical measure:

Field of an analytical cube view that contains measurable data. In other words, an analytical measure can be any element that contains quantifiable data that can be calculated and aggregated, for example, the total price of all sales order positions. The aggregation behavior is defined via the annotation @Aggregation.default. Measures can have a reference to a unit key or currency key. The following data types are possible: DEC, CURR, QUAN, DECFLOAT16, DECFLOAT34, FLTP, DATS, DATN, TIMS, TIMN, INT1, INT2, INT4, INT8, DF16_DEC, DF34_DEC, DF16_RAW.

Analytical Query

The fields of a CDS analytical projection view can be classified into the following categories:

• Analytical formula:

Field of a CDS analytical projection view that is newly added in the projection layer. A formula can be an arithmetic expression, a currency conversion using the built-in function CURRENCY_CONVERSION, or a formula-related case expression. The annotation Aggregation.default: #FORMULA is mandatory.

• Analytical selection:

Field of a CDS analytical projection view that is newly added in the projection layer. A selection is defined by means of a selection-related case expression, also called restricted measure.

• Dimension: field of an analytical projection view that is defined as dimension in the underlying cube view.

• Text fields and attributes relating to a dimension. Such fields are included via path expressions.

• CDS amount fields, CDS quantity fields, currency key fields, unit key fields.
  
  

General Material Data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 9175 Date: 20240511 Time: 092417     sap01-206 ( 86 ms )