How to see SSAS field source field

Question

In our Cube, a few fields have been renamed from what they come out of SQL as. Where can I see in VS what the original source field is?

how-to-see-source-column-names-in-vs-ssas-tabular.html seems to say I should be able to find it in the column properties, but this is all I see. Is there some setting or extension in VS I'm missing?

Answer 1

The answer in the other post you linked is not correct, it describes the approach for finding source column names in a multi-dimensional model (maybe the title of the post was edited after the first answer was posted)

I don't think VS currently exposes this information in it's UI so there are a number of work arounds.

1. You can right click on your .bim file and choose the "View Code" option. This will show you the json code for your model and this information is definitely available in there but you may need to do a bit of searching to find it.
2. You could open your .bim file with Tabular Editor (there are both free and paid versions of this excellent tool) as it exposes this property in its User Interface
3. You could connect to your workspace model using DAX Studio and run DMV queries to see this information

eg

SELECT [ID], [TableID], [ExplicitName], [SourceColumn]
FROM $SYSTEM.TMSCHEMA_COLUMNS

unfortunately the DMV syntax does not support joins so you might need to do a separate query against TMSCHEMA_TABLES to find the ID for the table you are interested in

Answer 2

Hi @William Moore ,

Welcome to Microsoft Q&A!

I edited a column name, and then check the column name in “Edit Table Properties”, it still shows the original one. Please check more detail information from this thread.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.