Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Chapter Summary

To	Do this
Synchronize an OLAP database with a warehouse database	Right-click the OLAP database folder, and click Process Database.
Add new members to a shared dimension without invalidating existing cubes	Right-click the dimension, and click Process. Then click the Incremental Update option.
Add data for new records to an existing cube	Right-click the cube, and click Process. Click the Incremental Update option.
Avoid double-counting values when incrementally updating a cube	Either put new incremental values into a separate fact table or add a filter expression that eliminates fact table rows that have already been loaded into the cube.
Create a new partition for a cube	Expand the cube folder, and right-click the Partitions folder. Then ...