Hi there,

I have a dimension with a WBS column and its description. What I want
to do is to show them simultaneouly on the report. How to write this
MDX query?

Dimension
[WBS] [Description]
a-0-1-2 bla bla bla

Report

WBS Descripition Actual Budget Variance
a-0-1-2 bla bla bla 3 6 -3

Can anyone helps me with this?

Thanks in advanced

Best Regardly

If you're using AS 2005, and there is an attribute hierarchy for each
dimension property to be included on the report, then these properties
can be cross-joined, like:

[Scenario].[Scenario].&[2],
[Scenario].[Scenario].[Budget Variance]} on 0,
([Organization].[Organizations].&[14].Children,
[Organization].[Currency Code].[Currency Code].Members) on 1
from [Adventure Works]
where ([Measures].[Amount],
[Account].[Account Type].&[Revenue])
-----------------------------------------------------------
Actual Budget Budget Variance
Central Division USD $13,631,811.80 $3,583,400.00 $10,048,411.80
Northeast Division USD $11,422,201.20 $2,455,200.00 $8,967,001.20
Northwest Division USD $12,129,839.90 $3,121,300.00 $9,008,539.90
Southeast Division USD $9,207,330.80 $3,714,900.00 $5,492,430.80
Southwest Division USD $21,883,802.80 $5,783,400.00 $16,100,402.80

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***