Hi Everyone,

I am trying to define a Calculated Member using the Excel function
"Quartile".

This is what I give:

Excel!QUARTILE(SETTOARRAY((1,2,3,4,5,6,7,8,9,10)), 1)

in the Calculated Member Builder in the Cube Editor.

However, I get the error: Formula error - invalid or unsupported
user-defined function "!Excel!QUARTILE"


If I give the following:
QUARTILE(SETTOARRAY((1,2,3,4,5,6,7,8,9,10)),1)

I get the error: Formula error - syntax error - token is not valid:
"QUARTILE^(^SETTOARRAY((1,2,3,4,5,6,7,8,9,10)),1)"


Excel is installed on the server (Excel 2003). Is there any
configuration I need to do for Analysis Services to use Excel? I have
searched and searched, in documents and on th net. Any suggestions
please?

Thanks a ton

Regards

Vani Murarka