Excel & ROLAP

#1

Hi all,

When I use excel to view my cube data (that is stored using ROLAP). I am not
able to see the
SQL Statements that get issued to SQL Server (sometimes I get those). I am
using the SQL Server profiler and I have
cleared the cache also using DBCC DROPCLEANBUFFERS.

Any insights ?

Thanks,
John

#2

Thanks Marin !!

"Marin Bezic [MSFT]" <marinb (AT) online (DOT) microsoft.com> wrote

Quote:

Hi John,

the reason why sometimes you see the SQL statements going to the SQL
Server
and sometimes you don't is that Analysis Server caches the data. If your
subsequent queries can be answered from the data in cache, there is no
need
for the analysis server to issue a SQL query to the SQL Server.

Marin Bezic

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"John Thomas" <ptjohn (AT) hotmail (DOT) com> wrote in message
news:OMx7B%23ORDHA.2020 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Hi all,

When I use excel to view my cube data (that is stored using ROLAP). I am
not
able to see the
SQL Statements that get issued to SQL Server (sometimes I get those). I
am
using the SQL Server profiler and I have
cleared the cache also using DBCC DROPCLEANBUFFERS.

Any insights ?

Thanks,
John

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Excel & ROLAP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Excel & ROLAP - 07-07-2003 , 08:23 PM

Re: Excel & ROLAP - 07-09-2003 , 03:20 PM