Re: How to effectively use BeginRange / EndRange .. for records paging?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mangesh Pawar (anonymous_at_discussions.microsoft.com)
Date: 06/25/04 

Date: Thu, 24 Jun 2004 18:27:39 -0700

Is it possible to cache the axes data.. and reuse with MDX,

If yes, how..? (With Cache..?)

I have around 40,000 records of a dimension to be
displayed on a axes.

Thanks,

Mangesh

>-----Original Message-----
>When using the Multidimensional format, you can first
request BeginRange=0
>and EndRange=0. This will return you a single cell but
all the axis
>information. You can calculate the number of cells using
the tuple
>information of each axis.
>
>Unfortunately, there is no way to avoid receiving the
axis data with each
>request -- and this could be a big perf hit.
>
>Thanks,
>Akshai
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights
>Please do not send email directly to this alias. This
alias is for newsgroup
>purposes only.
>
>"Mangesh Pawar" <anonymous@discussions.microsoft.com>
wrote in message
>news:20bb401c45982$f4145410$a401280a@phx.gbl...
>> How to effectively use BeginRange / EndRange .. to get
the
>> result in pages?
>> Say X no. of rows should be displayed per page and Rows
>> per page is configurable
>>
>> Example:
>> The MDX query returns 100,000 rows.
>> Number of rows per retreived page is set to 25
>>
>> In this case, no. of rows is determined
>> But to set Beginrange & EndRange.. one would require
both
>> number of rows & columns
>> As number of columns that can be returned by the query
is
>> not known.
>> .
>> Will it be necessary to first execute the query (that
>> returns 100,000 rows.. ) .. find the number columns..
>> and then based row-column values set Beginrange /
Endrange
>> vaues
>>
>> Or is there a alternative method to pre-determine no. of
>> Columns of a the MDX query
>>
>> Thanks
>
>
>.
>

Relevant Pages