Newer Version Available

This content describes an older version of this product. View Latest

XMD Resource

Returns the extended metadata (XMD) for a version of a dataset (GET) and replaces the user XMD file (PUT).
Resource URL
1/wave/datasets/<dataset ID>/versions/<version ID>/xmds/main
1/wave/datasets/<dataset ID>/versions/<version ID>/xmds/system
1/wave/datasets/<dataset ID>/versions/<version ID>/xmds/user

For full details on XMD, refer to the Analytics Extended Metadata (XMD) Reference.

Formats
JSON
Available Version
36.0
HTTP Methods
GET and PUT (on /wave/datasets/<dataset ID>/versions/<version ID>/xmds/user only)
GET Response Body
Property Name Type Description Filter Group and Version Available Version
createdBy Wave User The creator of the XMD. Small, 36.0 36.0
createdDate Date The time at which the XMD was created, in ISO8601 date format. Small, 36.0 36.0
dates XMD Date[] A list of dates with formatting information. Small, 36.0 36.0
derived​Dimensions XMD Dimension[] A list of derived dimensions with formatting information. Small, 36.0 36.0
derived​Measures XMD Measure[] List of derived measures with formatting information. Small, 36.0 36.0
dimensions XMD Dimension[] List of dimensions with formatting information. Small, 36.0 36.0
error​Message String Message if there was error copying forward the current version's user XMD to the newly created version. Small, 37.0 37.0
language String The language in which this XMD is localized. Values are:
  • bg: Bulgarian
  • zh_CN: Chinese ​Simplified
  • zh_TW: Chinese ​Traditional
  • hr: Croatian
  • cs: Czech
  • da: Danish
  • nl_NL: Dutch
  • en: English
  • en_GB: English ​(United Kingdom)
  • fi: Finnish
  • fr: French
  • de: German
  • el: Greek
  • hu: Hungarian
  • in: Indonesian
  • it: Italian
  • ja: Japanese
  • ko: Korean
  • no: Norwegian
  • pl: Polish
  • pt_PT: Portuguese ​(Portugal)
  • pt_BR: Portuguese ​(Brazil)
  • ro: Romanian
  • ru: Russian
  • sk: Slovak
  • sl: Slovenian
  • es: Spanish
  • es_MX: Spanish ​(Mexico)
  • sv: Swedish
  • th: Thai
  • tr: Turkish
  • uk: Ukrainian
  • vi: Vietnamese
Small, 36.0 36.0
last​Modified​By Wave User The user who last updated the XMD. Small, 36.0 36.0
last​Modified​Date Date The last time the XMD was modified, in ISO8601 date format. Small, 36.0 36.0
measures XMD Measure[] List of measures with formatting information. Small, 36.0 36.0
organizations XMD Organization[] List of organizations for multi-organization support. Small, 36.0 36.0
show​Details​Default​Fields String[] Ordered list of dimensions and measures. The list defines the default order in which to show the dimensions and measures in the user interface. Small, 36.0 36.0
type String The type of XMD. Values are:
  • main
  • system
  • user
