Hi all. I'm trying to show a distinct list of months on the rows and
calculated measures for fiscal year on the columns, but I end up with
duplicate names for the months on the rows.

Fiscal year totals are calculated measures.

What is the best way in MDX to accomplish the "Unique Month Name on Rows"
trick?

Thanks.

Tim

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.developersdex.com ***

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 (AT) progressive (DOT) com> wrote

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.developersdex.com ***

Thanks Deepak.

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote