When using AM to process cubes a lot of information is shown including :

1) Queries to build dimension
2) Queries to build cube
3) Running total of rows processe
4) On error a detailed description of the erro

I can generate 1 & 2 using DSO (although it would be nice to know how the table order is determined as this can have quite an impact on the query performance)

But as for 3 and 4 is it possible to get this information from DSO. For 4 in particular when we have a dimension which has been optimised out of the cube it is possible to get data integrity errors, I can't seem to pick these up when the process function returns.

Any suggestions

Thank

Naz

I would suggest that you setup a server-wide processing log file (run AM,
right-click on the server and select "Properties..." -- then go to the
Logging tab. Then you can use some file-scanning software to look through it
and parse out what is happening. It is sometimes very difficult without
seeing the full-history and location of where an error is occurring. The
best you are going to get out of DSO is that an error occurred.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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

performance).
cube it is possible to get data integrity errors, I can't seem to pick these
up when the process function returns.

In order to get a running totals for the cube processing, your application
needs to support DSO events. There's an application that ships with the SQL
Server 2000 Resource Kit which includes source code and uses DSO events.
It's called the Parallel Process Utility.


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
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.

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

performance).
cube it is possible to get data integrity errors, I can't seem to pick these
up when the process function returns.

Thanks for the Info Dave and Sean

One thing though Sean I haven't found any C# examples of DSO events. I can't quite get this setup. I'm most interested in the progress event. I have found the following delegate DSO.__Database_ReportProgressEventHandler and I have defined the following function :

public void ReportProgress(Object obj, int action, long cnt, string msg, bool cancel ) {

I would like to associate this with a DSO.CubeClass cube before calling

cube.Process()

Could someone point me in the right direction

Thank