Selecting top x rows from a cube

[plsh]

Hi there,

Does anyone know how to return the top x rows from a cube. I can do it through a OWC pivottable or chartsspace but I need to do it programmatically.

Any help will be apreciated.

 

[MDXer]

The TopCount function is what is used.

With
SET [Top 100 Products] AS 'Topcount(Product.Products.Members,100,Measures.Units)'

Select 
{Measures.Units} On Columns,
{[Top 100 Products]} On Rows
From CubeName

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck