Category Archives: OBIEE architecture

How to Remove Null Value from Dashboard prompts in OBIEE

Currently i am facing a weird issue in Dashboard prompts of OBIEE 12c.There are invalid Null values that are not present in database but showing in prompt columns in OBIEE. For some of the columns Null Values is valid but for other it is not. So Business wants to display null value in prompt only if it is valid and appears in DB column as well.

There are two ways to fix this issue,

a) edit this prompt and check the ‘Require user input’ property (doesnt work max times)

b) At RPD level , uncheck the Nullable option under the physical column as shown below:

obiee snippet

Then restart / recycle all the servers. Untill then this change wont get impacted. Do it for only necessary columns which will never have NULL value in DB also.

Follow for more on my FB page

or my OBIEE group

OBIEE Architecture Design based on type of Installation

OBIEE Architecture Design  based on type of Installation:

The Oracle Business Intelligence 11g logical architecture comprises a single integrated set of manageable components which can be installed and configured to work together on a single host or can be clustered across multiple hosts for performance and availability
3 Types of Installation are available:
Simple Install
Purpose: Demonstration and Evaluation Single-User Development
Definition: Installation with the default settings on a single computer in the minimum number of steps.
Managed Server is not installed. Mainly used for demonstration, or PoC
Enterprise Install
Purpose: Enterprise Deployment for Hosted Development and Production
Definition : Enterprise Install type enables you to specify several more configuration settings than the simple
Software Only Install
Purpose: Enterprise Deployment for Highest Levels of Availability and Security
Definition: Installation of the binary files in Middleware home and useful if you want to have multiple domains or products share a common Middleware Home

Oracle Business Intelligence Components :

Java Components (WebLogic Domain)
Deployed as JEE applications
To service SOAP, HTTP, and other forms of requests
System Components (BI Instance)
Deployed as server processes
Provide the core services that enable OBI
Other Domain Contents
Includes all the necessary software, metadata, configuration files, RPD files, Oracle BI Presentation Catalog, and connection and database configuration information that are
required to run an Oracle Business Intelligence system.
They are managed mainly by 2 administrative user interface :

WebLogic Server Administration Console — which provides advanced management for Weblogic, Java components (BI Publisher, MapViewer, …), and security. 
 Fusion Middleware Control (Enterprise Manager) — which is used to manage the system components (C++, JSE) (BI Server, BI Presentation Services, Scheduler, ….)

Oracle Business Intelligence Components:

Administration Server
Components for administering the system are :
Web Logic Server Administration Console
Monitoring the health and performance of JEE servers
Configuring WebLogic server domains
Stopping and starting JEE servers
Viewing JEE server logs
Managing users in the LDAP Server of the WebLogic Server
Fusion Middleware Control
Starting, stopping, and restarting all system components
Scaling out of system components
Managing performance and monitoring system metrics
Performing diagnostics and logging
JMX Mbeans
Provides programmatic access for managing a BI domain
Managed Server and Node Manager
Managed Server
Provides run-time environment for the Java-based services and applications within the system
Node Manager
Process management services for the Administration Server and Managed Server processes
Managed Server Components
Oracle BI Presentation Services Plug-in
Routes HTTP and SOAP requests to Oracle BI Presentation Services
Oracle BI Action Services
Web services required by the Action Framework
Oracle BI Security Services
Integration of the Oracle BI Server with the Oracle Fusion Middleware security platform
Oracle BI Publisher
Enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents
Oracle Real-Time Decisions (Oracle RTD)
Analytics software solutions allowing companies to make better decisions in real time
Oracle BI SOA Services
Invoke OBI functionality from Business Process Execution Language (BPEL) processes
System Components
System components are deployed as non-JEE components (C++ and J2SE)
Oracle BI Server
– Query and data access capabilities at the centre of OBI
– Provides services for accessing and managing the enterprise semantic model. Also RPD resides here
Oracle BI Presentation Services
– Framework and interface for the presentation of BI data to Web clients
Oracle BI Scheduler
– Scheduling for analyses to be delivered to users at specified times
Oracle BI JavaHost
– Supports various components such as Java tasks for Oracle BI Scheduler,Oracle BI Publisher, and graph generation
– Also enables Oracle BI Server query access to Hyperion Financial Management and
Oracle OLAP data sources
Oracle BI Cluster Controller
– Distributes requests to the BI Server
Ensuring requests are evenly load-balanced across all BI Server process in the BI Domain
Oracle Process Manager and Notification Server (OPMN)
Manage system components for Oracle Business Intelligence (for advanced users)
Supports both local and distributed process management
OPMN and Fusion Middleware Control
Fusion Middleware Control is the recommended approach for starting, stopping,
and viewing the status of components
OPMN is suitable only for advanced users
Basic Directory Structure of OBIEE :

WebLogic Server home
WebLogic Server home
Contains Java components
User Projects
contains product domains (including one or more Oracle Business Intelligence domains),
Administration Server, and one or more Managed Servers
Oracle BI Home
Contains all the binary files (read-only) that are specific to Oracle Business Intelligence
 Some Useful Directories of the BI Instance:

%Middleware Home%\instances\instance1\bifoundation\OracleBIServerComponent\
Web Catalog
%Middleware Home%\instances\instance1\bifoundation\OracleBIPresentationServerComponent\
%Middleware Home%\instances\instance1\config\OracleBIServerComponent\
%Middleware Home%\instances\instance1\config\OracleBIPresentationServerComponent\
BI Server Logs (nqserver.log, nqquery.log)
%Middleware Home%\instances\instance1\diagnostics\logs\OracleBIPresentationServerComponent\
See you next tym 🙂    (Courtesy : Google)