Building a Real-Time Cube
A real-time cube is a regular cube that utilizes relational OLAP (ROLAP) shared dimensions, private dimensions, or partitions enabled for real-time updates. Real-time cubes support real-time OLAP in Microsoft® SQL Server™ 2000 Analysis Services.
Note Real-time OLAP features require a SQL Server 2000 data source to be used when creating the cube. To use real-time updates, an Analysis server must use a system administrator account to connect to SQL Server.
If you want to use a ROLAP shared dimension enabled for real-time updates, it is recommended that you create the dimension before creating the real-time cube. For more information about creating shared dimensions, see Creating Shared Dimensions.
The procedure for creating a real-time cube begins with the creation of a regular cube. To create a regular cube, use either the Cube Wizard or Cube Editor.
To start the Cube Wizard