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.

 

[SarkMan]

You could use ado and mdx (Multidimensional Expressions)

use this link for an into to mdx (use topcount function for your needs)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnolap/html/intromdx.asp?frame=true

and here is a link showing vb and ado

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213364

hope this helps