question

WilliamMoore-6708 avatar image
0 Votes"
WilliamMoore-6708 asked WilliamMoore-6708 commented

How to see SSAS field source field

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?

128382-image.png


sql-server-analysis-services
image.png (65.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dgosbell avatar image
1 Vote"
dgosbell answered WilliamMoore-6708 commented

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



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks, I have used the DMV query in the past, but was hoping there'd be some solution within VS.

0 Votes 0 ·
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered WilliamMoore-6708 commented

Hi @WilliamMoore-6708,

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.
128379-column-name.png


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.



column-name.png (57.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This only works if only one column is renamed. If there are more than one, you'd have to make educated guesses which columns become which renamed columns.

0 Votes 0 ·