Sort based off measures

#1

Is it possible in analysis services to sort a dimension (account)
based off the measures?

I would like do something like select the top 250 accounts based off
revenue.

Any help would be appreciated,

Thanks,

#2

TopCount(Account.Members, 250, Measures.Revenue)

public @ the domain below
www.tomchester.net

"Dave" <david_green (AT) softhome (DOT) net> wrote

Quote:

Is it possible in analysis services to sort a dimension (account)
based off the measures?

I would like do something like select the top 250 accounts based off
revenue.

Any help would be appreciated,

Thanks,

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

Sort based off measures

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

Sort based off measures - 04-07-2004 , 05:37 PM

Re: Sort based off measures - 04-07-2004 , 09:06 PM