How do I convert an id to a text dimension in analysis 2005

#1

In analysis services 2000 I used to create dimensions off a singe
column in the fact table(id, etc) and I would use a case statement for
the column name property like WHEN (fact.id) = 1 THEN True, Else,
False, etc. This way I didn't really have to create a new dimension
table, etc. I have just started playing around with 2005 and I have
not seen where I can do this. I saw where I could show a different
column name in the properties, but it would not let me type in any
condition, etc. What is the best way to do this in 2005?

Thanks!

#2

mitchchristensen (AT) gmail (DOT) com wrote:

Quote:

In analysis services 2000 I used to create dimensions off a singe
column in the fact table(id, etc) and I would use a case statement for
the column name property like WHEN (fact.id) = 1 THEN True, Else,
False, etc. This way I didn't really have to create a new dimension
table, etc. I have just started playing around with 2005 and I have
not seen where I can do this. I saw where I could show a different
column name in the properties, but it would not let me type in any
condition, etc. What is the best way to do this in 2005?

Thanks!

In DSV you can create named calculation and you can set that column as
name column.

Regards
Amish Shah
http://shahamishm.tripod.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I convert an id to a text dimension in analysis 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How do I convert an id to a text dimension in analysis 2005 - 10-06-2006 , 01:10 AM

Re: How do I convert an id to a text dimension in analysis 2005 - 10-06-2006 , 03:34 AM