Jaa


Specify Object Counts (Usage-Based Optimization Wizard)

Use the Specify Object Counts page to automatically calculate the count of objects in the cube or to manually enter estimated counts. During the aggregation design process, the Usage-Based Optimization Wizard uses the object counts to estimate storage requirements.

Options

  • Cube Objects
    Displays the measure groups, dimensions, and attributes in the cube. Click an item listed in this column to either show or hide the associated measure groups, dimensions, and attributes.
  • Estimated Count
    Type the estimated number of elements that are contained by the object.
  • Partition Count
    Type the estimated number of elements that are contained by the object that are also contained by the partition.
  • Count
    Calculates and repopulates the values in the Estimated Count column for all objects listed in the Cube Objects column.

    Note

    This option may take some time to finish. To stop the calculation process at any time, click Stop.

  • Stop
    Stops the calculation and repopulation of the values in the Estimated Count column.

See Also

Reference

Usage-Based Optimization Wizard F1 Help (SSAS)
Analysis Services Wizards (SSAS)

Help and Information

Getting SQL Server 2005 Assistance