Can anybody suggest alternatives on using vba functions like Instr etc with
64 bit Analyis Services. We used string handling functions extensively in 32
bit and have issues migrating to the 64 bit.

Alternatives are much appreciated.

Example MDX Exprerssion on 32 bit:

Iif(InStr(1, SetToStr(Axis(0)) ) , "[Gender].", "Selected", "Not Selected")

Thanks,

Sam.

If the client is on 32 bit and only the server is on 64 bit - you can still
use these.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
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.
==============================*=================== =
"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote