Export (0) Print
Expand All
Expand Minimize

Partition Processing Settings Dialog Box

SQL Server 2000

Partition Processing Settings Dialog Box

Use this dialog box to specify settings for processing a cube. Settings in this dialog box are used whenever a cube or one of its partitions is processed.

This dialog box appears when, in DTS Designer, you click Cube Settings in the Analysis Services Processing Task dialog box.

Important  Cube or partition processing options are stored with the meta data for the cube or partition. Changes to the settings for these options replace previous settings for the cube or partition, regardless of whether the options are set by Analysis Manager, Data Transformation Services (DTS) tasks, or Decision Support Objects (DSO) applications.

Options

After all aggregations have been calculated

Select to make data unavailable for browsing until all aggregations have been computed. This is the default option.

Immediately after data is loaded

Select to make data available for browsing after it has been loaded but before all aggregations have been computed. This means that new data is available for querying sooner, but the Analysis server may not be as responsive to query execution.

Stop processing after encountering missing dimension key errors

Select to stop processing if dimension key errors are encountered.

  • Processing will stop after

    Specify the number of errors (the default is 0).

Ignore all missing dimension key errors

Select to have processing continue despite dimension key errors.

Log dimension key errors to a file

Select to log dimension key errors to a file. Use one of the following options to provide the file name and path.

  • File path and name

    Type a path to the text file in which you want to log dimension key errors.

  • Browse

    Click to select a local or network location for the file.

See Also

Process a Cube Dialog Box

Processing Cubes

Show:
© 2015 Microsoft