Viewing 2 attributes from a cube in MDX 1

[Flybridge]

I have a calendar dimension and I want to see 2 attributes in my query list:
[Calendar].[Date].[Date]
[Calendar].[Week No].[Week No]

It complains about them not having the same dimensionality.

How can I force it to display both in my query output?

TIA

'The world isn't round - it's bent!' Spike Milligan

 

[RiverGuy]

If you had a Week-Date hierarchy, you could do something like

{[Calendar].[Week Hierarchy].ALLMEMBERS}

Or, you could do a cross join.

{[Calendar].[Week No].[Week No]} * {[Calendar].[Date].[Date]}

 

[Flybridge]

Thanks. Should have thought about the cross join Doh!

'The world isn't round - it's bent!' Spike Milligan