|
Home > Archive > MS SQL Server OLAP > January 2006 > 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-26, 8:23 pm |
| Thanks Deepak.
We're running SQL2K. The time dimension is calendar years. We do not have
a separate dimension for months.
Time
- Year
- 2004
- January
. ~
. ~
. ~
- ~December
I may be trying to solve a 3-dimensional problem in a 2-dimensional world
too though. We're trying to chart a series of year-month values across an
x-axis of months to show the comparisons of years across each month. At the
same time, we have a "target" value (our KPI) that doesn't change across
years. When I try to plot this in reporting services, I
<italic>could</italic> add each year as my series along with my target, but
then I get a target for each year which isn't the desirable outcome. So my
solution was to try to split the time dimension and produce year * month
measures with the months across the x-axis. I don't know if this is even
possible in SQL2KAS.
Thanks.
"Deepak Puri" < deepak_puri@progress
ive.com> wrote in message
news:%23tcaJUjIGHA.2704@TK2MSFTNGP15.phx.gbl...
> Hi Tim,
>
> Could you describe your time dimension(s) - are fiscal years and months
> on different dimensions? And are you using AS 2000 or AS 2005?
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***
|
|
|
|
|