Re: Rank Data

#1

Hi Tom,

thx for your immediate reply!

I tried it and received a ranking, but 1,2,...,7,1(?),2
(?),3(?).

Could it be that the ranking is disturbed by the Topten
Selection on products and sorting descendant?

Perhaps you have an idea.

Regards Kim

Quote:

-----Original Message-----
Here's a foodmart example. This ranks any member of
product within it's
level. Note that RANK is really a position function -- it
finds the position
of a tuple within a set. In order to rank, the set must
be ordered.

WITH MEMBER
[Measures].[Rank] AS
' Rank ( Product.CurrentMember ,
Order( {Product.CurrentMember.Parent.Children}} ,
[Profit], DESC) ) '
SELECT
{[Profit] , [Rank]} ON COLUMNS,
Order(Drink.Children, Measures.[Rank], ASC) ON ROWS
FROM Sales

tom @ the domain below
www.tomchester.net

"Kim" <seemann (AT) cescom (DOT) de> wrote in message
news:077301c34c46$c2e82000$a501280a (AT) phx (DOT) gbl...
How can i show the position number next to a ranked column
(f.e. sales ranked for customers)? Sorry, I don´t know how
to handle the 'Rank' Function in Analysis Services...

Thx

Kim

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Rank Data

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Rank Data - 07-17-2003 , 02:18 PM