How to see SSAS field source field

William Moore 21 Reputation points
2021-09-01T17:31:43.01+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
0 comments No comments
{count} votes

Accepted answer
  1. Darren Gosbell 2,376 Reputation points
    2021-09-01T23:04:23.29+00:00

    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 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-09-02T02:22:07.563+00:00

    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.
    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.