Export (0) Print
Expand All

How to add an Analysis Services (formerly OLAP) cube to a model

SQL Server 2000

To enhance a model and create questions for OLAP cube data, add one or more OLAP cubes to a model, or  add an OLAP cube to an existing SQL-enabled project 

Note  The project must be either an OLAP or OLAP-enabled project.

To add an OLAP cube to a project

  1. On the Model menu, click Import Cubes.

  2. If asked, enter the name of the Analysis server on which the database resides, select the name of the database.

  3. From the Available list, double-click the desired OLAP cube or cubes.

See Also

Analysis Services in English Query

Enabling Analysis Services for an English Query Model

Model Editor

OLAP Cube Dialog Box

© 2014 Microsoft