Hi

I have been playing with MDX for a couple of weeks now to produce
reports in SQL Reporting services.

I have hit a bit of a wall.

I want to display 2 measures in the results window

I have years across the columns and a lot of items on rows using a
nonemptycrossjoin.

This method is working fine when i only want one measure but i now need
2.

Here is a screen shot of the report i am trying to produce
http://img225.imageshack.us/img225/194/report8bx.jpg

Here is the code that allows be to get this report with just cost

Select

{[Financial Year].[Year].Members} on columns,
{nonemptycrossjoin([Project TLB].[Level 02].Members,[Task UIN].[Level
02].Members,[Task RAC].[Level 02].Members,[Project Short Name].[Prj
Short Nme].Members,
[Project Title].[Prj Des].Members)
} on ROWS
FROM [Custom Cube]
WHERE [Measures].[Cost]


PLEASE can someone help be modify this code to produce something close
to what i need.


Thanks in advance


Paul

Something like the following, crossjoining the measures by the years,
should do the trick:


Select
Crossjoin({[Measures].[Cost],[Measures].[Sales]}
,{[Financial Year].[Year].Members}) on columns,
{nonemptycrossjoin([Project TLB].[Level 02].Members,[Task UIN].[Level
02].Members,[Task RAC].[Level 02].Members,[Project Short Name].[Prj
Short Nme].Members,
[Project Title].[Prj Des].Members)
} on ROWS
FROM [Custom Cube]


--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1145888464.753955.291170 (AT) i39g2000cwa (DOT) googlegroups.com>,
pbuzzby (AT) gmail (DOT) com says...