Hi there,

I have to use some statistics excel formula in cube and couldn't able to
find that function. Is there any other way to do this ?

I have excel function TDIST and want to use in OLAP.

Thanks
-Kris

Hi Kris,

According to this list of registered Excel functions, TDIST should be
available for use in MDX:

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agmdxnonosfunct_3bzn.asp

However, it might not be listed in the MDX Builder:

http://support.microsoft.com/default...b;en-us;322966
listed in MDX Builder
...
SUMMARY

The "Register Function Libraries Dialog Box" topic in SQL Server Books
Online indicates that the Microsoft Visual Basic for Applications (VBA)
and Microsoft Excel worksheet function libraries are automatically
registered for use in Multidimensional Expressions (MDX).

While these function libraries are automatically registered and
available for use in MDX expressions, they are not automatically listed
in the MDX Builder dialog box. The functions from these libraries may or
may not be listed in the MDX Builder dialog box depending upon what
functions, if any, have been used from the VBA and Excel libraries in
the current cube.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Deepak :

Thank you so much for your reply and it is realy very helpful!.

Thanks
-Kris

"Deepak Puri" wrote: