This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 85%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I have a cube, where most of the columns have been renamed...
The cube consumes from SQL Server, where columns have names like CustomerName, CustomerNo.
And then... in the cube it has been renamed to Customer.
Now, how can I know if the column Customer belongs to CustomerName or CustomerNo?
(actually I have tried myself renaming a column and there is no way of knowing to which source column it belongs).
(of course I am talking about tables with 50 columns where is not straight forward to map newname:oldname)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
You could find the Table and Column name for each attribute in SSDT property window, for example
:
Hi,
We did not hear from you back, have you resolved your issue?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 79%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBW%3C/text%3E%3C/svg%3E)
I know this is an old issue but I am having the exact same problem. The solution you proposed appears to be for SSAS multidimensional models. The original poster and I are looking for source-to-target column mappings for SSAS Tabular models. Do you know where they can be viewed/edited? I can see them in the Model.bim file but I don't see any UI in SSDT that allows me to see or edit them.
Now, how can I know if the column Customer belongs to CustomerName or CustomerNo?
In SSDT mark the attribute => Properties => KeyColumns, expand the node and you can see source table & column names.