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
To build a cube with Cube Editor
If you want to use ROLAP private dimensions or partitions, create these after the regular cube is created. The Cube Editor is used to create a ROLAP private dimension enabled for real-time updates; the Partition Wizard is used to create ROLAP partitions enabled for real-time updates.
Note ROLAP partitions must meet certain conditions to be enabled for real-time updates. For more information, see Real-Time Cubes.
To create a private dimension
To start the Partition Wizard