|Oracle9i OLAP Services Concepts and Administration Guide for Windows
Release 1 (9.0.1) for Windows
Part Number A90371-01
Learning the Basics, 5 of 5
In its broadest definition, OLAP Services consists of the following components: the Oracle Java OLAP API, one or more OLAP services that run as child processes of a database instance, a metadata repository in each database instance, and tools within Oracle Enterprise Manager for creating OLAP metadata and managing OLAP services. However, OLAP Services is frequently used in this guide to refer to one or more components (such as an OLAP service child process) where distinctions among software components are not necessary.
All of the tools that you use to manage OLAP services are integrated into Oracle Enterprise Manager. You do not need to use a separate set of tools.
OLAP Services Instance Manager is the primary tool for managing OLAP services. You can use Instance Manager to do these system administration tasks:
For information about managing OLAP services, read "Introducing OLAP Services Instance Manager".
The OLAP component of Oracle Enterprise Manager generates metadata for use by applications. This metadata is used to identify the facts available for analysis, and to create and populate multidimensional objects. These objects are needed to process analytical queries using data stored permanently in an Oracle data warehouse.
For information about configuring your data warehouse for use with OLAP Services, read "Using Oracle Enterprise Manager".
Metadata is typically defined as "data about data." OLAP applications can query the metadata repository to find out what data is available for them to analyze and display. While the data is stored in tables in an Oracle data warehouse, the metadata identifies the data in terms of the multidimensional objects they will become in OLAP Services: dimensions, measures, and attributes. Moreover, the metadata defines the dimension hierarchies required to aggregate the data into meaningful levels of detail.
For more information about creating metadata, read "Creating Metadata".
Globalization Technology provides the Oracle standard for internationalizing and localizing Oracle products. Its use throughout Oracle9i allows text data in native languages to be passed between the RDBMS and OLAP Services without data loss or performance degradation.
Additional information about Globalization Technology is provided in "About Oracle Globalization Technology".
The metadata maps OLAP Services security directly to the security of the RDBMS. Users can access through OLAP Services only the data that they are authorized to access in the database.
Users can provide proof of identity in the following ways:
For more information about these security methods, refer to your Oracle9i networking and security documentation. For information about defining users, refer to "Granting Access Rights to Users".