en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Torben Fensmark  
#1 Posted : Tuesday, November 17, 2015 7:34:19 AM(UTC)
Torben Fensmark
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

Páll Bjarkason  
#2 Posted : Wednesday, November 18, 2015 10:17:26 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

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.

UserPostedImage


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
Torben Fensmark  
#3 Posted : Wednesday, November 18, 2015 1:36:17 PM(UTC)
Torben Fensmark
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
Users browsing this topic
Anonymous
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.

Notification

Icon
Error