Specify Semantic Types for Measures and Attributes

Specify semantic types to identify the type of data in your columns (measures and attributes). Semantic types include values, quantities, dates, and geo and textual information.

Specify Semantic Types

Semantic types are only available for measures and attributes in entities with a Semantic Usage of Fact, Dimension or Text.

To specify a semantic type, hover over the attribute or measure, and click (Menu)Start of the navigation path Next navigation step  Semantic Type Next navigation step <Type>End of the navigation path.

Amount and Quantity Measures

These types identify the type of value that the measure contains:

Name

Description

Amount with Currency

Specifies that the measure contains a monetary amount. You should additionally select an attribute with the semantic type Currency Code in the Unit Column column (see Currency Code and Unit of Measure Attributes).

Quantity with Unit

Specifies that the measure contains a quantity of some kind. You should additionally select an attribute with the semantic type Unit of Measure in the Unit Column column (see Currency Code and Unit of Measure Attributes).

Currency Code and Unit of Measure Attributes

These types are used with measure types (see Currency Code and Unit of Measure Attributes) to identify the currency or unit contained in the measure:

Name

Description

Currency Code

A currency code.

This can be either an ISO codeInformation published on non-SAP site or an SAP currency code (data type CUKY).

Unit of Measure

A unit of measure.

Language and Text Attributes

These types are typically used in text entities and identify columns containing language codes and strings in the selected language

Name

Description

Language

A language code.

Text

A human-readable text that is not necessarily language-dependent.

Image URL Attributes

This type identifies attributes containing URLs to image files:

Name

Description

Image URL

A URL pointing to an image file. The image will be displayed when the attribute is shown in an SAP Analytics Cloud table.

Geolocation Attributes

These types identify attributes containing latitudes, longitudes, and other geolocation information:

Name

Description

Geolocation - Cartoid

A geographical point.

Geolocation - Latitude

A latitude value for a city or other geographical point.

Geolocation - Longitude

A longitude value for a city or other geographical point.

Geolocation - Normalized Name

A readable name for a city or other geographical point.

Responsible User Attributes

This type identifies the user responsible for maintaining a dimension member or other record:

Name

Description

Responsible

The user ID of the user responsible for the record.

Fiscal Time Attributes

These types identify attributes containing fiscal periods for use in fiscal time dimensions (see Create a Fiscal Time Dimension:

Name

Description

Fiscal - Year

A fiscal year number as a string consisting of four digits in the form YYYY .

Fiscal - Period

A fiscal period as a string consisting of three digits in the form PPP. The fiscal period can represent a quarter, a month, a week, a day, or any other portion of a fiscal year.

Fiscal - Year Period

A fiscal year and period as a string consisting of seven digits in the form YYYYPPP.

Fiscal - Year Variant

A fiscal year variant identifier, which is used to identify all periods in the given variant, typically consisting of two characters in the form VV.

Fiscal - Quarter

A fiscal quarter number as a string consisting of one digit in the form Q.

Fiscal - Year Quarter

A fiscal year quarter number as a string consisting of five digits in the form YYYYQ.

Fiscal - Year Week

A fiscal year week number as a string consisting of six digits in the form YYYYWW.

Business Date Attributes

These types identify attributes containing dates for which information is being requested or is valid:

Name

Description

Business Date - At

A key date. The column must have a Date data type or be a string in one of the following formats: YYYYMMDD, YYYY-MM-DD, YYYY.MM.DD, or YYYY/MM/DD.

Business Date - From

A date or timestamp that defines the start date for validity of the data of the database table record from a business point of view. The column must have a Date data type or be a string in one of the following formats: YYYYMMDD, YYYY-MM-DD, YYYY.MM.DD, or YYYY/MM/DD.

To represent the date when the record was created, use System Date - Created at instead.

Business Date - To

A date or timestamp that defines the end date for validity of the data of the database table record from a business point of view. The column must have a Date data type or be a string in one of the following formats: YYYYMMDD, YYYY-MM-DD, YYYY.MM.DD, or YYYY/MM/DD.

Calendar and System Date Attributes

These types identify attributes containing calendar or system dates:

Name

Description

Calendar - Date

A date. The column must have a Date data type or be a string in one of the following formats: YYYYMMDD, YYYY-MM-DD, YYYY.MM.DD, or YYYY/MM/DD.

The number must be in the range 1 - 31.

Calendar - Day of Month

A day number relative to a calendar month.

The number must be in the range 1 - 31.

Calendar - Day of Year

A day number relative to a calendar year.

The number must be in the range 1 - 366.

Calendar - Week

A calendar week number as a string following the logical pattern WW consisting of two digits.

The string must match the regex pattern 0[1-9]|[1-4][0-9]|5[2-3].

Calendar - Month

A calendar month number as a string following the logical pattern MM consisting of two digits.

The string must match the regex pattern 0[1-9]|1[0-2].

Calendar - Quarter

A calendar quarter number as a string following the logical pattern Q consisting of a single digit.

The string must match the regex pattern [1-4].

Calendar - Half Year

A calendar half year number as a string following the logical pattern H consisting of a single digit.

The string must match the regex pattern [1-2].

Calendar - Year

A year number as a string following the logical pattern (-?)YYYY(Y*) consisting of an optional minus sign for years B.C., followed by at least four digits.

The string must match the regex pattern -?([1-9][0-9]{3,}|0[0-9]{3}).

Calendar - Year Week

A calendar year and week as a string following the logical pattern (-?)YYYY(Y*)WW consisting of an optional minus sign for years B.C., followed by at least six digits, where the last two digits represent week number in the year.

The string must match the regex pattern -?([1-9][0-9]{3,}|0[0-9]{3})(0[1-9]|[1-4][0-9]|5[2-3]).

Calendar - Year Month

A calendar year and month as a string following the logical pattern (-?)YYYY(Y*)MM consisting of an optional minus sign for years B.C., followed by at least six digits, where the last two digits represent the months January to December.

The string must match the regex pattern -?([1-9][0-9]{3,}|0[0-9]{3})(0[1-9]|1[0-2]).

Calendar - Year Quarter

A calendar year and quarter as a string following the logical pattern (-?)YYYY(Y*)Q consisting of an optional minus sign for years B.C., followed by at least five digits, where the last digit represents the quarter.

The string must match the regex pattern -?([1-9][0-9]{3,}|0[0-9]{3})[1-4].

Calendar - Year Half Year

A calendar half year number as a string following the logical pattern (-?)YYYY(Y*)H consisting of an optional minus sign for years B.C., followed by at least five digits, where the last digit represents the half year.

The string must match the regex pattern -?([1-9][0-9]{3,}|0[0-9]{3})[1-2].

System Date - Created at

A timestamp for when the database record was created.

System Date - Last changed at

A timestamp for when the database record was last changed.