OBIEE 11g Architecture

Download OBIEE 11g here

Click Here (OR) Here for more Information…

Reference :http://oraclebiblog.blogspot.in/2010/10/obiee-11g-architecture.html

-Prasad Madhasi

Archive/Export OBIEE 11g content to Shared drive by creating Agents and Invoking Java Method

Oracle Business Intelligence 11g, doesn’t provide any built-in method to allow Agent to automatically export/archive OBIEE11g content(Entire Dashboard(or) Dashboard Page(or) Analysis(or) Conditional Report of Agent(or) even Briefing Book) to file system, although this can be done by linking an action to the agent which invokes server scripts, like EJBs, VBs etc.. which physically move the OBIEE11g content to the file system.

Action Framework of OBIEE 11g opens up direct integration with Java. So, any process that can be called via Java can be directly called from OBIEE 11g as well.

We will archive/export OBIEE content by Invoking a Java Method from Actions.

For Eg: Export OBIEE Dashboard page as pdf,excel,csv etc..  and save it in any shared drive(D:\SaveOBIEEReportinLocaldrive\Content)

Applies to:

This solution provided in this document is applicable on the below version of OBIEE11g.

Oracle Business Intelligence Suite Enterprise Edition – Version 11.1.1.7.0 and later

Information in this document applies to any platform.

Solution:

Invoke a Java Method (EJB)

This action type allows users to browse for target Java methods deployed in Enterprise Java Beans (EJBs) and then create an Agent à Action to invoke the selected Java method.

Summary

  1. Deploy “OBIEEContentExportApp.ear” file into weblogic Managed Server (bi_server1)
  2. Update “ActionFrameworkConfig.xml” file to enable Java Method calls from OBIEE11g
  3. Create an Agent to Export/Archive OBIEE 11g content to FileSystem

1.     Deploy “OBIEEContentExportApp.ear” file into weblogic Managed Server (bi_server1)

i)        Download the below “OBIEEContentExportApp.ear” file and place it under <MIDDLEWAREHOME>  (For Eg: C:\Middleware)

OBIEEContentExportApp.ear

(FYI: The above ear is developed by me using JDeveloper/ADF  .This ear is generic, reusable and no hardcoded report paths implemented in it. You can deploy and use it any OBIEE 11.1.1.7.0 + to export/archive OBIEE content to your shared/local file system)

ii)      Open weblogic console(http://localhost:7001/console) and go to deployments as shown below.

Image

iii)    Click Lock & Edit from Change Center as shown below.

Image

iv)    Click “Install” from Summary of Deployments tab as shown below.

Image

v)      Select Path: < Middleware>\OBIEEContentExportApp.ear (refer below screen for example path) and click Next.

Image

vi)    Select “Install this deployment as an application” radio button and click Next.

Image

vii)  Select bi_server1 as target and click Next.

Image

viii)            Leave the default settings in the below window and click Next.

Image

ix)    Select “No, I will review the configuration later.” radio button and click Finish as shown below.

Image

x)      Click Activate Changes as shown below.

Image

xi)    You have to get the below message once Activate Changes successful.

Image

xii)  By default the deployed application will be in prepared state. Here select the application and start it as shown below.

Image

Image

xiii)            Deployed application should be in Active mode as shown below.

Image

2.     Update “ActionFrameworkConfig.xml” file to enable Java Method calls from OBIEE11g:

i)        We need to update the ActionFrameworkConfig.xml to enable Java Method calls from OBIEE. Navigate to “<MiddlewareHome\user_projects\domains\bifoundation_domain\config\fmwconfig\biinstances\coreapplication\ActionFrameworkConfig.xml” and update file as shown below.

DownloadActionFrameworkConfig.xml.txt

(Refer the above file for updating your Action framework config file as below.Rename ActionFrameworkConfig.xml.txt to ActionFrameworkConfig.xml)

Registry:
<registries>
<registry>
<id>reg03</id>
<name>Sample EJBs</name>
<content-type>java</content-type>
<provider-class>oracle.bi.action.registry.java.EJBRegistry</provider-class>
<description>Custom Java classes which can be invoked as action targets</description>
<location>
<path/>
</location>
<custom-config>
<ejb-targets>
<appserver>
<context-factory>weblogic.jndi.WLInitialContextFactory</context-factory>
<jndi-url>t3://localhost:9704</jndi-url>
<server-name>localhost</server-name>
<account>WLSJNDI</account>
<ejb-exclude>mgmt</ejb-exclude>
<ejb-exclude>PopulationServiceBean</ejb-exclude>
</appserver>
<ejb-app>
<server>localhost</server>
<app-context>ActionSamplesEJB</app-context>
</ejb-app>
</ejb-targets>
</custom-config>
</registry>
</registries>

Account:
<accounts>
<account>
<name>WLSJNDI</name>
<description>Account used to access WLS JNDI.</description>
<adminonly>false</adminonly>
<credentialkey>JNDIUser</credentialkey>
</account>
</accounts>

Now, restart all OBIEE 11g services.

