MIGRATING OBIEE 11G FROM TEST TO PRODUCTION

  • Repository Backup
1.     Goto Startup Menu>Oracle Business Intelligence Enterprise Edition>Administration.
2.      File>Open>Online
3.      Enter the Repository Password and Administrator Password.
4.      File>Copy As>Repository
5.     Save Copy as to appropirate folder.
  • ODBC NEW DATASOURCE CREATION   
1.      Goto Startup menu>Run>enter odbc> select Mircrosoft ODBC Administrator.
Image
2.      Select System DSN>Add>Select Oracle BI Server and click finish.
3.      Enter the name of the Datasource and enter the server name as screenshot below and select next.
Image
4.      Enter Oracle BI Server login ID and password and select next.
Image
5.     Select Finish and your new datasource will be created..
6.     New tnsname.ora file should be replaced in following path “MiddlewareHome\oracle_common\network\ADMIN” with old tnsname.ora file backup.
OBIEE ADMINISTRATIVE TOOL CONNCETION POOL PROPERTIES
1.     Goto>Startup menu>Oracle Business Intelligence Enterprise Edition>Administration.
2.     Goto>File>Open>Offline>Browse for RPD.
3.     Enter repository password to open.
4.     Double click the database icon present in Physical layer.
5.     Delete the old Database name (TESTDB) and Enter new Database name(PRDDB).
Image
6.     Select Connection Pool and select edit button.
7.     Change old datasource name  to new datasource name.
8.     After changing the Datasource name save the changes and check for Global Consistency.
9.     Once Global Consistency check is completed select ok.
  • CATALOG MIGRATION FROM TEST TO PRODUCTION ENVIRONEMENT   
1.      Test catalog folder present in /u01/app/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/” (folder naming SampleAppLite) from OBIE.TEST environment should be replaced in OBIE.PRD environment ”u01/app/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/” with SampleAppLite backup in OBIE.PRD
2.    Once the catalog folder is moved go to http://OBIE.PRD.com:7001/em enter username and password.
3.     In left pane Expand Business Intelligence and select coreapplication.Business Intelligence>Coreapplication>delployment>repository
4.    Select Lock & Edit Configuration option and once done select close.
5.    Browse>Upload saved repository file and enter repository password and click apply button. 
6.    Once apply button is selected Default RPD name will changed to new one.
7.     Once the name has changed select activate changes.Restart all BI services.
8.     Login to http://OBIE.PRD.com:9704/analytics and now catalog has been migrated from test to production environment.
NOTE: In some cases user based security configuration wont be applied in above process so we have to logon to enterprise manager>weblogic domain>security>credentials>oracle.bi.system>system.user>edit>change password  and restart all the BI servies.
Hope it Helps...
Thanks,


Shanmugha Bharathy G B

Oracle BI 11g Architecture Components Descriptions

