Hi Mauricio,
That field can come from different tables depending on the type of the dimension.
For example, for a custom dimension it comes from the Description field of the DimensionFinancialTag table.
The source table and field are determined on the DimensionAttribute table, the field BackingEntityType holds the the source TableId and the NameAttribute holds the source FieldId.
You can verify that by checking the DimensionValueDetails form init() method.
To find all tables and fields that populate that field, you can run the following query:
SELECT
BACKINGENTITYTYPE AS TABLEID,
NAMEATTRIBUTE AS FIELDID,
(SELECT TOP 1 NAME FROM SQLDICTIONARY WHERE TABLEID = BACKINGENTITYTYPE AND FIELDID = 0 AND SQLNAME <> '<source table>') AS TABLENAME,
(SELECT TOP 1 NAME FROM SQLDICTIONARY WHERE TABLEID = BACKINGENTITYTYPE AND FIELDID = NAMEATTRIBUTE AND SQLNAME <> '<source table>') AS FIELDNAME
FROM DIMENSIONATTRIBUTE
GROUP BY BACKINGENTITYTYPE, NAMEATTRIBUTE
In my environment it returned this results:
