Oracle Essbase & Oracle OLAP : the guide to Oracle's by Michael Schrader; et al

By Michael Schrader; et al

Show description

Read or Download Oracle Essbase & Oracle OLAP : the guide to Oracle's multidimensional solution PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time info entry and knowledge sharing throughout your disbursed framework utilizing the specialist details during this Oracle Press consultant. Oracle Streams 11g facts Replication explains tips to organize and administer a unified firm facts sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software convey four Recipes offers an example-based method of studying program show - the ground-breaking, fast program improvement platform incorporated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply desires a very good instance or to kick commence their pondering and get pointed within the correct course.

Extra info for Oracle Essbase & Oracle OLAP : the guide to Oracle's multidimensional solution

Sample text

Trigger programs are frequently written to maintain application-specific metadata. Trigger programs have certain characteristics depending on the statement that triggers them. Some trigger programs execute before the triggering statement executes; some after. Oracle OLAP passes arguments to programs triggered by some statements, but not others. Oracle OLAP does not change dimension status before most trigger programs execute, but does change dimension status before some MAINTAIN statements trigger program execution.

Code the actual program as described in"Specifying Program Contents" on page 5-2. 4. Keep the following points in mind when coding trigger programs: ■ Use Table 24–1, " Trigger Program Characteristics" on page 24-12 to determine if Oracle OLAP will pass values to the program. If it will, use the 1-14 Oracle OLAP DML Reference OLAP DML as a Data Manipulation Language ARGUMENT command to declare these arguments in your program and the VARIABLE command to define program variables for the values. ) ■ ■ ■ 5.

You can assign or delete an alias with an AW ALIASLIST statement. An alias is in effect from the time it is assigned to the time that the workspace is detached (or until the alias is deleted). Therefore, each time you attach an unattached workspace, you must reassign its aliases. One reason for assigning an alias is to have a short way to reference a workspace that belongs to a schema that is not yours.

Download PDF sample

Rated 4.09 of 5 – based on 4 votes