 Rank: Advanced Member
Groups: extranet\Forum
Joined: 11/2/2015(UTC)
Posts: 14
|
Hi Using the ODBC-data source you will get the fieldname from the database table as fieldname :-) This is fine if you are a developer or a DB-admin, but being a 'simple' user, this is not good :-( That is why I am looking for a way to define a user-friendly fieldname on the data source (preferably) or on the cube. Is this possible ? Best regards Torben Fensmark Edited by user Tuesday, November 17, 2015 7:47:54 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
 Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
Hi Torben It is possible to assign a "read-friendly" name via aliasing in T-SQL. Basically aliases can be created to make column names more readable. The SQL script can e.g. be entered in the "SQL Command" input field in the SQL Server Datasource dialog in TARGIT Data Service. In the screenshot below, the Id column is renamed ID_Alias.  Another example is that you want to rename the colum firstname to CoustomerFirstName. An alias example could be renaming the firstname to CoustomerFirstName. SELECT Firstname as CustomerFirstName FROM xxyyzz Note the reserved word as is optional. |
Best regards
Páll, CTS |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 11/2/2015(UTC)
Posts: 14
|
Hi Páll
Thanks for a very understandable answer - even for someone who is not too sharp in SQL.
I can use this answer.
Best Regards
Torben
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.