3.     Create an Agent to Export/Archive OBIEE 11g content to FileSystem:

i)        Login to OBIEE 11g (http://localhost:9704/analytics) and create an agent as shown below.

Image

ii)      Navigate to Delivery Content tab and select Content as Dashboard page and select Dashboard page as shown below and click Ok.

Image

iii)    Navigate to Recipients tab and select any “Role” as recipient . Here I selected BIAdministrator role for example. Refer the below screenshot.

Image

iv)    Select User Destinations as “Home Page and Dashboard” as shown below.

Image

v)      Navigate to Actions tab and from Add New Action -> Invoke a Java Method as shown below.

Image

vi)    From Select Java Method pop-up window, select “ArchiveOBIEEContent” method as shown below and Click OK.

Image

vii)  You will get New Action Window as shown below.

Image

viii)            Here in this example, I added the below parameters

Enter Location to Archive: D:\SaveOBIEEReportinLocaldrive\Content\Overview.pdf

Content to Archive: Delivery Content

And click OK.

Note: When you select “Content to Archive: Delivery Content”, you may get the below warning. Ignore this and click OK.

Image

ix)    Save the agent and Run it.

Now, you can see that your Delivery content : Overview dashboard page saved under given path as shown below!!!.

Image

Observations:

  • You can save/archive all the below formats .

Image

  • You can save even conditional analysis (the one we create condition on Agent as shown below)

Image

Hope this blog helped you..

– Prasad Madhasi

Reference:

http://docs.oracle.com/cd/E23943_01/bi.1111/e16364/actions.htm

http://www.rittmanmead.com/2010/09/oracle-bi-ee-11g-action-framework-java-ejbs-and-pdf-watermarks/

How to access the files from other drive or network in OBIEE?

To call any file/videos in OBIEE11g we will follow below steps:

Step1: Copy all files /videos in the below paths. Here Videos is my folder name which stores all my files/videos.

C:\OBIEE11G\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\Videos

C:\OBIEE11G\Oracle_BI1\bifoundation\web\app\res\Videos

Step2: Once we are done with the above step, need to restart the services and access the files/videos using http://localhost:9704/analytics/res/Videos/filename.

Filename: Name of the files/videos which is stored in Videos folder which we created.

The above steps are well known to us, but there is one disadvantage on using the above method.

Disadvantage: All the files/video need to store in the OBIEE server, where if we have thousands of files then it will be the problem. Because on storing thousands of files will make server down, as these files may take more memory.

To achieve the above disadvantage we need to store all the files in other drive/network other than OBIEE server.

How to access the files from other drive or network in OBIEE?

Step1:   Navigate to C:\OBIEE11G\Oracle_BI1\bifoundation\jee path and open analytics.ear file.

Stpe2:  On opening ear file we can see analytics.war file, open this war file.

Step3: Now click on  WEB-INF folder and open weblogic.xml file.

Place the below code before </weblogic-web-app> tag.

