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 (188.8.131.52) 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
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 Functions → OLAP functions returns data from a dimensional object in two-dimension relational format. The OLAP function is: CUBE_TABLE
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
About OLAP DML Expressions → An OLAP DML expression has a data type and can also have dimensions. You can use expressions as … example, inflation*1.02 You can save an expression as a formula as described in \"OLAP DML Formulas\" How … Status\".) The return values of most OLAP DML functions are, in most cases, dimensioned by the union of … is documented in
OLAP DML Formulas → formula to represent the expression. Oracle OLAP does not store the data for a formula in a variable
About OLAP DML Commands → OLAP DML commands work in much the same way as commands in other programming languages—the one … exception is the looping nature of OLAP DML commands as discussed in \"OLAP DML Statements Apply to All … of the Values of a Data Object\". Many OLAP DML commands perform complex actions. Some of these … and the DEFINE
OLAP DML Allocation Objects → overview of how to allocate data using OLAP DML statements. It includes the following subtopics … : Introduction to Allocating Data Using the OLAP DML Features of Allocation in Oracle OLAP Allocating Data Handling NA Values When Allocating Data
2 OLAP Functions → The OLAP functions extend the syntax of the SQL analytic functions. This syntax is familiar to SQL … developers and DBAs, so you can adopt it more easily than proprietary OLAP languages and APIs. Using … the OLAP functions, you can create all standard calculated measures, including rank, share, prior … . This chapter describes
OLAP DML Data Types → In the OLAP DML, as in other languages, a data type is a collection of values and the definition of … one or more operations on those values. The Oracle OLAP DML supports the data types outlined in … Table 2-1, \" Summary of OLAP DML Data Types \". Table 2-1 Summary of OLAP DML Data Types Data Type … to the 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
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
4 OLAP DML Properties → This chapter contains the following topics: About OLAP DML Properties System Properties … : Alphabetical Listing System Properties by Category One topic for each of the OLAP DML system properties … , arranged alphabetically beginning with $AGGMAP. For other reference topics for the OLAP DML, see Chapter … 5, \"OLAP