Hi,

I have a cube with multiple large dimensions.

We have a web front end that displays data. The web page diplays only 200
rows at a time. When the user selects next page, we will have to build
another MDX statement and bring the data from the cube.

Here is the problem that i have mostly with big dimenions when they are
selected as a ROW dimension. Displaying the first 200 rows based on the
selection criteria is straight forward. I do this using "Top N".

Now when they select the 2nd page, i do not know how to build the MDX
statement that brings me the 201 - 400 sales persons with highest sales.

In essense, how do i implement ranges with MDX?

Any help ig grately appreciated.

Thanks,

Sam.

CREATE SET Sales.OrderedSalesPeople AS Order(SalesPerson.MEMBERS,
Measures.[Unit Sales])
or
CREATE SET Sales.OrderedSalesPeople AS TopCount(SalesPerson.MEMBERS, 400,
Measures.[Unit Sales])

and then

SELECT Subset(OrderedSalesPeople, 200, 399) ON 0 FROM Sales

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote