OLAP Cube Creation

You are almost ready to create the OLAP cube to fulfill the DSS needs of the users. Most of your construction phase will be spent using Analysis Manager. All wizards and editors are invoked from there. When you first fire up Analysis Manager, you must, of course, already have installed AS.

The Analysis Manager

The Analysis Manager is launched from the AS Services Program group on the Start menu. You will typically keep the Meta Data tab active as your current tab rather than the Getting Started tab. One of the first things that must be done is to create an Analysis Server database through the Action menu option. (You can also do this by right-clicking when your mouse is positioned at a connected Analysis Server.) Figure 42.6 ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.