 | |
Re: Percentiles
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Percentiles -
07-02-2003
, 12:48 PM
|
Hi, We're hopeing to do some analyses using Percentiles within Analyses Services. On a dataset of drug compounds. example below: Compd Type Route TimeTakenToBringToMarket -------- ---- ------ ----------------------------- C1 NCE BM 106days C2 NCE BM 210days C3 NME IV 300days C4 NCE IV 100days C5 NME BM 50days In this example my cube dimensions would be Type & Route I want to be able to use the Excel Percentiles function server side to give my cube the facility to produce the 5th, 25th, 50th, 75th, 95th percentiles by dimension. The documentation says you can use Excel functions within a calculated member, but not how to set it up. Any thoughts or examples? Cheers Andy |
#2
| |||
| |||
|
|
For help with percentiles and other statistical functions check http://www.dsslab.com/MDXSolutions.h...Statistics.doc I believe percentiles are covered in the document. Sean -- Sean Boon SQL BI Product Unit **This posting is provided AS IS, with no warranties, and confers no rights.** "AJC" <ajcoan (AT) yahoo (DOT) com> wrote Hi, We're hopeing to do some analyses using Percentiles within Analyses Services. On a dataset of drug compounds. example below: Compd Type Route TimeTakenToBringToMarket -------- ---- ------ ----------------------------- C1 NCE BM 106days C2 NCE BM 210days C3 NME IV 300days C4 NCE IV 100days C5 NME BM 50days In this example my cube dimensions would be Type & Route I want to be able to use the Excel Percentiles function server side to give my cube the facility to produce the 5th, 25th, 50th, 75th, 95th percentiles by dimension. The documentation says you can use Excel functions within a calculated member, but not how to set it up. Any thoughts or examples? Cheers Andy |
#3
| |||
| |||
|
|
Sean, That's great, really confusing as I'm not a statistician, but great! Thanks Andy "Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote in message news:uuwreIMQDHA.2476 (AT) TK2MSFTNGP10 (DOT) phx.gbl... For help with percentiles and other statistical functions check http://www.dsslab.com/MDXSolutions.h...Statistics.doc I believe percentiles are covered in the document. Sean -- Sean Boon SQL BI Product Unit **This posting is provided AS IS, with no warranties, and confers no rights.** "AJC" <ajcoan (AT) yahoo (DOT) com> wrote in message news:3f02d91f$1 (AT) news (DOT) star.co.uk... Hi, We're hopeing to do some analyses using Percentiles within Analyses Services. On a dataset of drug compounds. example below: Compd Type Route TimeTakenToBringToMarket -------- ---- ------ ----------------------------- C1 NCE BM 106days C2 NCE BM 210days C3 NME IV 300days C4 NCE IV 100days C5 NME BM 50days In this example my cube dimensions would be Type & Route I want to be able to use the Excel Percentiles function server side to give my cube the facility to produce the 5th, 25th, 50th, 75th, 95th percentiles by dimension. The documentation says you can use Excel functions within a calculated member, but not how to set it up. Any thoughts or examples? Cheers Andy |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.