Find the month number using MDX

#1

Hi:

I am trying to find a way to retrun the month num in my time
dimension.
For example, with Aug selected, it will retrun 8.
Does such function exist??

Thanks
Arale

#2

Hi Fernando:
Thanks for the suggestion, I will try that.
Arale

Fernando Marçal wrote:

Quote:

Hi Arale,

Are you using AS2000? If so you can add the month num as a member property
and the access it via Property("PropertyName").

HTH
Fernando Marçal.

"aralew (AT) gmail (DOT) com" wrote:

Hi:

I am trying to find a way to retrun the month num in my time
dimension.
For example, with Aug selected, it will retrun 8.
Does such function exist??

Thanks
Arale

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

Find the month number using MDX

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

Find the month number using MDX - 12-29-2005 , 03:31 PM

Re: Find the month number using MDX - 01-03-2006 , 01:49 PM