I have a query

SELECT
{[Measures].[MeasuresLevel].[Volume], [Measures].[MeasuresLevel].[PY
Volume]} ON 0,
TOPCOUNT(CROSSJOIN([Brand].[Brand Family].Members, [Global
Player].[Global Player].Members), 20,
[Measures].[MeasuresLevel].[Volume]) ON 1
FROM [Data]


Which works fine how ever I also want to add the top 5 Brand Familys
that only belong to a certain Global player. What is the extra bit of
code for this??

Also ther is a possiblility that the same brand family will appear in
both Top Statemnets so I wil only want the unique brand families?!

Is this possible if so Can anyone help

Thanks

Denver

all of this is possible, but I have not all the answers...

first one, try start here:
http://groups.google.ca/group/micros...4bdf2fca4efbc0

which contain:
WITH
SET [Customers in USA] AS 'Descendants([Customers].[All Customers].[USA],
[Customers].[Name])'
SELECT {[Measures].[Profit]} ON COLUMNS,
Generate(TopCount({[Customers in USA]}, 10, [Measures].[Profit]),
CrossJoin({[Customers].Current*Member}, TopCount({[Product].[Product
Name].Members}, 5, [Measures].[Profit])), ALL) ON ROWS
FROM [Sales]


and here there are a lot of articles about mdx:
http://databasejournal.com/features/...0894_3508491_5

and maybe this article will answer your last question:
http://blogs.msdn.com/bi_systems/articles/162800.aspx


"Denver" <DenverKirrane (AT) gmail (DOT) com> wrote

How about using Union(), something like:

{[Measures].[MeasuresLevel].[Volume], [Measures].[MeasuresLevel].[PY
Volume]} ON 0,
Order(Union(
TOPCOUNT(CROSSJOIN([Brand].[Brand Family].Members, [Global
Player].[Global Player].Members), 20,
[Measures].[MeasuresLevel].[Volume]),
TOPCOUNT(CROSSJOIN([Brand].[Brand Family].Members, {[Global
Player].[Global Player].[Player X]}), 5,
[Measures].[MeasuresLevel].[Volume])),
[Measures].[MeasuresLevel].[Volume], BDESC) ON 1
FROM [Data]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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