Where is source column in SSAS in visual studio?

Question

I am working in SSAS in a cube. For a specific table with over 100 columns, most of the columns are renamed… How can I know the source column in the SQL table?

I guess this shall be in the properties, but strangely enough, I can’t find it in the properties:

Where is this information located?

Answer 1

Hi @Fra1978 ,

It seems that you are using SSAS tabular.

Please follow below steps to check the columns.

Regards，

Zoe

---

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.
Hot issues October

Answer 2

As @ZoeHui-MSFT has mentioned in VS you have to use the view code option to see this.

The other option is to use Tabular Editor instead of Visual Studio as this shows you this information as a normal property.

Or you could use DAX Studio to run a query like the following against your workspace model

select [TableID], [ExplicitName], [SourceColumn]
from $system.TMSCHEMA_COLUMNS
where [Type] = 1

Unfortunately the DMV query language (DMX) does not support joins so you would have to manually run a SELECT * from $SYSTEM.TMSCHEMA_TABLES and then use something like vlookups in Excel to match the table ID to table names

Answer 3

You can find the information in dimension - attribute proterties => KeyColumns => Source