| SAS/MDDB Server Administrator's Guide |
SAS/MDDB Server
software enables users to create and manage MDDBs to provide fast and easy
data access by tools such as multidimensional data viewers. Used as a data
summarization, storage, and retrieval mechanism for an organization's OLAP
solution, MDDBs enable better decision making by giving business users quick,
unlimited views of multiple relationships in large quantities of summarized
data at any cross section of business dimensions. A business dimension can
be any vision of the data that is useful in making business decisions--for
example, time, geography, or product.
Taking advantage of a graphical user interface or a
programming interface, you can use SAS/MDDB Server
software to quickly and easily build, maintain, and optimize multidimensional
data. For example, you can
- use warehouse data to design multidimensional
data models based on the least amount of summarization, the most amount of
summarization, or projections of the summarizations most likely to be requested
by users
- build multidimensional data structures for interactive
or batch submission
- change the way that multidimensional data is structured
- control which statistics are stored with
which
multidimensional data structures
- control the balance between storage and performance
- perform incremental
updates.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
