You need to sign in to do that
Don't have an account?
shashi kanaparthi
Found a Derived Dimension which has the same field name as a non-derived Dimension
Hi,
Getting the below error notification from wave when the data flow runs:
Found a Derived Dimension which has the same field name as a non-derived Dimension: CallDisc.Nephrologix_Subtopic__c
Below is the JSON which is being used:
{
"dataset": {},
"dates": [
{
"alias": "Date",
"fields": {
"day": "Call_Date_vod__c_Day",
"epochDay": "Call_Date_vod__c_day_epoch",
"epochSecond": "Call_Date_vod__c_sec_epoch",
"fullField": "Call_Date_vod__c",
"hour": "Call_Date_vod__c_Hour",
"minute": "Call_Date_vod__c_Minute",
"month": "Call_Date_vod__c_Month",
"quarter": "Call_Date_vod__c_Quarter",
"second": "Call_Date_vod__c_Second",
"week": "Call_Date_vod__c_Week",
"year": "Call_Date_vod__c_Year"
},
"firstDayOfWeek": -1,
"fiscalMonthOffset": 0,
"isYearEndFiscalYear": true,
"label": "Date",
"showInExplorer": true
}
],
"derivedDimensions": [
{
"customActions": [],
"customActionsEnabled": true,
"field": "CallDisc.Nephrologix_Subtopic__c",
"isMultiValue": false,
"label": "Nephrologix Subtopic",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true,
"showInExplorer": false
},
{
"customActions": [],
"customActionsEnabled": true,
"field": "ca",
"isMultiValue": false,
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true,
"showInExplorer": false
}
],
"derivedMeasures": [],
"dimensions": [
{
"customActions": [],
"field": "CallOwner.Name",
"label": "CallOwner.Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "CallOwner.Profile_Name_vod__c",
"label": "CallOwner.Profile_Name_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Type",
"label": "Account.Type",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Physician_Group_fmcna__c",
"label": "Account.Physician_Group_fmcna__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Second",
"label": "Call_Date_vod__c_Second",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Opportunity_fmcna__c",
"label": "Opportunity",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Completion_fmcna__c",
"label": "% Completion",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Status_vod__c",
"label": "Status",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.NPI_vod__c",
"label": "Account.NPI_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Owner_Name_fmcna__c",
"label": "Owner Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.HPSM_Owner__c",
"label": "Account.HPSM_Owner__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Name",
"label": "Call Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.DMD_Owner__c",
"label": "Account.DMD_Owner__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Id",
"label": "Account.Id",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "OwnerId",
"label": "Owner ID",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Primary_Address_State_fmcna__c",
"label": "Account.Primary_Address_State_fmcna__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Status_fmcna__c",
"label": "Account.Status_fmcna__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.AcctAffil.To_Account_vod__c",
"label": "Account.AcctAffil.To_Account_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.AcctAffil.To_Account_Name_vod__c",
"label": "Account.AcctAffil.To_Account_Name_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.AcctRecType.Name",
"label": "Account.AcctRecType.Name",
"linkTemplateEnabled": true,
"members": [
{
"label": "Hospital",
"member": "Hospital_vod"
},
{
"label": "Phys Group",
"member": "Practice_vod"
}
],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Hour",
"label": "Call_Date_vod__c_Hour",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account_vod__c",
"label": "Account",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "CallOwner.Title",
"label": "CallOwner.Title",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Director_of_Call_Owner__c",
"label": "Director of Call Owner",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "VP_of_Call_Owner__c",
"label": "VP of Call Owner",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Day",
"label": "Call_Date_vod__c_Day",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Specialty_1_vod__c",
"label": "Account.Specialty_1_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Week",
"label": "Call_Date_vod__c_Week",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "isAdmin",
"label": "isAdmin",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.VP_Owner__c",
"label": "Account.VP_Owner__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "CallDisc.Discussion_Topics__c",
"label": "Discussion Topics",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Year",
"label": "Call_Date_vod__c_Year",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Name",
"label": "Account.Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Quarter",
"label": "Call_Date_vod__c_Quarter",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Minute",
"label": "Call_Date_vod__c_Minute",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Id",
"label": "Record ID",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Credentials_vod__c",
"label": "Account.Credentials_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c",
"label": "Call_Date_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Month",
"label": "Call_Date_vod__c_Month",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
}
],
"organizations": [],
"showDetailsDefaultFields": []
}
Getting the below error notification from wave when the data flow runs:
Found a Derived Dimension which has the same field name as a non-derived Dimension: CallDisc.Nephrologix_Subtopic__c
Below is the JSON which is being used:
{
"dataset": {},
"dates": [
{
"alias": "Date",
"fields": {
"day": "Call_Date_vod__c_Day",
"epochDay": "Call_Date_vod__c_day_epoch",
"epochSecond": "Call_Date_vod__c_sec_epoch",
"fullField": "Call_Date_vod__c",
"hour": "Call_Date_vod__c_Hour",
"minute": "Call_Date_vod__c_Minute",
"month": "Call_Date_vod__c_Month",
"quarter": "Call_Date_vod__c_Quarter",
"second": "Call_Date_vod__c_Second",
"week": "Call_Date_vod__c_Week",
"year": "Call_Date_vod__c_Year"
},
"firstDayOfWeek": -1,
"fiscalMonthOffset": 0,
"isYearEndFiscalYear": true,
"label": "Date",
"showInExplorer": true
}
],
"derivedDimensions": [
{
"customActions": [],
"customActionsEnabled": true,
"field": "CallDisc.Nephrologix_Subtopic__c",
"isMultiValue": false,
"label": "Nephrologix Subtopic",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true,
"showInExplorer": false
},
{
"customActions": [],
"customActionsEnabled": true,
"field": "ca",
"isMultiValue": false,
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true,
"showInExplorer": false
}
],
"derivedMeasures": [],
"dimensions": [
{
"customActions": [],
"field": "CallOwner.Name",
"label": "CallOwner.Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "CallOwner.Profile_Name_vod__c",
"label": "CallOwner.Profile_Name_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Type",
"label": "Account.Type",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Physician_Group_fmcna__c",
"label": "Account.Physician_Group_fmcna__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Second",
"label": "Call_Date_vod__c_Second",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Opportunity_fmcna__c",
"label": "Opportunity",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Completion_fmcna__c",
"label": "% Completion",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Status_vod__c",
"label": "Status",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.NPI_vod__c",
"label": "Account.NPI_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Owner_Name_fmcna__c",
"label": "Owner Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.HPSM_Owner__c",
"label": "Account.HPSM_Owner__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Name",
"label": "Call Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.DMD_Owner__c",
"label": "Account.DMD_Owner__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Id",
"label": "Account.Id",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "OwnerId",
"label": "Owner ID",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Primary_Address_State_fmcna__c",
"label": "Account.Primary_Address_State_fmcna__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Status_fmcna__c",
"label": "Account.Status_fmcna__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.AcctAffil.To_Account_vod__c",
"label": "Account.AcctAffil.To_Account_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.AcctAffil.To_Account_Name_vod__c",
"label": "Account.AcctAffil.To_Account_Name_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.AcctRecType.Name",
"label": "Account.AcctRecType.Name",
"linkTemplateEnabled": true,
"members": [
{
"label": "Hospital",
"member": "Hospital_vod"
},
{
"label": "Phys Group",
"member": "Practice_vod"
}
],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Hour",
"label": "Call_Date_vod__c_Hour",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account_vod__c",
"label": "Account",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "CallOwner.Title",
"label": "CallOwner.Title",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Director_of_Call_Owner__c",
"label": "Director of Call Owner",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "VP_of_Call_Owner__c",
"label": "VP of Call Owner",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Day",
"label": "Call_Date_vod__c_Day",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Specialty_1_vod__c",
"label": "Account.Specialty_1_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Week",
"label": "Call_Date_vod__c_Week",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "isAdmin",
"label": "isAdmin",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.VP_Owner__c",
"label": "Account.VP_Owner__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "CallDisc.Discussion_Topics__c",
"label": "Discussion Topics",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Year",
"label": "Call_Date_vod__c_Year",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Name",
"label": "Account.Name",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Quarter",
"label": "Call_Date_vod__c_Quarter",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Minute",
"label": "Call_Date_vod__c_Minute",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Id",
"label": "Record ID",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Account.Credentials_vod__c",
"label": "Account.Credentials_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c",
"label": "Call_Date_vod__c",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
},
{
"customActions": [],
"field": "Call_Date_vod__c_Month",
"label": "Call_Date_vod__c_Month",
"linkTemplateEnabled": true,
"members": [],
"recordDisplayFields": [],
"salesforceActions": [],
"salesforceActionsEnabled": true
}
],
"organizations": [],
"showDetailsDefaultFields": []
}