Hi All,

While requesting a MDX to MS OLAP via XMLA, is there a way to limit the
number of members returned.

Is there a way in MDX to limit the rows returned and return the rows
according to the specific positions/range that I had requested for.

Eg: When I want to request rows and cols from 1-50 and
I may request rows and cols from 51-100 and like wise, there is a
method in XMLA that limit the cells but it always return the full
dimension members on rows and cols.

Could you use Subset MDX function on the axis ? (or if you are using NON
EMPTY, then it is not as simple).

--
==============================*=================== =
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.
==============================*=================== =
"Muhammad Mansoor" <mmansoor (AT) gmail (DOT) com> wrote