<virtual-directory-mapping>

                     <local-path>N:/</local-path>

                                <url-pattern>/Videos/*</url-pattern>

                                <url-pattern>*.jpeg</url-pattern>

                </virtual-directory-mapping>

Step4: Restart the services, now we can access the jpeg images which were stored N drive with folder name Videos using the below url

http://localhost:9704/analytics/images/test.jpeg.

Advantage: There is no burden to OBIEE server ,we can store all the files in different drive or network and can easy access this using OBIEE.

Hope this helps….

Thanks,

Suresh Gummadi

Excellent post…

rmoff

Introduction

In this article I plan to get sample and paint repositories hosted on a single server, using one BI Server instance and two Presentation Services instances. This is on both Unix (OEL 4) and Windows, and both OC4J (OBIEE’s “basic installation” option) and OAS (“Advanced Installation”).

Make sure you’ve read and followed part 1 – BI Server first.

Remember that multiple Presentation Services instances on a machine is UNSUPPORTED BY ORACLE!

OBIEE Components

See the deployment guide p.11 for a thorough explanation of the components.

It’s important to understand the components of the OBIEE stack as what we’re doing is unsupported and undocumented in parts, so you need to be able to diagnose and reason through issues you may get:

  • BI Server (nqserver) – the Analytics server. Uses the RPD to build queries to send to the database.
  • Presentation Services (sawserver) – This takes the submission of queries from…

View original post 2,200 more words

Excellent post…

rmoff

Introduction

In this article I plan to get samplesales and paint repositories hosted on a single server, using one BI Server instance and two Presentation Services instances. This is on both Unix (OEL 4) and Windows, and both OC4J (OBIEE’s “basic installation” option) and OAS (“Advanced Installation”).

Both samplesales and paint are shipped with 10.1.3.4 of OBIEE, you’ll find them in $OracleBI/OracleBI/server/Sample. This article assumes you’ve got the RPD of each into $OracleBI/OracleBI/server/Repository and unpacked the web cats for each into $OracleBIdata/web/catalog.
It also assumes that you know your way around the architecture of BI and are familiar with NQSConfig.ini and instanceconfig.xml – if neither of those files mean anything to you then you will find some background reading useful.

Verify paint and samplesales RPDs

Check that both paint and samplesales both work independently before we start trying to get them to work alongside each other.

paint.rpd

Set NQSConfig.ini to

View original post 536 more words

Server state changed to FORCE_SHUTTING_DOWN (Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password.)

Today we got the below error while starting the Weblogic Admin server.

<1362748153179> <BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password.

weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password.

Here is the fix:    We navigated to <Middleware_Home>/user_projects/domains/<Your Domain>/config/fmwconfig/ folder and observed that cwallet.sso is corrupted and file size is 0(zero) kb . Here we renamed this file(cwallet.sso_bkp) and successfully started Adminserver .

OBIEE 11g Enterprise Manager is too slow

Step1:Stop all OBIEE 11g services

Step2:Navigate to the below paths and delete or move to some other folder if required as backup.

<Middleware Home>\user_projects\domains\bifoundation_domain\servers\AdminServer\logs
<Middleware Home>\user_projects\domains\bifoundation_domain\servers\bi_server1\logs

Step3: Start all OBIEE 11g services and you will see the enterprise manager will be running faster.

Hope this post helped you.

-Prasad Madhasi

Default Header and Footer for Report/Analysis in OBIEE 11g

We can specify that default headers and footers are displayed on all new analyses. For example, footers can contain messages such as a confidentiality notice, the company’s name, and so on. You can specify a default header or footer by creating an XML message that specifies the text and formatting to apply.

Steps :

Step1:Create HeaderAndFooter.xml file with the below content . Here My Header is : ABC Ltd and Footer is : Confidential

<?xml version=”1.0″ encoding=”utf-8″?>
<WebMessageTables xmlns:sawm=”com.siebel.analytics.web.messageSystem”>
<WebMessageTable system=”Answers” table=”ViewDefaults”>
<WebMessage name=”kuiCriteriaDefaultViewElements” translate=”no”><HTML>
<view signature=”compoundView” >
<pageProps pageSize=”a4″>
<pageHeader showOnDashboard=”true” show=”true”>
<zone position=”top”><caption>[b]ABC Ltd[/b]</caption>
<displayFormat fontColor=”#FF0000″/></zone>
</pageHeader>
<pageFooter showOnDashboard=”true” show=”true”>
<zone position=”top”><caption>[b]Confidential[/b]</caption>
<displayFormat fontColor=”#FF0000″/></zone>
</pageFooter>
</pageProps>
</view>
</HTML></WebMessage>
</WebMessageTable>
</WebMessageTables>

Step2: Paste HeaderAndFooter.xml in the below locations and restart services.

<MiddlewareHome>\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb
<MiddlewareHome>\Oracle_BI1\bifoundation\web\msgdb\customMessages

Step3:Create analysis in answers and you can find Header and Footer applied by default.

Reference : http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/answersconfigset.htm#i1018681

-By Prasad Madhasi.

Audit and Monitor BI Publisher Reports Access

I have found a nice article by Kan Nishida from Oracle blog which can answer

  • How many BIP reports are accessed or opened yesterday, today, last week ?
  • Who is accessing which report at what time ?
  • What are the time windows when the most of the reports access happening ?
  • What are the most viewed reports ?
  • Who are the active users ?
  • What are the # of reports access or user access trend for the last month, last 6 months, last 12 months, etc ?

Go through the below URL for Step-By-Step to implement this.

To enable Auditing feature follow – https://blogs.oracle.com/xmlpublisher/entry/how_to_audit_and_monitor_bi_pu and complete How to Enable Auditing Feature? part first and then follow the below link

https://blogs.oracle.com/xmlpublisher/entry/how_to_visualize_your_audit_da

-Prasad Madhasi

Good one…
Thanks

D£bashis's OBI££ Blog

OBIEE 11g upgrade has a lot of issues and among couple of them common is on Conditional Formatting . This emphasis that even if the Catalog upgrade is successful there are some of the problem still persists in XML conversion engine of the Upgrade Assistant(UA) leading though several catalog defects due to malformed XML . This is another example as my upgraded 11g charts failing to show its conditional formatting which is was working perfectly in 10g ….

Lets deep dive on whats the issue …

Below is the conditional format definition in 11g which is aligned with 10g:

So ideally it should show Chart bars (which is generated from Combined request Pivoted Graph) and see the below comparison:

To understand the reason of why 11g chart not showing the conditional format I went through the full XML from Advanced tab of 11g and find the below discrepancies:

This is…

View original post 95 more words

Call HTML file from weblogic Adminserver

Here requirement is, I have the HTML page that should be deployed in the weblogic Admin server and as a result I should be able to call that html page from the web browser .

Lets take  forms.html file as example.

Navigate to the path  :  <MiddlewareHome>\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\

and paste forms.html  as shown below

Restart all OBIEE 11g services .

and try to open forms.html page using “<Host>:<Port>/analytics/forms.html”

You should be able to call forms.html as shown below.

-By Prasad Madhasi

%d bloggers like this: