Hi All,

Have a look at the followind MDX (Yes, it works with FoodMar 2000
also)

-------------------------
With
Member Customers.[Customers_123] AS 'SUM ( {
Customers.[Country].[Canada], Customers.[Country].[Mexico],
Customers.[Country].[USA] } )'
Member Gender.[Genders_123] AS 'SUM ( {Gender.[Gender].[F],
Gender.[Gender].[M] } )'
SELECT {{Measures.[Profit],Measures.[Store Sales]}} ON COLUMNS,
{CrossJoin({Gender.[Genders_123]}, {Customers.[Customers_123]}) }
ON ROWS FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL]
---------------------------

The Result is Like This :: (It will look good when seen with Fixed
Character Width)

+------------+--------------+--------------------------+


But i Want Result in this format :


+--------------+---------+--------------+

Any idea what i need alter with MDX or any other suggestion

What you want is members of different dimensions on the same MDX query
axis - this can't be done directly, but in previous threads, approaches
like this were suggested:

Member Customers.[Customers_123] AS 'SUM ( {
Customers.[Country].[Canada], Customers.[Country].[Mexico],
Customers.[Country].[USA] } )'
Member Gender.[Genders_123] AS 'SUM ( {Gender.[Gender].[F],
Gender.[Gender].[M] } )'
SELECT {{Measures.[Profit],Measures.[Store Sales]}} ON COLUMNS,
{(Customers.[Customers_123], [Gender].[All Gender]),
([Customers].[All Customers], Gender.[Genders_123])}
ON ROWS FROM [Sales]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Sometimes I also asked that kind of requirement.

It needs to divide your MDX statement into two or more statements and
execute them at the same time. Furthermore, client UI has to support it.

Actually, there is a tool, Geac Decision(prior Comshare Decision), that
supports your requrement just through UI operation.

http://www.performance.geac.com/decision/decision.cfm

Ohjoo Kwon



"Muhammad Mansoor" <mmansoor (AT) gmail (DOT) com> wrote