Oracle Database 10 g: Using OLAP What you will learn: This class is not applicable to Oracle9i users. In Day 1 of the course you will learn Oracle?s OLAP technology, terminology ...
http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D17505GC10&p_org_id=1001&lang=US&source_call=
Using OLAP DML Expressions in SELECT FROM OLAP_TABLE Statements. You can use OLAP DML commands within your SELECT FROM OLAP_TABLE statements as described in:
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_app_sqlfunc002.htm
ExitCertified is a global IT education provider delivering vendor authorized technology training with Sun Microsystems, Veritas, Symantec, Oracle, Linux (Guru Labs), PMI ...
http://www.exitcertified.com/courses/details/db-10g-olap.html
Creating Relational Views Using OLAP_TABLE. OLAP_TABLE is a SQL function that returns a table of objects that can be joined to relational tables and views, and to other tables of ...
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_app_sqlfunc001.htm
5 Querying Dimensional Objects Using OLAP Tools. OLAP tools are designed specifically to locate all cubes and dimensions that are accessible to the current user.
http://www.stanford.edu/dept/itss/docs/oracle/10gR2/olap.102/b14349/olap_queries.htm
7 Using the OLAP Catalog. This chapter describes methods of creating a logical dimensional model. It includes the following sections: Choosing a Method for Creating OLAP Catalog ...
http://www.mcs.csueastbay.edu/support/oracle/doc/10.2/olap.102/b14349/cwm.htm
Oracle9 i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01
http://moracle.emporia.edu/9idoc/901_doc/olap.901/a86720/embedsq3.htm
By using an OLAP cube as the data source for the PivotTable and PivotChart reports in Excel, you can quickly build PivotTable and PivotChart reports that are visually attractive ...
http://msdn.microsoft.com/en-us/library/Aa140063(office.10).aspx
If you want to edit the program using OLAP Worksheet, then follow the procedure outlined below. Start OLAP Worksheet. Connect to an analytic workspace.
http://moracle.emporia.edu/9idoc/901_doc/olap.901/a86720/desprog4.htm#1002038
Example 34-6 Script for a Measure View Using OLAP_TABLE. CREATE TYPE awunits_row AS OBJECT ( awtime VARCHAR2(12), awcustomer ...
http://www.mcs.csueastbay.edu/support/oracle/doc/10.2/olap.102/b14350/olap_table002.htm
Sanjay Soni. March 2003. Applies to: Microsoft® SQL Server? 2000. Summary: Learn techniques to answer useful Distinct Counts business questions by using the Sales and ...
http://msdn.microsoft.com/en-us/library/aa902680(SQL.80).aspx
Read about Course 2074: Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000. Course 2074 provides the knowledge and skills necessary to design, implement, and ...
http://www.microsoft.com/learning/en/us/syllabi/2074AFinal.mspx
7 SQL Access to Analytic Workspaces. This chapter introduces methods of accessing the data in an analytic workspace using SQL. Most of these methods can be used at runtime as part ...
http://download-west.oracle.com/docs/cd/B14117_01/olap.101/b10333/sql.htm#sthref489
Online analytical processing (OLAP) functions are very flexible and powerful. Using them, you may come up with simple solutions to some problems that would otherwise require either ...
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401kuznetsov/index.html
About this chapter . This chapter describes online analytical processing (OLAP) functionality. OLAP is a method of data analysis for information stored in relational databases.
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbugen9/00000342.htm
Example 26-6 Script Using FETCH with OLAP_TABLE. CREATE TYPE measure_row AS OBJECT ( time VARCHAR2(20), geography VARCHAR2(30 ...
http://www.itk.ilstu.edu/docs/Oracle/olap.101/b10334/olap_table.htm
CFDJ ColdFusion Developer's Journal, SYS-CON Media, NJ, Breaking Technology News ... EJM wrote: Well versed article and nice explanation. Easy to understand especially for us w...
http://coldfusion.sys-con.com/node/46790
EDIT. The EDIT command displays an OLAP Worksheet Edit window. The command is available only when you are using OLAP Worksheet to access Oracle OLAP.
http://www.acs.ilstu.edu/docs/Oracle/olap.101/b10339/x_deprdecl010.htm
Learn the benefits of adding the OLAP Option to your OracleBI Discoverer reporting and analysis and the steps required to make OLAP reporting available to users.
http://www.oracle.com/technology/pub/articles/rittman_olap.html
Named set "Mountain Bikes" added to an OLAP PivotTable using the CalculatedMembers collection in the object model . Note that Excel 2007 only support named sets consisting of members ...
http://blogs.msdn.com/excel/archive/2008/02/05/common-questions-around-excel-2007-OLAP-PivotTables.aspx |
|
