concat ID and Descr ??

concat ID and Descr ??

Post by elaka » Fri, 25 May 2001 05:09:35



Hi All,
I want to create a dimension which is concat of ID and its description.
These are two coulmns in the database table.

How do  i make such a dimension.

Thanks
Ela Kaus

 
 
 

concat ID and Descr ??

Post by Charles G » Fri, 25 May 2001 05:18:50


On Wed, 23 May 2001 22:09:35 +0200, elakaus wrote

Quote:> I want to create a dimension which is concat of ID and its description.
> These are two coulmns in the database table.

Use the following as the member name:

tablename.column1 + ' ' + tablename.column2

--
Charles G. * Madrid, Spain * "Intel inside, idiot outside."