Small, 36.0 36.0
url String The location where this XMD is stored. Small, 36.0 36.0
XMD Date
Property Name Type Description Filter Group and Version Available Version
alias String Alias of the Date column. Small, 36.0 36.0
fields XMD Date Field Formatting information for the date fields. Small, 36.0 36.0
firstDayOfWeek Integer What the first day of the week is. Small, 36.0 36.0
fiscalMonthOffset Integer Offset number of months for the fiscal year in relation to the calendar year. Small, 36.0 36.0
fullyQualifiedName String Fully qualified name of the date. Small, 39.0 39.0
label String Label of the Date column. Small, 36.0 36.0
XMD Date Field
Property Name Type Description Filter Group and Version Available Version
day String The day of the month. Small, 36.0 36.0
epoch​Day String Number of days that have elapsed since January 1, 1970 (midnight UTC). Small, 36.0 36.0
epoch​Second String Number of seconds that have elapsed since January 1, 1970 (midnight UTC). Corresponds to _sec_epoch in datasets. Small, 36.0 36.0
fiscal​Month String Month number in fiscal year. Corresponds to _Month_Fiscal in datasets. Small, 36.0 36.0
fiscal​Quarter String Quarter number in fiscal year. Corresponds to _Quarter_Fiscal in datasets. Small, 36.0 36.0
fiscal​Week String Week number in fiscal year. Corresponds to _Week_Fiscal in datasets. Small, 36.0 36.0
fiscal​Year String The Fiscal year. Corresponds to _Year_Fiscal in datasets. Small, 36.0 36.0
full​Field String The full-field field. Small, 36.0 36.0
hour String Number of hours. If the date contains no hours, value is '0.' Corresponds to _Hour in datasets. Small, 36.0 36.0
minute String Number of minutes. If the date contains no minutes, value is '0.' Corresponds to _Minute in datasets. Small, 36.0 36.0
month String Month number in calendar year. Corresponds to _Month is datasets. Small, 36.0 36.0
quarter String Quarter number in calendar year. Corresponds to _Quarter in datasets. Small, 36.0 36.0
second String Number of seconds. If the date contains no seconds, value is '0.' Corresponds to _Second in datasets. Small, 36.0 36.0
week String Week number in calendar year. Corresponds to _Week in datasets. Small, 36.0 36.0
year String The calendar year. Corresponds to _Year in datasets. Small, 36.0 36.0
XMD Dimension
Property Name Type Description Filter Group and Version Available Version
field String The field name of the dimension (used in queries). Small, 36.0 36.0
label String Display name for the dataset field. Can be up to 40 characters. Small, 36.0 36.0
link​Template String The URL to open when the user clicks the link in the actions menu. Overrides the default URL link, which is"/{{row.recordIdField}}". The default finds the Salesforce record with the record ID specified in the recordIdField XMD parameter. Must be 255 characters or less. To open a Salesforce recordfrom a multi-org environment, enter {{instanceUrl}} to populate the org URL specified in the“organizations” section of the XMD. Example: "/{{row.dimensionNameId}}". Small, 36.0 36.0
link​Template​Enabled Boolean Display the link to open a Salesforce record or URL. If set to false or not set, the menu doesn't display the Open Record link option. Small, 36.0 36.0
link​Tool​tip String The tooltip that a dashboard viewer sees when they hover over the link in an Analytics lens or dashboard. Small, 36.0 36.0
members XMD Dimension Member[] Customizations for specific values of the dataset fields. For example, for the "Country" field, change the label of the "USA" to "United States." And change the color for this value in a chart to blue.

When you change the label, the new label only appears in the user interface. You can’t use the label in queries, like a query filter. For this, the best practice is to modify the field values when you create the dataset.

Note

