Is it possible to page the drillthrough results at the server when a user
performs a drillthrough?


If say I had a cube holding all sales, then the MDX

SELECT
[Measures].Amount ON COLUMNS
FROM [Sales]

Would return the total amount of all sales. If my fact table contains
individual sales, then

DRILLTHROUGH
SELECT
[Measures].Amount ON COLUMNS
FROM [Sales]

Would return 10,000 rows to the client (the default max number returned from
drillthrough).

I can use MAXROWS, where <N> is large enough to ensure I get all the rows,
however this is going to give me too much data to pass to the client.

DRILLTHROUGH MAXROWS <N>
SELECT
[Measures].Amount ON COLUMNS
FROM [Sales]

How can I return a given number of rows from a given position in the
drillthrough results?


Thanks in advance

Stephen

if you use the ADOMD.NET API you'll found a reader function which support
the paging feature.
I don't have the name of the function in mind, but Search for a function
like ADOMDCommand.ExecuteSomething(...)

"Ste" <Ste (AT) discussions (DOT) microsoft.com> wrote