Is there a way to retrieve the number of rows a DSO Object (clsCube,
clsPartition or clsDimension) processed?
And also to obtain the exact query used for process the object?

I've tried to combine properties like SourceTable, FromClause, JoinClause,
Slicer and SourceTableFilter but I wasn't able to obtain the exact query.

Thanks in advance

Francesco

The best way to do this is to enable the system-wide processing log file.
Bring up Analysis Manager, right-click on the server name; select properties
and then look in the "Logging" tab. You will see that you can specify a file
to receive the same information you get in the processing dialog box. This a
best practice to enable this for long-term history tracking. It contains the
SQL statement and the total time to process.

If you want to do this within an application, you have to create an event.
See the VB code included in the Parallel Processing Utility at:
http://www.microsoft.com/downloads/d...DisplayLang=en

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Francesco De Chirico" <fradechi (AT) tiscali (DOT) it> wrote

Thanks!

I'll try to implement something like the solution present in Parallel
Processing Utility within my application.

--
Francesco De Chirico
ForGroup s.r.l.
Via G.Frua, 24 - 20146 Milano
Tel 02/4980108
E-Mail f.dechirico (AT) forgroup (DOT) it
"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> ha scritto nel
messaggio news:%23Ow6Zzz4EHA.2180 (AT) TK2MSFTNGP10 (DOT) phx.gbl...