Oracle 9i OLAP Services. Developer's Guide to the Oracle

The Oracle 9i OLAP companies Developer s consultant to the Oracle OLAP API introduces Java programmers to the Oracle OLAP API the Java program programming interface for Oracle OLAP companies. via OLAP prone, the OLAP API offers entry to information saved in an Oracle database. The OLAP API's functions for querying, manipulating, and providing info are rather fitted to functions that practice on-line Analytical Processing.

Show description

Read Online or Download Oracle 9i OLAP Services. Developer's Guide to the Oracle OLAP AP PDF

Best databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This ebook is a short reference for the SQL dialect supported through the Teradata Relational Database administration procedure. The ebook can be a short connection with the supported info description words for the Teradata RDBMS and the knowledge Dictionary. The viewers for this fast reference is all clients of Teradata SQL who want speedy, non-detailed information regarding easy methods to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make types and studies priceless boost types to entry the knowledge you would like and make studies that make experience! for those who notion you needed to use a spreadsheet software to provide stories and types, wager what! entry can prove great-looking varieties and experiences that truly convey what is going on along with your facts -- for those who know the way to invite it properly.

Extra resources for Oracle 9i OLAP Services. Developer's Guide to the Oracle OLAP AP

Sample text

The second region is the MdmHierarchy called mdmTimesDimFisHier, which also has 1529 elements. The set of elements for mdmTimesDim is the union of the elements from its two MdmHierarchy objects. Because no element can appear in both MdmHierarchy objects, mdmTimesDim has 3058 elements. Note that a calendar year begins on January 1, while a fiscal year begins on July 1. The following table lists the elements of the union MdmHierarchy called mdmTimesDim. To distinguish the elements of mdmDay and mdmFisDay, whose values are identical, the word “(fiscal)” appears next to the values for mdmFisDay.

See Appendix A for details. The sample code specifies the following information: ■ The URL that locates the target Oracle database for the connection. The URL has the following components, which are separated by colons. The prefix sess_iiop The host name. com The listener port number for IIOP services. In the sample code, it is 2481. The system identifier (SID) for the Oracle database instance. In the sample code, it is bm1212. ■ 3-8 The object name for the OLAP service that will accept the connection.

The OLAP API can also be extended to support other models. The data in an Oracle database must be prepared by a database administrator in order to support the MDM model. Even though recent SQL enhancements have introduced some multidimensional objects, such as dimension, there are other objects and characteristics that must be added. Data preparation A database administrator starts with a data warehouse that is organized according to a star or snowflake schema. The schema specifies dimension tables as well as fact tables, which contain measures.

Download PDF sample

Rated 4.36 of 5 – based on 25 votes