Over all BI Domain:
Overall system is called “Oracle BI Domain” . This comprises of Java components deployed into J2EE containers , non java system components and required configuration files, metadata, repositories, and infrastructure. Oracle Enterprise Manager(OEM) acts as “Fusion Middleware Control” which together with Weblogic Admin Console are the basic backbone,the powerhouse and the Admin Activity controller for the entire domain .
Weblogic Server Domain: The logical domain consists of Admin server and Managed server .It comprises mainly with all the Java modules to trigger the java services .A peer handshaking has been done between WLSD and Oracle BI Instance.
Administration Server:
A JEE container that runs in a dedicated Java virtual machine that contains Java components for administering the system .It typically trigger the start,stop kind of admin activity for his peer Manager server processes.
Managed Server:
A JEE container that runs in a dedicated Java virtual machine that provides the run-time environment for the Java-based services and applications within the system.The services comprises of BI plugin , Security , publisher ,SOA ,BI Office services etc .
Node Manager:
Node Manager provides process management services for the Administration Server and Managed Server processes.Its a separate java utility runs to trigger the auto start , stop , restart activities for distributed Managed server.
Oracle Process Manager and Notification Server(OPMN):
It is monitored , managed and controlled by Fusion Middleware Controller(OFMW). It is also used for distributed process start/stop/restart i.e maintains the Oracle Business Intelligence system component processes.Also used for performance collection using Dynamic Monitoring System (DMS) .
Oracle Weblogic Server (Console):
It is the replacement of Oracle 10g R3 middle tier cluster topology based on Oracle Container for Java (OC4J) . It is a Java EE application server that supports the deployment of Oracle Business Intelligence Java components and primarily host the java component services inside Managed server .
Oracle WebLogic Server Administration Console access has been provided by Fusion Middleware Control.Oracle WebLogic Server Administration Console enables to monitor and manage a WebLogic Server domain. Its capabilities include the following:
Monitoring health and performance of JEE servers
Configuring WebLogic domains
Stopping and starting JEE servers
Viewing JEE server logs
Fusion Middleware Control:
Fusion Middleware Control is a browser-based tool and the recommended method for monitoring, managing, and configuring Oracle Business Intelligence components.
Fusion Middleware Control is used principally for managing the system components of a BI domain and provides support for the following:
Starting, stopping, and restarting all system components (BI Server,BI Presentation Server) and Managed Servers
Configuring preferences and defaults
Scaling out of system components
Managing performance and monitoring system metrics(DMS-Dynamic Monitoring System)
Performing diagnostics and logging (ODL-Oracle Diagnostic Logging)
Fusion Middleware Control also provides access to Oracle WebLogic Server Administration Console, where you monitor and manage Oracle Business Intelligence Java components.
To be very precise OFMW contains to components ..i.e. Java Components managed by Weblogic Server and System components managed by Oracle Process Manager and Notification (OPMN) and this includes below as well including BI components :
Oracle HTTP Server
Oracle Web Cache
Oracle Internet Directory
Oracle Virtual Directory
Oracle Forms Services
Oracle Reports
Oracle Business Intelligence Discoverer
OFMW Environment: Oracle Fusion Middleware environment contains Oracle WebLogic Server domain (including Administration Server, two Managed Servers) , an Oracle instance and Metadata repository .
Java components: Deployed as one or more Java EE applications:
Administrative Components — Enterprise Management applications and JMX MBeans for managing all configuration and run-time settings for Oracle Business Intelligence.
Oracle BI Publisher — This component provides an enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents to employees, customers, and suppliers.
Oracle BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.
Oracle BI Action Services — This component provides the dedicated Web services that are required by the Action Framework and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.
Oracle Real-Time Decisions (Oracle RTD) — This component provides enterprise analytics software solutions that enable companies to make better decisions in real-time at key, high-value points in operational business processes.
Oracle BI Security Services — This component provides dedicated Web services that enable the integration of the Oracle BI Server with the Oracle Fusion Middleware security platform i.e JPS (Java Platform Security) , CSF (Credential Store Framework) and users and groups managed by  BI LDAP security.
Oracle BI SOA Services — This component provides dedicated Web services for objects in the Oracle BI Presentation Catalog, to invoke analyses, agents, and conditions. They make it easy to invoke Oracle Business Intelligence functionality from Business Process Execution Language (BPEL) processes.
Oracle BI Plugin — A JEE application that routes HTTP and SOAP requests to Oracle BI Presentation Services.
System components: Deployed as non-JEE components, such as processes and services written in C++ and J2SE:
Oracle BI Server — This component provides the query and data access capabilities at the heart of Oracle Business Intelligence and provides services for accessing and managing the enterprise semantic model (stored in a file with a .RPD extension).
Oracle BI Presentation Services — This component provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.
Oracle BI Scheduler — This component provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler)
Oracle BI JavaHost — This component provides component services that enable Oracle BI Presentation Services to support various components such as Java tasks for Oracle BI Scheduler, Oracle BI Publisher, and graph generation.
Oracle BI Cluster Controller — This components distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.
Thanks,


Shanmugha Bharathy G B

Customizing "No Data View" in 11g

Alerting Users to No Data in the Results of Analyses:
When the results of an analysis return no data, the following default message is displayed to users:
No Results
The specified criteria didn't result in any data.
This is often caused by applying filters and/or selections that are too
restrictive or that contain incorrect values.
Please check your Analysis Filters and try again.
The filters currently being applied are shown below.

Rather than display the default message, you can create a customized message to alert users. This allows you to provide your own explanation as to why the analysis returned no data.

To create a custom message to alert users to no data in the results of an analysis:

1. Edit the analysis to which you want to add a custom message.
2. Click the "Analysis editor: Results tab".
3. Click the Analysis Properties toolbar button. The "Analysis Properties dialog" is displayed.
4. In the No Results Settings box, select Display Custom Message.
5. In the Header field, enter the text of the header for the custom message.
6. In the Message field, enter the explanatory text.
7. Click OK.
No Results feature in OBIEE helps users to customize the default message.
Below is the default message received, when the report contains restrictive filters or no data in it.
You can customize the default message as per your requirements.
1. Create Simple Report
On the Criteria Tab, click on Properties and select ‘Display Custom Message’
Type the header & custom message in the message box and click ok..
Image
2. Check the Result
Select the prompts to run the report.
Image