Analytics Extended Metadata (XMD) Developer Guide

Extended Metadata (XMD) Overview
Basic Structure of the XMD JSON File
Packaging Considerations for XMD
Configure the XMD for a Dataset
Format Dataset Fields and Field Values with XMD
Change Display Labels for Dataset Fields and Values
Hide Dataset Fields from the Explorer and Dashboard Designer
Format Measures
Multiply Measures by a Fixed Amount
Change the Label for the Row Count Measure
Change Chart Colors for Dimension Values
Add Actions to Dimensions
Change the Default Fields for a Values Table
Formatting the Results of a Query with Multiple Datasets
Extended Metadata (XMD) Reference
PDF

Newer Version Available

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

Hide Dataset Fields from the Explorer and Dashboard Designer

By default, all dataset fields are available in the UI. But you can hide fields so that users can’t select them when building queries and dashboards.

Although hidden fields aren’t available in the interface, users can still manually add them in dashboard JSON and SAQL queries. Users can also access the fields with the CRM Analytics REST API.

Note

For example, the Opportunity.StageName field appears in the explorer. When creating a grouping in explorer, you can see the Opportunity.StageName dataset field.

To hide the field, modify the XMD as shown in the bold text.
1"dimensions": [{
2		"field": "Opportunity.StageName",
3		"showInExplorer": false
4	}],

After applying the change, the field is no longer available for selection. The Opportunity.StageName dataset field is no longer available.