Databases Reference
In-Depth Information
Progress Report
events. (See Chapter 38, “Using Trace to Monitor and Audit Analysis
Services,” for more information about using Profiler.) The Processing dialog in Business
Intelligence Development Studio and in SQL Server Management Studio also listens to
the trace events and presents you with information about the progress of your processing
operation. For instance, the Read Data thread generates a
Progress Report Current
event for every 1,000 records it reads from a relational database.
Each progress report also contains information about processing errors. Processing errors
are a special category of error. They often indicate inconsistencies and referential integrity
problems with your relational data. In many cases, you would like to collect a log of all
the errors that happened during processing so that you can go back to the relational data-
base and fix them.
Analysis Services provides you with the option to specify what kind of processing errors
you would like to see in the progress report. It also enables you to collect processing errors
in a separate log file. For that, you use the
ErrorConfiguration
object that can be speci-
fied for your
Dimension
,
Cube
,
Measure Group
, and
Partition
objects.
If the
ErrorConfiguration
object is specified for the parent object, it is used as the default
for children objects if you don't explicitly override it in the child object definition.
NOTE
The defaults for missing values in the
ErrorConfiguration
object are not obtained
from the parent object. You can create an empty
ErrorConfiguration
object for your
partition to override values of the measure group's
ErrorConfiguration
object.
You can also specify
ErrorConfiguration
as part of your
Process
command. This defini-
tion overrides the
ErrorConfiguration
objects defined in the metadata. (For more infor-
mation about Analysis Services commands, see Chapter 26.) An example of defining an
ErrorConfiguration
object is shown in Listing 21.2.
LISTING 21.2
DDL of
ErrorConfiguration
Object
<ErrorConfiguration>
<KeyErrorLimit>0</KeyErrorLimit>
<KeyErrorLogFile>c:\tmp\process.log</KeyErrorLogFile>
<KeyNotFound>ReportAndStop</KeyNotFound>
<KeyDuplicate>ReportAndStop</KeyDuplicate>
<NullKeyConvertedToUnknown>ReportAndStop</NullKeyConvertedToUnknown>
<NullKeyNotAllowed>ReportAndStop</NullKeyNotAllowed>
</ErrorConfiguration>
Search WWH ::
Custom Search