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 .
Amount and Quantity Measures
|
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
|
Name |
Description |
|---|---|
|
Currency Code |
A currency code. This can be either an ISO code |
|
Unit of Measure |
A unit of measure. |
Language and Text Attributes
|
Name |
Description |
|---|---|
|
Language |
A language code. |
|
Text |
A human-readable text that is not necessarily language-dependent. |
Image URL Attributes
|
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
|
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
|
Name |
Description |
|---|---|
|
Responsible |
The user ID of the user responsible for the record. |
Fiscal Time Attributes
|
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
|
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
|
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. |

