O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Cube Processing

Before browsing or querying the cube, you must refresh the data it contains by processing the cube. You generally accomplished this on a regular schedule through SQL Server Agent or an SSIS package after you update the data warehouse.

Processing Methods

You can process the cube as a whole or individual object such as the dimensions or a single partition. This is particularly useful so that you can process different partitions on different schedules. Several options are available when you process the cube and vary it based on the object chosen. Figure 53.13 shows the cube processing screen. Each option can cause different objects to process:

Figure 53.13 Setting processing options for your cube.

53.13
  • Process Default: Processes only unprocessed objects.
  • Process Full: Processes the structure, data, and aggregations.
  • Process Data: Processes only data.
  • Process Structure: Processes the cube definition, but not any data.
  • Unprocess: Removes the data stored in the cube.
  • Process Index: Processes only aggregations.
  • Process Incremental: You must provide a query that contains the fact data for processing.

Other Considerations

Data integrity functionality in Analysis Services addresses inconsistencies that would otherwise cause improper data presentation. Analysis Services views these inconsistencies in two categories: Null Processing and Key Errors. Analysis Services also enables ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required