MS SQL Server OLAP - MDX Range Queries

Author

MDX Range Queries

Prasad

2005-08-29, 8:24 pm

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.

Mosha Pasumansky [MS]

2005-08-29, 8:25 pm

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(OrderedSalesP
eople, 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@discussions.microsoft.com> wrote in message
news:0EB0DE53-BDFB-4FDE-A418- 99EBDE2C666B@microso
ft.com...
> 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.

Sponsored Links