Forum Discussion
Values in dropdown menu in the data source, unable to match name = value in data model
In CRM to identify the values, you need to go to Settings | Customizations and then Customize the System. This will bring up a window and then you will need to go look at the correct entity and look at the field or option set definition. There you will find out what numbers mean what.
Community ChampionSo, this is what is known as an Option Set in Dynamics. Is this a default field or a custom field? I used to have a listing of all of the default Dynamics Option Set values for just this reason. Basically, you need to go in to Customize the system and take a look at the Option Set definitions in order to determine which values goes with what. Then you need to use an Enter Data query to create a dimension table and link it to your fact table.
That specific field is a custom field.
By creating the dimension table i need to re-build the whole structure off dozens of dropdown menus - is that the only way?
Where do i find the Options set settings exactly as i´m not the main administrator of Dynamics.
Thanks for your help Greg.
Best
- Greg_Deckler
Another way would be to do find and replace in Query Editor.
Is this Dynamics CRM or Dynamics for Finance and Operations or another flavor of Dynamics?
Thats a Dynamics 365 CRM instance.
But Find & Replace would mean to do the command for each line and for each new line.
---
I´m wondering if our case is solely unique to other Dynamics instances?
Any other idea how to get the names for the categories/values?