Hi,

Has anyone used/knows how to use the connection string property
<<Use Formula Cache>>
From the name I'm guesssing this should be true or false or 1 or 0.
However, no matter what value I use it doesn't seem to make a difference to a
simple query that lists a series of calculated members, each time the query
runs, the client processor flat lines at 100% as it recalcs all the values
even though it is using the same connection.

Any ideas?
Ta
Paul

do you use AS2000 or 2005?

in 2005 the formula results are allways executed on the server side and
cached on the server.

with AS2000 the client recalculates the formula at every call.
Use the Execution Location=3 in the connectionstring to execute the
statement on the server side instead-of the client side.


"Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote