question

mq-7327 avatar image
0 Votes"
mq-7327 asked LukasYu-msft commented

How to see source column names in VS? (SSAS tabular)

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)


sql-server-analysis-services
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.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.



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.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

You could find the Table and Column name for each attribute in SSDT property window, for example

:88926-image.png



image.png (133.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.

Hi,

We did not hear from you back, have you resolved your issue?

0 Votes 0 ·