Quartile, Percentile: Analysis Services

#1

Anyone used these functions, document says they are supported since they are part of Excel. But the Calc. member window gives me syntax error

Any help will be appreciated

Suni

#2

Sunil Kadimdiwan wrote:

Quote:

Anyone used these functions, document says they are supported since
they are part of Excel. But the Calc. member window gives me syntax
error.

Yes - we are using the Quartile-function. You need to have Excel installed
on the server. There seems to be a problem, if you are dealing with Excel
2003. Somehow it seems as if this version of Excel does not expose its
functions for use in Analysis Services.

--
Michael Barrett

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

Quartile, Percentile: Analysis Services

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

Quartile, Percentile: Analysis Services - 01-25-2004 , 06:21 PM

Re: Quartile, Percentile: Analysis Services - 01-26-2004 , 04:21 AM