Change Dimension Names

#1

Hi,

I have a dimension that has values :

1,2,3,4

and I want to show when Browsing cube :

USA,Canada,Tokyo,Paris

Is this possible by using an MDX query?

Thanks,
D.E.

#2

I'm not sure you can use an MDX query. You can certanily use a CASE sql
statement in the dimension "Member name Column" property.
CASE YourField WHEN 1 then 'USA' WHEN 2 then 'CANADA' ..... END

Francesco Anti

"D.E." <dimitris (AT) add (DOT) gr> wrote

Quote:

Hi,

I have a dimension that has values :

1,2,3,4

and I want to show when Browsing cube :

USA,Canada,Tokyo,Paris

Is this possible by using an MDX query?

Thanks,
D.E.

#3

Francesco,
Thank you very much
It works ok.

D.E.

"Francesco Anti" <fanti_ (AT) _sicosbt (DOT) it> wrote

Quote:

I'm not sure you can use an MDX query. You can certanily use a CASE sql
statement in the dimension "Member name Column" property.
CASE YourField WHEN 1 then 'USA' WHEN 2 then 'CANADA' ..... END

Francesco Anti

"D.E." <dimitris (AT) add (DOT) gr> wrote in message
news:O9v3p6OkFHA.4000 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

I have a dimension that has values :

1,2,3,4

and I want to show when Browsing cube :

USA,Canada,Tokyo,Paris

Is this possible by using an MDX query?

Thanks,
D.E.

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

Change Dimension Names

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

Change Dimension Names - 07-25-2005 , 02:57 AM

Re: Change Dimension Names - 07-25-2005 , 03:31 AM

Re: Change Dimension Names - 07-25-2005 , 03:57 AM