Learning advanced dimension processing options
In the previous recipe, you processed a few dimensions after altering the degree of parallelism. You can specify additional options to handle any errors you might encounter during processing from the same dialog using the Dimension key errors tab. You should handle a majority of the data quality issues in the Extraction, Transformation, and Loading (ETL) layer of your application. However, in some cases it's acceptable to ignore processing errors, particularly during the development stage when your ETL routines might be half-baked. The following table lists the remaining dimension processing options you can specify:
|
Processing option |
Description |
|---|---|
|
Key error action |
The default action in case of ... |
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
