Also, all XMLA properties can be passed through to the server from the
connection string.
--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]
"Simmo" <Si...@discussions.microsoft.com> wrote in message
news:0A5835D3-CA05-4C84...@microsoft.com...
> Hi all,
>
> Just wondered if anyone knew of any key differences in connection strings
> when connecting to 2005 rather than 2000 Analysis Services? Also are there
> any enhancements or funky new options available?
>
> thanks
> --
> Simmo
SQLQueryMode:
Real Time Olap:
EffectiveUserName:
MDX Missing Member Mode:
SQLQueryMode:
Real Time Olap:
EffectiveUserName:
MDX Missing Member Mode:
--
Simmo
SQLQueryMode -- Calculated/Data. SQL queries return either calculated
results or lowest pass results. The lowest pass mode is used by local cubes
to process the local cube from server cube's lowest pass data. You need
extra permission to fetch lowest pass data
Real Time Olap: true/false. Default is false -- if you turn this on, then
the query will ignore the in-memory caches of storage engine data and go
directly to the source data for each partition (MOLAP will go to MOLAP data
and ROLAP will execute relational queries).
EffectiveUserName: Allows impersonating another user when privilege is
available. Requires S4U Windows support to be setup.
MDX Missing Member Mode: Default/Ignore/Error. If a name in the MDX query
cannot be resolved, the server can either ignore it or raise an error.
Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Simmo" <Si...@discussions.microsoft.com> wrote in message
news:D29ECBFA-D6F0-428F...@microsoft.com...