Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Find the month number using MDX

 
   Database Forums (Home) -> OLAP RSS
Next:  Using Case Conditions in WHERE clause  
Author Message
aralew

External


Since: Dec 29, 2005
Posts: 2



(Msg. 1) Posted: Thu Dec 29, 2005 1:31 pm
Post subject: Find the month number using MDX
Archived from groups: microsoft>public>sqlserver>olap (more info?)

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

 >> Stay informed about: Find the month number using MDX 
Back to top
Login to vote
Fernando Marçal

External


Since: Oct 20, 2005
Posts: 6



(Msg. 2) Posted: Tue Jan 03, 2006 9:20 am
Post subject: RE: Find the month number using MDX [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.

" " 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
>
>

 >> Stay informed about: Find the month number using MDX 
Back to top
Login to vote
aralew

External


Since: Dec 29, 2005
Posts: 2



(Msg. 3) Posted: Tue Jan 03, 2006 11:49 am
Post subject: Re: Find the month number using MDX [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

Fernando Marçal wrote:
> 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.
>
> " " 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
> >
> >
 >> Stay informed about: Find the month number using MDX 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> OLAP All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]