How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Contents → Conventions What's New in the OLAP DML? New Features in the OLAP DML OLAP DML Statement Changes for … Oracle Database 11 g OLAP DML Statement Changes for Oracle Database 10 g OLAP DML Statement Changes for … Oracle Database 9 i 1 OLAP DML Basic Concepts What is the OLAP
Contents → Conventions What's New in Oracle OLAP? Oracle Database 11 g Release 2 (220.127.116.11) Oracle OLAP Oracle … Database 11 g Release 2 (11.2) Oracle OLAP Oracle Database 11 g Release 1 (11.1) Oracle OLAP 1 Overview … OLAP Technology in the Oracle Database Full Integration of Multidimensional Technology Ease of
OLAP Functions → OLAP functions returns data from a dimensional object in two-dimension relational format. The OLAP function is: CUBE_TABLE
Contents → Examples 2 OLAP Functions OLAP Functions in Alphabetical Order OLAP Functions By Category Aggregate … Functions Analytic Functions Hierarchical Functions Lag Functions OLAP DML Functions Rank Functions
OLAP → Oracle Database offers the industry's first and only embedded OLAP server. Oracle OLAP provides … entire spectrum of business intelligence and advanced analytical applications. Oracle OLAP uses a … historical data in real time. Oracle OLAP is fully integrated in the database, so that you can use … standard SQL
Contents → 11.2 What's New in 11.1 1 Introduction to the OLAP Java API OLAP Java API Overview What the OLAP Java … API Can Do Describing the Classes in the OLAP Java API Describing the Dimensional Data Model … Implementing the Dimensional Data Model Organizing the Data for OLAP Accessing Data Through the OLAP
Contents → List of Examples List of Figures List of Tables Title and Copyright Information Preface Audience Documentation Accessibility Related Documents Conventions 1 Customizing With XML Documents Describing SQL Reports Creating an XML Document for SQL Reports Example of a Simple Report Creating Report Folders Using Bind Variables to Restrict the Report Contents Creating Reports in Object Folders Reference:
OLAP → Online Analytical Processing. OLAP is characterized by dynamic, dimensional analysis of historical data.
Upgrading Analytic Workspaces From OLAP 10g to OLAP 11g → Analytic Workspaces From OLAP 10g to OLAP 11g You can upgrade an Oracle OLAP 10 g analytic workspace … to OLAP 11 g by saving the metadata in an XML template and using it to create a new analytic … : Oracle recommends using Analytic Workspace Manager for performing upgrades. See the Oracle OLAP User's
OLAP Transformations → OLAP transformations enable Oracle Warehouse Builder users to load data stored in relational … dimensions and cubes into an analytic workspace. The OLAP transformations provided by Oracle Warehouse … transformations are used for cube cloning in Oracle Warehouse Builder. Use these OLAP transformations … used to explain these OLAP
6 OLAP DML Programs → This chapter provides information about creating OLAP DML programs. It includes the following … topics: Programs Provided With the OLAP DML Creating OLAP DML Programs Specifying Program Contents … Compiling Programs Testing and Debugging Programs Executing Programs Common Types of OLAP DML Programs User-Written Programs
OLAP DBA Scripts → You can download a file that contains several SQL scripts from the Oracle OLAP Web site on the … this URL: http://www.oracle.com/technology/products/bi/olap/olap_dba_scripts.zip Table 7-6 … OLAP DBA Scripts SQL Script Description aw_objects_in_cache Identifies the objects in the buffer … . olap_pga_performance Determines how much
Introduction to OLAP Architecture → Oracle Data Warehouse for Communications (Oracle Communications Data Model Relational) contains the lowest level CDR details, low level combination of base tables and the summary, average, and so on, of Base and Derived data. Oracle Communications Data Model Relational was developed in a relational database.
OLAP Component Load Scripts → The OLAP component load scripts includes the following scripts: OLAP Component Initial Load Script … OLAP Component Incremental Load Script OLAP Component Initial Load Script The OLAP cube initial load … schema into the analytic workspace dimension and cubes and typically, executes the OLAP
OLAP C Patch Required → Before installing Oracle Retail Data Model you need to obtain the appropriate OLAP C Patch for your … platform and install the OLAP C patch for Oracle Database 18.104.22.168.0. Do the following to obtain … and install the OLAP C patch: To obtain the appropriate patch for your platform, go to My Oracle … select Enter. Choose the patch
Recompiling OLAP Views → statements to recompile the OLAP views in the sample schema: ALTER VIEW CUST_RVN_VIEW_OLAPC COMPILE; ALTER VIEW CUST_RVN_VIEW_FIN COMPILE;
OLAP Dimensions Overview → Table 8-1 lists the OLAP dimensions and each dimension description includes the following … part of On-Line Analytical Processing (OLAP). A dimensional data model is as much a logical model as … , hierarchies, levels, and attributes. For a more complete introduction to the OLAP dimensional … models, see Oracle OLAP
Recompiling OLAP Views → the sample schema: $ORACLE_HOME/ordm/pdm/olap/ordm_olap_11_2_cubeview_extnd.sql
Connecting to Oracle OLAP → To connect to the Oracle OLAP server in an Oracle Database instance, an OLAP Java API client … classes that you use to establish a connection to Oracle OLAP are in the Java archive file ojdbc5.jar
About OLAP DML Functions → OLAP functions work in much the same way as functions work in other programming languages. They … initiate action and return a value. The one exception is the looping nature of OLAP DML functions as … discussed in \"OLAP DML Statements Apply to All of the Values of a Data Object\". Most of the OLAP DML … functions