Hi All

I am stuck in a MDX query

I have two dimensions UserName and CallType

So the output should look like this

UserName CallType Calls TotalCallsbyCallType
Tom Cruise Appt. reminder 25 40
Tom Cruise Counseling 30 60
Jennifer An Intake 5 5
Jennifer An Appt. reminder 10 40
Jennifer An Outbound 20 20
Sheryl Crow Appt. reminder 5 40
Sheryl Crow Counseling 30 60

I have repeated the username for individual groups above for
understanding.. they dont appear multiple times in the report

I tried a lot of queries but doesnt help. Please help
thanks in advance

Milind

Assuming that [Calls] is a base measure of [CallCube],
and that [UserName] and [CallType] are leaf levels:

'([Measures].[Calls], [UserName].[All UserName])'

Select {[Measures].[Calls],
[Measures].[TotalCallsbyCallType]} on columns,
NonEmptyCrossJoin([UserName].[UserName].Members,
[CallType].[CallType].Members on rows
from [CallCube]

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!