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
Oracle9i OLAP Developer's Guide to the OLAP DML -- Contents → … Analytic Workspaces SQL and the OLAP DML The OLAP API and the OLAP DML Using the OLAP DML How to Use … the OLAP DML to Analyze Data Creating an Analytic Workspace Loading Data Into Analytic Workspaces … from OLAP Worksheet Procedures: How to Open OLAP Worksheet Establishing a Connection Executing … Analytic Workspaces
Contents → Skip Headers Oracle9 i OLAP Developer's Guide to the OLAP API Release 2 (9.2) Part Number A95297-01 … Introduction to the OLAP API OLAP API Overview Multidimensional Concepts And the OLAP API What Type … API? Context for OLAP API development Access to Data and Metadata Through the OLAP API MDM Model in … the OLAP API Access to
Pro*PL/I Supplement to the Oracle Precompilers Guide -- Contents → VARYINGReturning Nulls to a CHARACTER (N) Handling Character Data Effects of the MODE Option The Oracle Datatypes … SQLCHECK Connecting to Oracle Automatic Logins Concurrent Logins 2 Error Handling and Diagnostics
Programmer's Guide to the Oracle Precompilers Release 7.3 → Programmer's Guide to the Oracle ® Precompilers Preface What This Guide Has to Offer Who Should
Pro*FORTRAN Supplement to the Oracle Precompilers Guide Release 7.3 → Pro*FORTRAN ® Supplement to the Oracle ® Precompilers Guide Preface What This Manual Has to Offer … Embedding PL/SQL Cursor Variables Connecting to Oracle Error Handling and Diagnostics Error Handling
A Program Example Sample Tables Meeting Program Requirements The Declare Section INCLUDE Statements… → Character Sets Connecting to Oracle Concurrent Logons Embedding OCI (Oracle Call Interface) Calls … How to Begin and End Transactions Using the COMMIT Statement Using the ROLLBACK Statement Using the … Dynamic SQL What Is Dynamic SQL? Advantages and Disadvantages of Dynamic SQL When to Use Dynamic SQL … ? Developing a User Exit
Limiting Using Value Position in an Unrelated Dimension → You can use the LIMIT command with the NOCONVERT keyword to insert a value into a dimension status … , when there is a one-to-one correspondence between the product dimension in two analytic workspaces … ). The simplified syntax for using the LIMIT command in this way is shown below: LIMIT dimension TO … related to
Errors When Limiting Status to a Null Value → An error will not be signaled when you try to limit the status of a dimension or valueset that has … any values to a newly defined dimension WEEK, then the following command does not cause an error … . LIMIT week TO FIRST 10 However, the following command does cause an error because PETE is not a value … . LIMIT week TO
Process: Writing Programs that Populate Analytic Workspaces with Relational Data → To populate the analytic workspace structures with data from relational tables, you write and
Establishing a Connection → Take these steps to establish a connection to Oracle OLAP: From the OLAP Worksheet menu bar, choose … Server. Choose Connect. You see the Login to Database box. Enter valid database user credentials … :rel9i. Oracle controls your access to data on the basis of your database user ID. Your user ID must … have access
Effect of the ROLLBACK Command → The OLAP DML does not provide a way to issue a ROLLBACK command; however, you could execute one in … executed in your session, Oracle OLAP checks to see whether there are uncommitted updates in an attached … action in response to the ROLLBACK command. This means that, if you have not issued an UPDATE command … workspace during
Processing Records Individually → or more distinct types of records mixed together in a single file. You might even have to decide … what to do with the data in a record based on the contents of one or more of its fields. The FILENEXT … function and the FILEVIEW command allow you to retrieve one record at a time from a file and look at … by FILENEXT is then available
Creating Simple Nondimensional Source Objects → createRangeSource methods on the DataProvider class. These Source objects are sometimes referred to … a Source with a single value of 4. To create this Source you issue the code shown in Example 5-3
MdmDimension Class → Skip Headers Oracle9 i OLAP Developer's Guide to the OLAP API Release 2 (9.2) Part Number A95297-01 … are within the MdmHierarchy, they correspond to elements in MdmLevel objects. Therefore, loosely … the MdmDimension to values representing some characteristic of the elements. To obtain the … about the MdmDimension
What is the Extent of a Cursor? → The extent of a Cursor is the total number of elements it contains relative to any slower varying … to the value of its slower varying output. The child Cursor objects are layered horizontally with the … example, to display the correct number of columns or correctly-sized scroll bars. The extent, however … , can be expensive to
OLAP API Overview → Skip Headers Oracle9 i OLAP Developer's Guide to the OLAP API Release 2 (9.2) Part Number A95297-01 … Home Book List Contents Index Master Index Feedback Introduction to the OLAP API, 2 of 6 OLAP API … OLAP, an Oracle component. The purpose of the OLAP API is to facilitate the development of OLAP … applications, which allow users
Arguments in a User-Defined Function → … However, if you supply an argument to a user-defined function in a context that loops over a … product units that are expected to be sold. Suppose also that you define a program named … number of units that were actually sold for that cell. The program returns a Boolean value to the … calling program. It returns YES
Arithmetic Operators → a numeric expression, the expression is evaluated according to standard rules of arithmetic. The … priority are evaluated from left to right. Table 4-2 Arithmetic Operators Operator Operation
Importing and Fetching Relational Table Data into Analytic Workspace Objects → After you open a cursor, you can use a SQL IMPORT or a SQL FETCH command statement to copy data … you have access rights to the tables that you want to use. SQL IMPORT or a SQL FETCH both copy data … and assigns the retrieved data to OLAP objects. When you use a FETCH statement to retrieve data
Suppressing the Sort When Limiting to a Related Dimension → The LIMIT.SORTREL option controls whether or not a sort is done when you limit a dimension to a … related dimension. You can suppress the sort that occurs when you limit a dimension to a related … dimension by setting LIMIT.SORTREL to no. This can significantly improve performance when the dimension