Dear all,

I have created a calculated member which MDX expression is "date()". The
data is presented in Excel. In some computers, the calculated member show
current date. However, in some ohter computers, the value of calculated is
invalid or zero. Why?

Thanks for responding.

Polly

Date() is not an MDX function, it is VBA function. Can you check on those
computers where it doesn't work, whether calling Date() from VBA works ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/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.
==================================================

Hi,

the date()-function is using the date and regional settings of the client.
Maybe this is a reason for "unexpected" members that are invalid.

cheers,
Matthias

"Polly" <Polly (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:4689126C-F49B-4C7D-9699-3E17F965D7D9 (AT) microsoft (DOT) com...