Download OBIEE 11g here
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)
This solution provided in this document is applicable on the below version of OBIEE11g.
Oracle Business Intelligence Suite Enterprise Edition – Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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.
i) Download the below “OBIEEContentExportApp.ear” file and place it under <MIDDLEWAREHOME> (For Eg: C:\Middleware)
(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 18.104.22.168.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.
iii) Click Lock & Edit from Change Center as shown below.
iv) Click “Install” from Summary of Deployments tab as shown below.
v) Select Path: < Middleware>\OBIEEContentExportApp.ear (refer below screen for example path) and click Next.
vi) Select “Install this deployment as an application” radio button and click Next.
vii) Select bi_server1 as target and click Next.
viii) Leave the default settings in the below window and click Next.
ix) Select “No, I will review the configuration later.” radio button and click Finish as shown below.
x) Click Activate Changes as shown below.
xi) You have to get the below message once Activate Changes successful.
xii) By default the deployed application will be in prepared state. Here select the application and start it as shown below.
xiii) Deployed application should be in Active mode as shown below.
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.
(Refer the above file for updating your Action framework config file as below.Rename ActionFrameworkConfig.xml.txt to ActionFrameworkConfig.xml)
<description>Custom Java classes which can be invoked as action targets</description>
<description>Account used to access WLS JNDI.</description>
Now, restart all OBIEE 11g services.
i) Login to OBIEE 11g (http://localhost:9704/analytics) and create an agent as shown below.
ii) Navigate to Delivery Content tab and select Content as Dashboard page and select Dashboard page as shown below and click Ok.
iii) Navigate to Recipients tab and select any “Role” as recipient . Here I selected BIAdministrator role for example. Refer the below screenshot.
iv) Select User Destinations as “Home Page and Dashboard” as shown below.
v) Navigate to Actions tab and from Add New Action -> Invoke a Java Method as shown below.
vi) From Select Java Method pop-up window, select “ArchiveOBIEEContent” method as shown below and Click OK.
vii) You will get New Action Window as shown below.
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.
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!!!.
Hope this blog helped you..
– Prasad Madhasi
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.
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.
Step4: Restart the services, now we can access the jpeg images which were stored N drive with folder name Videos using the below url
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….
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!
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:
View original post 2,200 more words
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.
Check that both paint and samplesales both work independently before we start trying to get them to work alongside each other.
Set NQSConfig.ini to
View original post 536 more words
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 .
Step1:Stop all OBIEE 11g services
Step2:Navigate to the below paths and delete or move to some other folder if required as backup.
Step3: Start all OBIEE 11g services and you will see the enterprise manager will be running faster.
Hope this post helped you.
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.
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″?>
<WebMessageTable system=”Answers” table=”ViewDefaults”>
<WebMessage name=”kuiCriteriaDefaultViewElements” translate=”no”><HTML>
<view signature=”compoundView” >
<pageHeader showOnDashboard=”true” show=”true”>
<zone position=”top”><caption>[b]ABC Ltd[/b]</caption>
<pageFooter showOnDashboard=”true” show=”true”>
Step2: Paste HeaderAndFooter.xml in the below locations and restart services.
Step3:Create analysis in answers and you can find Header and Footer applied by default.
-By Prasad Madhasi.
I have found a nice article by Kan Nishida from Oracle blog which can answer
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
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:
View original post 95 more words
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