Re: HELP WITH RANKING !!!!( please)

#1 (**permalink**) 02-29-2008, 02:31 PM

Heathon via SQLMonster.com wrote:
> Hello Everybody:
>
> Somebody know how I can create a nested ranking from a analysis services
> cube, using MDX?.. i mean, sort a sales ranking that show .how % of my
> clients.....b.buy only 100 articles.......how many clients ....expressed in %
> , buy just 200 articles parent level using a measure and then sort
> a child level using the same measure... something like:
>
> I got it nex table :
> Location client_id Sales article vendor_id
> city 1 122230 100 01
> City1 122231 200 05
> City1 122232 500 02
> City1 122233 100 04
> City 2 122234 100 02
> City2 122235 100 02
> City2 122236 200 03
> City3 122237 300 01
> City3 122238 400 01
> City3 122239 200 03
>
>
> I want show this : 40% clients . Buy 100 articles
> 30% clients . Buy 200 articles
> 10% clients .Buy 300 articles
> 10% clients . Buy 400 articles
> 10% clients . Buy 500 articles
>
>
> or this : the 70 % of clients buy between 100 and 200 aticles !!
>
> i.m use sql server 2000 , analysis services 8.0 ,olap , and mdx
>
> PLEASE HELP ME MADE THIS!!!!
>
> write me too at lealy_lenn@hotmail.com
>

You might get a better response in microsoft.public.sqlserver.olap

Simon

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