Print this page

Lens error "Cannot project to value more than once" on Raw Data Table in Wave Analytics

Knowledge Article Number 000233336
Description When creating a lens with the raw data table view, the below error may be seen for one or more fields:
 
Cannot project to value 'Field Name' more than once

This indicates that the field is being specified in multiple contradictory locations in the dataset's XMD file.
Resolution To resolve, open the dataset's XMD file and ensure that the field is only included in the appropriate "labels" section, depending on if the field is a measure or dimension.

For example, if your XMD reads as follows:
 
{
  "labels": {
    "measures": {
      "Field_Name__c": "Field Name"
      "Measure_Name": "Measure"
    },
    "dimensions": {
      "Field_Name__c": "Field Name",
      "Dimension_Name": "Dimension"
    }
  }
}



You would need to change it to the below JSON instead:
 
{
  "labels": {
    "measures": {
      "Field_Name__c": "Field Name"
      "Measure_Name": "Measure"
    },
    "dimensions": {
      "Dimension_Name": "Dimension"
    }
  }
}




For more details on how the XMD should be formatted, please review the Wave Analytics Extended Metadata (XMD) Reference




promote demote