MS SQL Server OLAP - Re: MDX query to show FY2004, FY2005, ... FY~n on columns and distinct set of months (Jan...Dec) on

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: MDX query to show FY2004, FY2005, ... FY~n on columns and distinct set of months (Jan...Dec) on

Timmay!

2006-01-27, 7:23 am

Thanks Deepak.

"Deepak Puri" < deepak_puri@progress
ive.com> wrote in message
news:ug9wbRuIGHA.648@TK2MSFTNGP14.phx.gbl...
> In the case of AS 2000, you could create appropriate Member Properties
> at the Month level; then add a Month virtual dimension, based on these
> properties. Such a new virtual dimension would permit year vs month
> analysis.
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***

Sponsored Links