Is it possible to create a single member that aggregates tuples across
dimensions? To illustrate, imagine a cube:

Dimension.Member Qty
-----------------------
A.1 100
A.2 200
B.10 300
B.11 400

I want to be able to define a member or entitity "x" that aggregates
measures for {A.1, A.2, B.10}, such that

select {[Measures].[Qty]} on 0, {[<some dim>].[x]} on 1 from MyCube

results in

Dimension.Member Qty
-----------------------
<some dim>.x 600

Creating a named set almost gets there, but in the result the rows axis
displays the individual members of the set, not an aggregate. A calculated
member seems to be the answer, but it appears a calculated member can't refer
to members outside of its dimension/level - hence I stubbed in <some dim>
above.

Any suggestions appreciated. Thanks.

Here's an example for the Foodmart Sales cube, which sums [Unit Sales]
across [Product].Drink], [Product].[Food] and [Promotions].[Big Promo]:

'Aggregate({
([Product].[All Products].[Drink],
[Promotions].[All Promotions]),
([Product].[All Products].[Food],
[Promotions].[All Promotions]),
([Product].[All Products],
[Promotions].[All Promotions].[Big Promo])})'
select {[Measures].[Unit Sales]} on columns,
[Product].[Product Family].AllMembers on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

I see. That works. Thanks a bunch.

- Scott