Can anyone tell me if the UDF for allowed members support a
free-threaded component? I have authored a simple function in C++ and
need the free-threaded component because of performance and scaling
considerations. Moving to the 64-bit platform is not a feasible
solution.

Thanks!!

"Robert H" <chadn1003 (AT) hotmail (DOT) com> wrote

Can you elaborate more on those performance and scaling considerations ? The
expression for Allowed Set is evaluated only once for given role/combination
of roles, and later the cached version of secured dimension is used.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

I don't see why not -- but I haven't tested it that way. The probablity that
something will work using STA, but break if you implement it via a properly
written MTA component is pretty slim. Typically you run into problems the
other way around, e.g. if you've written something that assumes MTA and
implement a STA component instead.

I believe that all of the Excel functions are free-threaded and if they
work; then I don't see why yours wouldn't.

Recognize that writing a good quality free-threaded component isn't a
trivial task. And remember that you will be running as an extension of the
msmdsrv process. If you mess up, you will bring down the whole OLAP service.

Let us know how things go . . .

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Robert H" <chadn1003 (AT) hotmail (DOT) com> wrote