For the [MS] MDX gurus, here's a quirk I came across, while doing a
Foodmart Sales MDX query that was posted earlier:


This adds a [Gender].[All Gender] row, as expected>>

WITH SET [Test1] as '{{[Gender].[All Gender].[F],
[Gender].[All Gender].[M],[Gender].[All Gender].[F]}
* {[Marital Status].[All Marital Status]},
{[Gender].[All Gender]}
* {[Marital Status].[All Marital Status]}}'
SELECT
{[Measures].[Unit Sales]} on COLUMNS,
[Test1] on ROWS
FROM [Sales]


But no [Gender].[All Gender] row gets added here>>

WITH SET [Test1] as 'Union({[Gender].[All Gender].[F],
[Gender].[All Gender].[M],[Gender].[All Gender].[F]}
* {[Marital Status].[All Marital Status]},
{[Gender].[All Gender]}
* {[Marital Status].[All Marital Status]}, ALL)'
SELECT
{[Measures].[Unit Sales]} on COLUMNS,
[Test1] on ROWS
FROM [Sales]


- Deepak

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

Thanks Deepak - this definetely looks like a bug - we will investigate.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

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