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 … Oracle11 g OLAP DML Statement Changes for Oracle10 g OLAP DML Statement Changes for Oracle9 i 1 OLAP DML … Basic Concepts What is the OLAP DML? What You Can Do Using
Contents → Conventions What's New in Oracle OLAP? Oracle Database 11 g Release 11.1 Oracle OLAP 1 Overview OLAP … Hierarchies Attributes 2 Getting Started with Oracle OLAP Installing the Sample Schema Database Management … the OLAP Views Cube Views Discovering the Names of the Cube Views Discovering the Columns
Handling Errors in Nested Programs → When handling errors in nested programs, the error-handling section in each program should restore the environment. It can also handle any special error conditions that are particular to that program. For example, when your program signals its own error, then you can include statements that test for that error. Any other errors that occur in a nested program should be passed up through the chain of
Passing Arguments → Use ARGUMENT statements to declare both simple and complex arguments (such as expressions). ARGUMENT statement also make it convenient to pass arguments from one program to another, or to create your own user-defined functions since using these statements you can declare an argument of any data type, dimension, or valueset. Any ARGUMENT statements must precede the first executable line in the program.
Using Level Markers → When you are saving the values of several dimensions and options, then PUSHLEVEL and POPLEVEL statements provide a convenient way to save and restore the session environment. You first use a PUSHLEVEL statement to establish a level marker. Once the level marker is established, you use a PUSH statement to save the status of dimensions and the values of options or single-cell variables. When you place
Trapping an Error → To make sure the program works correctly, you should anticipate errors and set up a system for handling them. You can use a TRAP statement to turn on an error-trapping mechanism in a program. When error trapping is on and an error is signaled, then the execution of the program is not halted. Instead, error trapping does the following: Turns off the error-trapping mechanism to prevent endless looping
Passing an Error to a Calling Program → on when you want the error message to be produced. With the first method, Oracle OLAP produces the … second method, Oracle OLAP passes the error through the chain of programs first and then produces the … Oracle OLAP sends an error message to the current outfile. Passing an Error: Method One Using this … method, Oracle OLAP
Creating User-Defined Functions → One type of program that is commonly written is a user-define function that you can use in OLAP DML … statements in much the same way as you use an OLAP DML function. A user-defined function is simply … an OLAP DML program that returns a value. For an example of a user-defined function, see Example 9
Handling Arguments Without Converting Values to a Specific Data Type → Sometimes you want your OLAP DML program to be able to handle arguments without converting values
Handling Errors → When an error occurs anywhere in a program, Oracle OLAP performs the following actions: Stores the … message. When ECHOPROMPT is YES, then Oracle OLAP echoes input lines, error messages, and output
Specifying Program Contents → The content of a program consists of the following OLAP DML statements: A PROGRAM statement that … of the OLAP Worksheet.) (Optional) VARIABLE statements that define any local variables. (Optional … .) Additional OLAP DML statements that specify the processing you want performed. You can use almost any of … the OLAP
Suppressing Error Messages → When you do not want to produce the error message that is normally provided for a given error, then you can use TRAP statement with a NOPRINT keyword. TRAP ON error NOPRINT When you use the NOPRINT keyword with TRAP, control branches to the error label, and an error message is not issued when an error occurs. The statements following the error label are then executed. When you suppress the error
Passing Arguments as Text with Ampersand Substitution → It is very common to pass a simple text argument to a program. However, there are some situations in which you might want to write more general programs or pass a more complicated text argument, such as an argument that is all of the data in one of the analytic workspace objects or the results of an expression. In these cases, you can pass the argument using a substitution expression. Passing an argument
Changing the Program Environment → To perform a task within a program, you often need to change the output destination or some dimension and option values. For example, you might run a monthly sales report that always shows the last six months of sales data. You might want to show the data without decimal places, include the text \"No Sales\" where the sales figure is zero, and send the report to a file. To set up this program environment,
Ways to Save and Restore Environments → The following suggestions let you save the environment of a program or a session: When you want to save the current status or value of a dimension, a valueset, an option, or a single-cell variable that will be changed in the current program, then use PUSHLEVEL and PUSH statements. You can restore the current status values using POPLEVEL and POP statements. When you want to save, access, or update
Using CONTEXT to Save Several Values at Once → As an alternative to using PUSHLEVEL and POPLEVEL, you can use the CONTEXT command. After you create a context, you can save the current status of dimensions and the values of options, single-cell variables, valuesets, and single-cell relations in the context. You can then restore some or all of the object values from the context. The CONTEXT function returns information about objects in a context.
Creating Your Own Error Messages → stored in the ERRORNAME option, just as an OLAP DML error name is automatically stored. When you … specify your own error message in a SIGNAL statement, then your message is produced just as an OLAP DML
Handling Errors While Saving the Session Environment → To correctly handle errors that might occur while you are saving the session environment, place your PUSHLEVEL statement before the TRAP statement and your PUSH statements after the TRAP statement. PUSHLEVEL 'firstlevel' TRAP ON error PUSH... In the abnormal exit section of your program, place the error label (followed by a colon) and the statements that restore the session environment and handle
Using Multiple Arguments → A program can declare as many arguments as needed. When the program is executed with arguments specified, the arguments are matched positionally with the declared arguments in the program. When you run the program, you must separate arguments with spaces rather than with commas or other punctuation. Punctuation is treated as part of the arguments. For an example of passing multiple arguments, see
Program Flow-of-Control → Like most programming languages, the OLAP DML has a number of statements that you can use to … in an OLAP DML program because of the intrinsic looping nature of many OLAP DML statements. Table 4-1 … , \"Statements For Determining Flow-of-Control\" lists OLAP DML flow-of-control statements. The … looping characteristic