Small, 36.0 36.0
record​Display​Fields String[] Ordered list of dimensions and measures. These dataset fields are used to help a dashboard viewer identify a Salesforce record when multiple records match the action. For each field, specify its API name. In some instances, a dimension value is associated with multiple IDs and isn’t unique. For example, an opportunity with the name “acme” has multiple opportunity IDs (and records). But the action or link can only be directed to one record. Small, 36.0 36.0
record​Id​Field String The dataset field that contains the record ID of the Salesforce object that you want to perform the action on. Small, 36.0 36.0
record​Organization​Id​Field String The record organization ID for this dimension. Small, 36.0 36.0
salesforce​Actions XMD Dimension Salesforce Action[] Actions that appear in the action menu. You can only add actions that are defined in the page layouts for the corresponding Salesforce object. If left blank, Analytics shows all actions. Small, 36.0 36.0
salesforce​Actions​Enabled Boolean Enables a Salesforce actions menu to appear on the field. If set to false or not set, the menu doesn't display any actions. Small, 36.0 36.0
show​In​Explorer Boolean Determines whether the dataset field can be selected from the dashboard designer or explorer when creating dashboards and lenses. Even if showInExplorer is false, the field can still be used for SAQL queries, manually added in JSON, and accessed using the Analytics REST API. Small, 36.0 36.0
XMD Dimension Member
Property Name Type Description Filter Group and Version Available Version
color String The color for the member. For example, set to “Blue”. Small, 36.0 36.0
label String The label for the member. For example, set to “United States”. Small, 36.0 36.0
member String The member value. For example, set to “USA”. Small, 36.0 36.0
XMD Dimension Salesforce Action
Property Name Type Description Filter Group and Version Available Version
enabled Boolean Indicates whether the action is enabled for a specific dimension. Small, 36.0 36.0
name String The name of the action. Small, 36.0 36.0
XMD Measure
Property Name Type Description Filter Group and Version Available Version
field String Identifier (API name) for the dataset field. Small, 36.0 36.0
format XMD Measure Format The format details for the measure. Small, 36.0 36.0
label String Display name for the dataset field. Can be up to 40 characters. For example, “Sales Amount". Small, 36.0 36.0
show​In​Explorer Boolean Determines whether the dataset field can be selected from the dashboard designer or explorer when creating dashboards and lenses. Even if showInExplorer is false, the field can still be used for SAQL queries, manually added in JSON, and accessed using the Analytics REST API. Small, 36.0 36.0
XMD Measure Format
Property Name Type Description Filter Group and Version Available Version
custom​Format String When customizing the display, you can add a prefix, suffix, grouping separator, decimal separator, and leading and trailing zeros. You can also configure the number of digits. You can include any characters in prefixes and suffixes, including minus signs or currency symbols. You can use the following symbols to specifying a format.
  • 0. One digit. Use to add leading or trailing 0s. For example, if you apply custom format #,###.00 to 56375, the result is 56,375.00.
  • #. Adds zero or one digit. Use to show digits when applicable. For example, if you apply custom format #,###.## to 56375.56, the result is 56,375.56.
  • .(period). Symbol used as the decimal separator, like in the number 375.56. Analytics currently only supports the decimal symbol (.) as a decimal separator.
  • ,(comma). Symbol used as the grouping separator, like in 56,375. Analytics currently only supports the comma symbol (,) as a grouping separator. Example: [\"-$#,###.00$\",1]
Small, 36.0 36.0
unit​Multiplier Double The multiplier for the unit. The multiplier changes a field’s values by the same factor—like multiplying by 100 to convert decimals to percents.The multiplier must be a positive number. Small, 36.0 36.0
XMD Organization
Property Name Type Description Filter Group and Version Available Version
id String The ID of the organization. Small, 36.0 36.0
instance​Url String URL of the Salesforce org. If a custom domain name is set up for the org, it’s the domain name for the org. Small, 36.0 36.0
label String Display name for the Salesforce org. Can be up to 40 characters. Small, 36.0 36.0
PUT Request Body
Property Name Type Description Required or Optional Available Version
dataset Xmd​Dataset​Input​Representation Locale-specific information about the Dataset represented by this XMD. 36.0
dates Xmd​Date​Input​Representation[] List of dates with formatting information. 36.0
derived​Dimensions Xmd​Derived​Dimension​Input​Representation[] List of derived dimensions with formatting information. 36.0
derived​Measures Xmd​Derived​Measure​Input​Representation[] List of derived measures with formatting information. 36.0
dimensions Xmd​Dimension​Input​Representation[] List of dimensions with formatting information. 36.0
measures Xmd​Measure​Input​Representation[] List of measures with formatting information. 36.0
organizations Xmd​Organization​Input​Representation[] List of organizations for multi-organization support. 36.0
show​Details​Default​Fields String[] Ordered list of Dimensions and Measures. Represents the default order to show them in the UI. 36.0
XmdDatasetInputRepresentation
Property Name Type Description Required or Optional Available Version
connector String Connector source for the dataset. 36.0
description String Description of the dataset. 36.0
fully​Qualified​Name String Fully qualified name of the dataset version. 36.0
origin String Origin representing where this dataset version comes from. 36.0
XmdDateInputRepresentation
Property Name Type Description Required or Optional Available Version
alias String Alias of the Date column. 36.0
fields Xmd​Date​Fields​Input​Representation Formatting information for the date fields. 36.0
first​Day​Of​Week Integer What the first day of the week is. 36.0
fiscal​Month​Offset Integer Offset number of months for the fiscal year in relation to the calendar year. 36.0
fully​Qualified​Name String Fully qualified name of the date. 39.0
label String Label of the Date column. 36.0
XmdDateFieldsInputRepresentation
Property Name Type Description Required or Optional Available Version
day String The day of the month. 36.0
epochDay String Number of days that have elapsed since January 1, 1970 (midnight UTC). 36.0
epochSecond String Number of seconds that have elapsed since January 1, 1970 (midnight UTC). Corresponds to _sec_epoch in datasets. 36.0
fiscalMonth String Month number in fiscal year. Corresponds to _Month_Fiscal in datasets. 36.0
fiscalQuarter String Quarter number in fiscal year. Corresponds to _Quarter_Fiscal in datasets. 36.0
fiscalWeek String Week number in fiscal year. Corresponds to _Week_Fiscal in datasets. 36.0
fiscalYear String The Fiscal year. Corresponds to _Year_Fiscal in datasets. 36.0
fullField String fullField field. 36.0
hour String Number of hours. If the date contains no hours, value is '0.' Corresponds to _Hour in datasets. 36.0
minute String Number of minutes. If the date contains no minutes, value is '0.' Corresponds to _Minute in datasets. 36.0
month String Month number in calendar year. Corresponds to _Month is datasets. 36.0
quarter String Quarter number in calendar year. Corresponds to _Quarter in datasets. 36.0
second String Number of seconds. If the date contains no seconds, value is '0.' Corresponds to _Second in datasets. 36.0
week String Week number in calendar year. Corresponds to _Week in datasets. 36.0
year String The calendar year. Corresponds to _Year in datasets. 36.0
XmdDerivedDimensionInputRepresentation
Property Name Type Description Required or Optional Available Version
members Xmd​Derived​Dimension​Member​Input​Representation[] Customizations for specific values of the dataset fields. For example, change the color for this value in a chart to blue.

When you change the label, the new label only appears in the user interface. You can’t use the label in queries, like a query filter. For this, the best practice is to modify the field values when you create the dataset.

Note

36.0
salesforce​Actions Xmd​Derived​Dimension​Salesforce​Action​Input​Representation[] Actions that appear in the action menu. You can only add actions that are defined in the page layouts for the corresponding Salesforce object. If left blank, Analytics shows all actions. 36.0
XmdDerivedDimensionMemberInputRepresentation
Property Name Type Description Required or Optional Available Version
color String The color for the member. For example, set to “Blue”. 36.0
label String The label for the member. For example, set to “United States”. 36.0
member String The member value. For example, set to “USA”. 36.0
XmdDerivedDimensionSalesforceActionInputRepresentation
Property Name Type Description Required or Optional Available Version
enabled Boolean Indicates whether the action is enabled for a specific dimension. 36.0
name String The name of the action. 36.0
XmdDerivedMeasureInputRepresentation
Property Name Type Description Required or Optional Available Version
format Xmd​Derived​Measure​Format​Input​Representation Format details for the Derived Measure. 36.0
field String Identifier (API name) for the dataset field. 36.0
label String Display name for the dataset field. Can be up to 40 characters. For example, “Sales Amount". 36.0
show​In​Explorer Boolean Determines whether the dataset field can be selected from the dashboard designer or explorer when creating dashboards and lenses. Even if showInExplorer is false, the field can still be used for SAQL queries, manually added in JSON, and accessed using the Analytics REST API. 36.0
XmdDerivedMeasureFormatInputRepresentation
Property Name Type Description Required or Optional Available Version
custom​Format String When customizing the display, you can add a prefix, suffix, grouping separator, decimal separator, and leading and trailing zeros. You can also configure the number of digits. You can include any characters in prefixes and suffixes, including minus signs or currency symbols. You can use the following symbols to specifying a format.
  • 0. One digit. Use to add leading or trailing 0s. For example, if you apply custom format #,###.00 to 56375, the result is 56,375.00.
  • #. Adds zero or one digit. Use to show digits when applicable. For example, if you apply custom format #,###.## to 56375.56, the result is 56,375.56.
  • .(period). Symbol used as the decimal separator, like in the number 375.56. Analytics currently only supports the decimal symbol (.) as a decimal separator.
  • ,(comma). Symbol used as the grouping separator, like in 56,375. Analytics currently only supports the comma symbol (,) as a grouping separator. Example: [\"-$#,###.00$\",1]
38.0
unit​Multiplier Double The multiplier for the unit. The multiplier changes a field’s values by the same factor—like multiplying by 100 to convert decimals to percents.The multiplier must be a positive number. 36.0
XmdDimensionMemberInputRepresentation
Property Name Type Description Required or Optional Available Version
color String The color for the member. For example, set to “Blue”. 36.0
label String The label for the member. For example, set to “United States”. 36.0
member String The member value. For example, set to “USA”. 36.0
XmdDimensionSalesforceActionInputRepresentation
Property Name Type Description Required or Optional Available Version
enabled Boolean Indicates whether the action is enabled for a specific dimension. 36.0
name String The name of the action. 36.0
XmdDimensionInputRepresentation
Property Name Type Description Required or Optional Available Version
field String The field name of the dimension (used in queries). 36.0
label String Display name for the dataset field. Can be up to 40 characters. 36.0
linkTemplate String The URL to open when the user clicks the link in the actions menu. Overrides the default URL link, which is"/{{row.recordIdField}}". The default finds the Salesforce record with the record ID specified in the recordIdField XMD parameter. Must be 255 characters or less. To open a Salesforce recordfrom a multi-org environment, enter {{instanceUrl}} to populate the org URL specified in the“organizations” section of the XMD. Example: "/{{row.dimensionNameId}}". 36.0
link​Template​Enabled Boolean Display the link to open a Salesforce record or URL. If set to false or not set, the menu doesn't display the Open Record link option. 36.0
linkTooltip String The tooltip that a dashboard viewer sees when they hover over the link in an Analytics lens or dashboard. 36.0
members Xmd​Dimension​Member​Input​Representation[] Customizations for specific values of the dataset fields. For example, for the "Country" field, change the label of the "USA" to "United States." And change the color for this value in a chart to blue.

When you change the label, the new label only appears in the user interface. You can’t use the label in queries, like a query filter. For this, the best practice is to modify the field values when you create the dataset.

Note

36.0
record​Display​Fields String[] Ordered list of dimensions and measures. These dataset fields are used to help a dashboard viewer identify a Salesforce record when multiple records match the action. For each field, specify its API name. In some instances, a dimension value is associated with multiple IDs and isn’t unique. For example, an opportunity with the name “acme” has multiple opportunity IDs (and records). But the action or link can only be directed to one record. 36.0
record​Id​Field String The dataset field that contains the record ID of the Salesforce object that you want to perform the action on. 36.0
record​Organization​Id​Field String The record organization ID for this dimension. 36.0
salesforce​Actions Xmd​Dimension​Salesforce​Action​Input​Representation[] Actions that appear in the action menu. You can only add actions that are defined in the page layouts for the corresponding Salesforce object. If left blank, Analytics shows all actions. 36.0
salesforce​Actions​Enabled Boolean Enables a Salesforce actions menu to appear on the field. If set to false or not set, the menu doesn't display any actions. 36.0
show​In​Explorer Boolean Determines whether the dataset field can be selected from the dashboard designer or explorer when creating dashboards and lenses. Even if showInExplorer is false, the field can still be used for SAQL queries, manually added in JSON, and accessed using the Analytics REST API. 36.0
XmdMeasureInputRepresentation
Property Name Type Description Required or Optional Available Version
format Xmd​Measure​Format​Input​Representation Format details for the Measure. 36.0
field String Identifier (API name) for the dataset field. 36.0
label String Display name for the dataset field. Can be up to 40 characters. For example, “Sales Amount". 36.0
show​In​Explorer Boolean Determines whether the dataset field can be selected from the dashboard designer or explorer when creating dashboards and lenses. Even if showInExplorer is false, the field can still be used for SAQL queries, manually added in JSON, and accessed using the Analytics REST API. 36.0
XmdMeasureFormatInputRepresentation
Property Name Type Description Required or Optional Available Version
custom​Format String When customizing the display, you can add a prefix, suffix, grouping separator, decimal separator, and leading and trailing zeros. You can also configure the number of digits. You can include any characters in prefixes and suffixes, including minus signs or currency symbols. You can use the following symbols to specifying a format.
  • 0. One digit. Use to add leading or trailing 0s. For example, if you apply custom format #,###.00 to 56375, the result is 56,375.00.
  • #. Adds zero or one digit. Use to show digits when applicable. For example, if you apply custom format #,###.## to 56375.56, the result is 56,375.56.
  • .(period). Symbol used as the decimal separator, like in the number 375.56. Analytics currently only supports the decimal symbol (.) as a decimal separator.
  • ,(comma). Symbol used as the grouping separator, like in 56,375. Analytics currently only supports the comma symbol (,) as a grouping separator. Example: [\"-$#,###.00$\",1]
38.0
unit​Multiplier Double The multiplier for the unit. The multiplier changes a field’s values by the same factor—like multiplying by 100 to convert decimals to percents.The multiplier must be a positive number. 36.0
XmdOrganizationInputRepresentation
Property Name Type Description Required or Optional Available Version
id ID The ID of the organization. 36.0
instance​Url String URL of the Salesforce org. If a custom domain name is set up for the org, it’s the domain name for the org. 36.0
label String Display name for the Salesforce org. Can be up to 40 characters. 36.0