Oracle Reports Services – Overview

Oracle Reports Services is a reporting tool in the Oracle Fusion Middleware suite designed to deliver reporting requirements to wide range of external and internal organizational users.   Reports Services includes: Reports Developer a WYSIWYG (What You See Is What You Get) reporting tool and Reports Server capable of accessing multiple data source, generate and distribute report via the webpages, email, or paper.   Oracle Reports Services is a mature reporting tool set that satisfies most reporting needs of any organization.

 

Larry Catt

OCP

Oracle Essbase Plus – Overview

Oracle Essbase is a Business Intelligence (BI) Online Analytical Processing application that allows for the deployment of existing applications and development of performance management Applications.   It has ability to model complex business opportunities and update applications data stores with discovered information. It can create views of business processes in a hierarchical fashion to provide insight into various levels of business processes. Essbase is a component of the Oracle BI Suite and integrates with many of the reporting, analysis, and dashboard applications available from a Fusion Middleware implementation.

 

Larry Catt

OCP

Oracle Fusion Middleware – Concepts

Oracle Fusion Middleware is a collection of software packages to support an organization IT needs for mid-tier services and processes seating between server operating systems and end-users.   The mid-tier can encompass the following types of software packages: Development, Management, Content Management, Reporting, Analysis, Data Servers, Web Servers, Application Servers, and task specific Applications.   It is important to note, that not all components are require in any given Oracle Fusion Middleware implementation and that most components are implemented based on organization needs.   However, there are key components which normally always exist, such as FMW Infrastructure and WebLogic web server.   This article describes the concepts common to a FMW implementation.

 

There exist two type of components in a FMW implementation: Java Components and System Components.    Java components are all components which are Java EE applications or services and deployed via Oracle WebLogic in a domain template.   An example of a Java component is Oracle SOA Suite.    System Components are non-JAVA EE applications and services which are managed by Oracle Process Manager and Notification (OPMN) utility.  OPMN utility provides intercommunication and management for non-Java EE application services to FMW implementation.

 

FMW implementation once configured will contain a minimum of the following:

  1. Oracle WebLogic Install.
  2. At least one WebLogic domain containing:
    1. One Administration Server containing WebLogic console and FMW Control.
    2. At least one Managed Server containing components such as WebCenter or SOA Suite.
  3. One or more Oracle Instances which contain one or more system components (Oracle HTTP Server).
  4. One or more databases for metadata repository.

 

 

FMW has a flexible directory structure base on various HOME types which allow for intercommunication of each subcomponent.   FMW has 6 basic homes to include:  Middleware home, Oracle Home, Oracle Common Home, WebLogic Home, Instance Home, and Domain Home.  Each of these homes are detailed below:

  1. Middleware Home is the root directory for Oracle WebLogic Server, Oracle Home, and Oracle Common Home. It can reside on Local or remote disks via NFS.   Default name of Oracle Middleware home is /Oracle/Middleware on UNIX and \Oracle\Middleware on Windows.
  2. Oracle Home is the directory structure for a component or software suite and it is below the Middleware Home, Oracle Home can be associated with multiple Oracle Instances and WebLogic Domains. Middleware can support multiple Oracle Homes on single install.
  3. Oracle Common Home is the directory structure to support the storage of binary and library components for FMW Control and Java Required Files.   There exists only one Oracle Common Home for each FMW install.
  4. WebLogic Server Home is the directory structure for files needed by WebLogic Server. It is always at the same level as Oracle Home and under the FMW Home.
  5. Domain Home is the top level directory of a WebLogic Server administration domain. It is always separate from the directory structure of WebLogic Server Home.   It can be placed anywhere and does not need to be under FMW Home.
  6. Instance Home is the top level directory structure of a FMW Component such as SOA Suite.   It can be placed anywhere and does not need to be under FMW Home.

 

 

 

An Administration Server is the control entity for configuration of an entire domain. It updates the configuration files and manages resources for the domain.  Each domain has one administration server.   The administration Service is used through WebLogic Server Console, WebLogic Scripting Tool (WLST) or a home grown console using JMX (Java Management Extension) client.

 

A Managed Server contains a system application, Web Services, or other resources. Managed Server works within a specific domain.  Managed Servers can be configured as clusters to allow for increased performance of a system application or service.

 

A Node Manage is a separate process for WebLogic Server and can perform common operations of the Managed Server. This provides increased scalability for applications and services.

 

 

 

Larry Catt

OCP

Oracle Endeca Information Discovery – Overview

Endeca Information Discovery is a Business Intelligence (BI) application which provides analytic tools and accesses to traditional RDBMS, data warehouses, and non-traditional data stores.   It allows access to data analysis by non-technical personnel with easy to use tool sets while maintaining data integrity and security.   Endeca delivers direct access by decision makers to the information which drives productive business decisions.

 

Larry Catt

OCP

Oracle Big Data Discovery – Overview

Oracle Big Data Discovery is a Business Intelligence (BI) application used to analyze large volumes of unorganized, organized, stored and streaming data.   Regardless of where the data is or how it is stored, Big Data Discovery is designed to help view, perform analytics on, execute reports against, create dashboards, perform calculations on, and refine data for additional sharing and analysis.   This application is designed to reduce the amount of data preparation required to analyze large disjointed data sets regardless of their origin.   Allowing for the organization’s focus to be analytics against the data and not the management of the data.

 

Larry Catt

OCP

Oracle Data Visualization – Overview

Business Intelligence (BI) software is designed to perform analytical reviews of an organizations internal and external data stores to discover trends that guide organizational success.   This type of software has traditionally be the domain of IT professionals specializing in reporting and analysis arenas.   However, Oracle Data Visualization suite is designed to simplify the analysis of data stores and present the results directly to decision makers through graphical data representation.   It allows the non-technical decision makers to view data as graphical representation, drag and drop the data to various charts and graphs, perform complex calculations, and upload additional data, reports, and analysis.

 

Larry Catt

OCP

Oracle Hyperion Workforce Planning – Overview

Hyperion Workforce Planning is a software package to manage an organizations workforce to include: Head count number, salary, compensation, benefits, and analysis of all related expenses, forecasting impact of increase/decrease and organizational impacts.    The software integrates into Oracle Fusion Middleware other management software packages for seamless implementation.

 

Larry Catt

OCP

Oracle Hyperion Performance Scorecard – Overview

Determining the health and overall performance of an organization allows it to avoid future faults which could cause loss of business.   To gauge the health or performance of anything you must determine what parameters it will be graded against.   This is the functionality of Oracle Hyperion Performance Scorecard application.   It allows you to developing score, set them against industry standards, create accountability mapping, measuring performance, and providing information sharing facilities.   Performance Scorecard integrates with Enterprise Performance Management and other Fusion Middleware application to provide a complete organizational performance application.

 

Larry Catt

OCP

Oracle Performance Management (OPM) – Overview

Successful organization have a need to increase productivity of their tasks and coordinate individual goals with those of the overall organization.   These requirements create the need for software which allows an organization to build, evaluate, track, and align goals of individuals to meet overall business goals.   Oracle Performance Management (OPM) is software that provides these functionality.   OPM is a component of Oracle Human Resources suite.

 

Larry Catt

OCP

 

 

Oracle tips and tricks.