This is my query:

with member [Measures].[DateUniqueName] as '[Dato].CurrentMember.UniqueName'
member [Measures].[DateName] as '[Dato].CurrentMember.Properties("Key")'
select {[Measures].[DateUniqueName],[Measures].[DateName]} on Columns
from [prosjekt komplett]
where (Tail(nonemptycrossjoin( [Dato].[Day].members,{[Medarbeider].&[1005]},
{[Measures].[Totale Timer]}, 1)).Item(0))

On my dev box and on my test box, this works nicely, and gives me the last
date a given employee has registered an hour.

On my production server, it fails, with the following error:

An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'SisteDato'. (rsErrorExecutingCommand)
Get Online Help
Formula error - <null> WHERE clause not supported - when calculating the
WHERE clause

- My where clause works nicely on one server, but not this. What could the
reason be?

Kaisa M. Lindahl

This sounds like a configuration issue if the query works correctly on
dev and test. Do you have other OLAP based reports in production? Have
you checked the version of the MSOLAP provider in each of the
environments?

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#zWnfAtFGHA.344 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, kaisaml (AT) hotmail (DOT) com
says...

I do have 20+ other reports on the server, so I was a bit surprised to see
it didn't work.
Another thing that doesn't work is omitting defaultmember when using
descendants. This (defaultmember) seems to be a problem with locales, but
I'm not sure if that is the case with my Where clause problem.The production
server is set with a different locale than my test server, but I can't
really change that by myself, so I'm not sure if that's what causing the
problem. Both servers are on the same Service pack edition.

Kaisa M. Lindahl


<Darren Gosbell> wrote

The problem was solved by rewriting the MDX statement. A developer told me
that [Totale Timer] was the default measure, so I removed it from the query,
and now it works.
Not quite sure why, though, so any suggestions on why are very interesting.

Final, working query:
with member [Measures].[DateUniqueName] as '[Dato].CurrentMember.UniqueName'
member [Measures].[DateName] as '[Dato].CurrentMember.Properties("Key")'
select {[Measures].[DateUniqueName],[Measures].[DateName]} on Columns
from [prosjekt komplett]
where (Tail(nonemptycrossjoin( [Dato].[Day].members,{[Medarbeider].&[1005]},
1)).Item(0))


Kaisa M. Lindahl

"Kaisa M. Lindahl" <kaisaml (AT) hotmail (DOT) com> wrote

In article <uQ$XF44FGHA.1452 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, kaisaml (AT) hotmail (DOT) com
says...
different ways the query could be written, but I can't think of anything
that explains why the final query works and the first one does not. They
should be equivalent.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell