dbTalk Databases Forums  

MDX and Date Logic

comp.databases.olap comp.databases.olap


Discuss MDX and Date Logic in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jon
 
Posts: n/a

Default MDX and Date Logic - 05-25-2005 , 01:11 PM






New to MDX, hoping someone can help.

I have a time dimension broken down like this:

[Time].[All Time].[2005].[May].[6]

What I want is to get the first day of each existing month for the
previous 12 months -- i.e. May 1 2004, June 1 2004,...,May 1 2005

Currently, I'm able to get what I need by hardcoding, however I know
there's got to be a better way:

{[Time].[May].FirstChild,[Time].[June].FirstChild, ... } on ROWS, ...

I have been exploring functions such as PeriodsToDate() and
LastPeriods(-12, x) but so far have been unable to come up with the
right combination.

What am I missing?

Thanks.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.