Monday, November 11, 2013

Oracle Endeca Information Discovery (OEID) 3.1 quick install

As you may know, Oracle Endeca Information Discovery OEID was released November 7th, I decided to download the product and go through the installation. The great news is that the installation process has been greatly improved compared to OEID 3.0. With OEID 3.1, the overall installation can be scripted using an “orchestration script” to install and configure
o Weblogic 10.3.6
o Oracle ADF runtime 11.1.1.6
o Endeca Server 7.6
o Endeca Studio 3.1
o Endeca Provisioning
The purpose of this post is to document at a high level the steps while I am going through the installation using the provided orchestration script. My OS is Microsoft Windows Server 2008 R2. This post will cover the software staging, scripts modifications and install. A future post will cover the OEID Integrator installation and sample data load and new features.
The software package is available from Oracle Software Delivery Cloud. 
1) Download the following media packages:
Oracle Endeca Server (7.6.0) media pack folder
- V40519-01: Oracle Endeca Server (7.6)
- V40521-01: Oracle Endeca Server (7.6) Sample data
- V29856-01: Oracle Weblogic 10.3.6
- V29673-01: Oracle ADF Runtime 11g Patch set 5
Oracle Endeca Information Discovery Studio (3.1.0)
- V40547
You’ll notice also the media pack V40522-01 (IKM SQL to Endeca Server for integrating with ODI) which is pretty exciting.
JDK version 6 is also a pre-requisite for the OEID 3.1 installation, I will be using JDK1.6.0_43.
2)  Create a folder that will hold the installation scripts and the binary installation files, for example C:\stage
3)  Unzip V40547—> EID_3.1_Studio_InstallWin.zip—>eidOrch into c:\stage
The eidOrch folder contains 2 subfolders:
- installers: actual software binaries for Endeca Studio and Endeca Provisioning
- orchScripts: orchestration script for Endeca Studio and Endeca Provisoning
4) Unzip V40519-01 into C:\stage to get
- endecaserver.zip
- windows_OC.zip
5) Unzip windows_OC.zip and move the resulting subfolder “windows” to
C:\stage\eidOrch\orchScripts\
6) Rename the folder that you just moved ES_windows_OC
7) Move the endecaserver.zip file to c:\stage\eidOrch\installers
8) Rename V29673-01 to ofm_appdev_generic_11.1.1.6.0_disk1_1of1.zip, that’s the name expected by the installation script and move it to C:\stage\eidOrch\installers. Note that you can download ofm_appdev_generic_11.1.1.6.0_disk1_1of1.zip from OTN.
9) Unzip the V29856-01 media pack, this is the Weblogic 10.3.6 jar file and move it to c:\stage\eidOrch\installers
10) Folder structure before installation

C:\stage\eidOrch\Installers\
image
C:\stage\eidOrch\orchScripts\
image
11) Run_EID_install.bat is the main script, it will call the following scripts
- eidOrch\orchScripts\ES_Windows_OC\run_endeca_server_install.bat (Weblogic, ADF runtime, Endeca server installation)
- eidOrch\orchScripts\Studio_windows_OC\run_endecastudio_install.batm(Endeca studio installation)
- eidOrch\orchScripts\PS_windows_OC\run_endecaprovisioning_install.bat (Endeca Provisioning)
The installations scripts will get the predefined configuration parameters from property files :
- eidOrch\orchScripts\config_EID_windows.prop
- eidOrch\orchScripts\ES_Windows_OC\config_win.prop
- eidOrch\orchScripts\Studio_windows_OC\config_Studio_win.prop
- eidOrch\orchScripts\PS_windows_OC\config_PS_win.prop
Following are screenshots property files, note that JAVA_HOME, ORACLE_HOME and INSTALLER_LOCATION are the main parameters that have to be adjusted based on your local settings. 
You also have the option to set additional parameters such as START_MODE, USE_SSL etc… One notable parameter for the Endeca_Server, Endeca_Studio and Endeca Provisioning product property files is INSTALL_MODE. This parameters specifies whether we’re performing an install only or an install followed by configuration. There are additional values to specify that there is an existing middleware installation. Refer to the documentation for more details. Note that this install will be NON-SSL, if using SSL ports, there are additional setting to be changed on the property files.

config_EID_windows.prop
image
config_win.prop
image
config_Studio_win.prop
image
config_PS_win.prop
image
Open a DOS command prompt as Administrator and cd into c:\oracle\eidOrch\orchScripts\
Then launch the main orchestration script:
run_EID_install config_EID_windows.prop --temp-directory c:\temp
and watch the installation in progress. You will be prompted to enter parameters such Admin usernames/passwords (you can potentially modify the scripts to automate this step).
Caution:  if you're using a disk drive (for the temporary directory) that is different from the one that holds your scripts, the installation script will fail. In my case I had to modify the installation scripts as follows: search for the line
cd %TMPFOLDER%\bin
enter a new line below it with
C:
This has to be done for run_endecaprovisioning_install.bat, run_endecastudio_install.bat and the endecaserver_install.bat

image
image
image
At the end, you’ll have the Endeca Server, Endeca Studio, Endeca Provisioning fully installed/configured and up and running in no time!
A much smoother install process for OEID 3.1 indeed!
p.s OEID software is now available for download on OTN

update: Several users are experiencing an issue when they try to invoke web services to import data (OES-000169: Could not connect to Endeca Server at 10:7001). The work around is to make sure that the Windows hosts has an entry with IP address, machine name.domain example:
192.168.56.1  endeca.demo.org endeca

a+
Fiston



































Monday, February 4, 2013

Creating BIP Gantt Charts using JFreeChart (cont.)

In my previous post I showed the majors steps for creating a simple Gantt Chart in BI-Publisher using the JFreeCharts API. The purpose of this post is to provide the technical details of the implementation. 
We first need to download the following JAR files:
· jfreechart-1.0.4.jar
· jcommon-1.0.8.jar
· Commons-code-1.5.jar
 
Extension code:
Create a Jdeveloper generic application
Application Name: GanttChart
 
g1


















Click Next to create a project:
Project Name: bip
 
g2

Add a new Java class to the bip project 

g3

I’ve created a Java class that will be packaged as a jar file and copied to the Weblogic folder. The purpose of this file is to:
1) Read in the XML from the BI-Publisher data model:
2) Organize XML data in the format expected by the JFreeChart API
3) Plot the Gantt Chart using the API
4) Return the generated image
5) BI-Publisher renders the image on the report
Update the code in Jdeveloper with the following is the code listing: this is a very crude code intended for testing only
 
/* ======================================
* JFreeChart : a free Java chart library
* ======================================
*
* Project Info: http://www.jfree.org/jfreechart/index.html
* Project Lead: David Gilbert (david.gilbert@object-refinery.com);
*
* (C) Copyright 2000-2003, by Object Refinery Limited and Contributors.
*
* This library is free software; you can redistribute it and/or modify it under the terms
* of the GNU Lesser General Public License as published by the Free Software Foundation;
* either version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License along with this
* library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
* Boston, MA 02111-1307, USA.
package oracle.bip.extensions;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.apache.commons.codec.binary.Base64;
import javax.sql.rowset.serial.SerialException;
import javax.xml.parsers.ParserConfigurationException;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartPanel;
import org.jfree.chart.ChartRenderingInfo;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.entity.StandardEntityCollection;
import org.jfree.data.category.IntervalCategoryDataset;
import org.jfree.data.gantt.Task;
import org.jfree.data.gantt.TaskSeries;
import org.jfree.data.gantt.TaskSeriesCollection;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.xml.sax.SAXException;
public class bipExt {
public static String createGantt(NodeList bipXML, String taskName,
String taskStartDate,
String taskEndDate, String title) throws IOException,
SerialException,
ParserConfigurationException, SQLException, SAXException,
ParseException, NullPointerException {
final TaskSeries s1 = new TaskSeries("GANTT");
//Read in the start dates, end dates, task names as lists
ArrayList<String> startDate = new ArrayList<String>();
ArrayList<String> endDate = new ArrayList<String>();
ArrayList<String> taskname = new ArrayList<String>();
// First parameter list is the list of task start dates
for (int i = 0; i < bipXML.getLength(); i++) {
Node node = bipXML.item(i);
if (node.getNodeType() == Node.ELEMENT_NODE) {
Element element = (Element)node;
NodeList nodelist = element.getElementsByTagName(taskStartDate);
Element element1 = (Element)nodelist.item(0);
NodeList startDateNode = element1.getChildNodes();
String c1=startDateNode.item(0).getNodeValue().toString();
// Extract the canonical dates
startDate.add( c1.substring(0, 9));
}
}
// Second parameter list is the list of task end dates
for (int i = 0; i < bipXML.getLength(); i++) {
Node node = bipXML.item(i);
if (node.getNodeType() == Node.ELEMENT_NODE) {
Element element = (Element)node;
NodeList nodelist = element.getElementsByTagName(taskEndDate);
Element element1 = (Element)nodelist.item(0);
NodeList endDateNode = element1.getChildNodes();
String c2=endDateNode.item(0).getNodeValue().toString();
// Extract the canonical dates
endDate.add(c2.substring(0, 9));
}
}
// First parameter list is the list of task labels
for (int i = 0; i < bipXML.getLength(); i++) {
Node node = bipXML.item(i);
if (node.getNodeType() == Node.ELEMENT_NODE) {
Element element = (Element)node;
NodeList nodelist = element.getElementsByTagName(taskName);
Element element1 = (Element)nodelist.item(0);
NodeList labelNode = element1.getChildNodes();
String label = labelNode.item(0).getNodeValue();
taskname.add(label);
}
}
BufferedImage chartImage;
bipExt gantt = new bipExt();
// Create the dataset expected by JFreeChart for the Gantt Chart Type
IntervalCategoryDataset dataset =
gantt.createDataset(startDate, endDate, taskname);
// Create the JFreeChart
final JFreeChart chart = ChartFactory.createGanttChart(
title,
"Task",
"Date",
dataset,
true,
true,
false
);
chart.setBackgroundPaint(new GradientPaint(0, 0, Color.white, 1000, 0, Color.blue));
// Render the Chart as an image
final ChartPanel chartPanel = new ChartPanel(chart);
int width=450;
int height=270;
chartPanel.setPreferredSize(new java.awt.Dimension(width, height));
ChartRenderingInfo info = null;
info = new ChartRenderingInfo(new StandardEntityCollection());
chartImage = chart.createBufferedImage(550, 350, info);
byte[] buffered_image = ChartUtilities.encodeAsPNG(chartImage);
String image = new String(Base64.encodeBase64Chunked(buffered_image));
return image;
}
public bipExt() {
}
public static IntervalCategoryDataset createDataset(List sdate,
List edate,
List taskName) throws ParseException {
Iterator iterator = sdate.iterator();
final TaskSeries s1 = new TaskSeries("Schedule");
for (int i = 0; i < sdate.size(); i++) {
String c1;
String c2;
c1=sdate.get(i).toString();
c2=edate.get(i).toString();
s1.add(new Task(taskName.get(i).toString(), new SimpleDateFormat("yyyy-MM-dd").parse(c1),
new SimpleDateFormat("yyyy-MM-dd").parse(c2)));
}
final TaskSeriesCollection collection = new TaskSeriesCollection();
collection.add(s1);
return collection;
}
}

Add the previous 3 jar files to the project 



g5

And create the JAR Deployment file

g6

Once the JAR File is generated, copy it to the place where Weblogic  server expects it 

g8

Log into to BI Publisher and “Change the Disable external references” flag to “False”, it is “True” by default. 

BI Publisher Report:
Create the BI-Publisher data model. For this example, download the ACTIVITIES table from the amis site and create a simple BIP SQL query:
select label,start_date,end_date from activities with the respective XML tag names: LABEL, START_DATE, END_DATE
 
g9

Following is a sample XML data set from the data model 

g10


Create an RTF template using BIP template builder with the following 3 form fields:
1) Namespace:
 
g11

2) Create Gantt:
Call to the Java extension to pass in the XML data from BIP, the XML tag names and title, the result from the call is stored in a parameter called GanttIMG 

g15

3) Display Gantt:
Display the image on the report 

g13

Create a new BIP report using this RTF template and the previous data model.
Run your report, if all goes well: ta-da! 

g16
 
a+
Fiston






























































































































































































Wednesday, January 23, 2013

Creating BIP Gantt Charts using JFreeChart

An overlooked feature of BI-Publisher is the ability to create custom extensions in Java in order to add capabilities beyond the out of the box features.  Tim Dexter blogged about this undocumented feature several years ago.
Using this feature, I was able to integrate BI Publisher with JFreeChart an Open Source plotting API in order to generate plots that are not provided by BI-Publisher such as the Gantt chart type. The main steps are as follows:
1) Create the BIP data model: as an example I used the sample Gantt data set from the amis website.
image

2) Create the BIP extension code in Java, I used Tim Dexter’s example as a starting point. I plan on sharing the custom code once I get a chance to clean it up.
Creating Gantt chart using JFreeChart is very straightforward and there are several examples on the web, other more sophisticated types of plots (box plots etc…) require more work. The only difficulty with JFreeChart is that it doesn’t support XML dataset as input, there are ways around that limitation
You’ll need the following JAR files available on the web:
· jfreechart-1.0.4.jar
· jcommon-1.0.8.jar
· Commons-code-1.5.jar
The resulting JAR file will have to be copied to the location expected by Weblogic, on my PC it is:
C:\fusion\user_projects\domains\bifoundation_domain\lib
 
image

3) Create the BIP template, I used Template builder to create an RTF template with 3 fields
 
image

Namespace:
Create Gantt Chart: is the call to the custom Java code. My custom code call is:

I am basically feeding the XML data from BI-Publisher to the JFREECHART API as well as the XML tags
Display Gantt Chart: renders the resulting image (Gantt Chart) from JFreeChart
;

5) Change the “Disable External References” flag to “FALSE” (it is TRUE by default) in BI-Publisher
 
image

6)  Upload your RTF template, bounce the services and voila!
 
image
Pretty basic but the look and feel of this can be greatly improved by tweaking the JFreeChart API.
a+
Fiston


























Wednesday, September 12, 2012

OBIEE to BIP trick

I am back to working with BI-Publisher after a hiatus of a few years and I am loving 11g: it is such a big jump from 10g!  Today I needed to “remember” how to navigate from an “Answers” (or “Analysis” if you like the new terminology better) request to a BIP report while preserving the context: basically how to pass parameters. Following is how I went about it, hopefully it will be useful to some of you.
- First create a BIP report with a parameter, let’s call it P_DEPT. For illustration purposes we’ll use the HR schema to build a simple data model.
pic1
pic2
pic3
- Create a simple template to show a table with DEPARTMENT_NAME and DEPARTMENT_ID
- Navigate to the BIP report properties and enable the radio button “Allow Sharing Report Link”
- Run the report and get the Report Link by navigating to the “Shared Report Link”
pic6

- We’ve got an OBIEE Answers request with 2 fields: DEPARTMENT_NAME and DEPARTMENT_ID, clicking on a particular DEPARTMENT_ID should take us to the BIP report above filtered for the selected department.
pic8
7) Now the trick: create an Action Link (Navigate to a Web Page)  for the Department ID column value:
pic9
- Create a parameter P_DEPT (similar to the BIP report parameter name)
                         Name: P_DEPT
                         Value: “Column Value” then select “DEPARTMENT_ID”
                         Hidden field: checked
- Modify the BIP “Shared Report Link” to pass in the P_DEPT parameter: The text "_paramsP_DEPT":"*" is changed to "_paramsP_DEPT":@{P_DEPT}
pic12

- Clicking on Department ID 70 takes us to the BIP report with the filter Department ID =70 applied.
pic13


Fiston
a+

Tuesday, May 29, 2012

OBIEE reports to Webcenter Content (UCM)


I was asked by a customer to work on a POC to show how an end-user can run an OBIEE 11g analysis and check it in automatically into Webcenter Content (UCM), this solution doesn't involve BPEL processes. In case you’re not familiar, Webcenter content (WCC) is an enterprise grade content management solution from Oracle. It is also extensible by using the many Java APIs that are available out of the box.
With the introduction of the action framework in OBIEE 11g there are endless possibilities to integrate OBIEE with other applications. For this POC we leveraged the action framework to call a WCC API called CHECKIN_UNIVERSAL via the RDIC (Remote IntraDoc Client) a light weight communication protocol for the Content server. I took the opportunity of the long Memorial Day week end to put something together. 
A report can be checked into the content management solution either directy by calling the action or at the completion of an iBot/agent. Following are few screenshots to illustrate the functionality. When I get a chance I will document the step by step approach for the implementation. 

  • log into OBIEE and select the action "UCM"







  • Enter the parameters: Title, Document Type, The report to be checked into UCM 

Here are the parameters for the action


Once the success message is displayed, the report is available in WCC. Log into WCC and do a search 


and voila, our report is checked in!

The action can also be invoked from an agent which is pretty cool


a+
Fiston




Monday, May 14, 2012

OBIEE 11.1.1.6.2 (patch 13884769)

Patch 13884769 was released yesterday. 

Bugs Fixed By This Patch:
-------------------------------------------------------------------------------------------------------------------------------
13529697: METADATA DICTIONARY NOT PROPERLY GENERATED WITH HYPHENS IN NAMES 
13902810: CAN'T CREATE EXPRESSIONS IN RPD WITH COLUMN FROM ESSBASE - INVALID EXPRESSION
13705487: HIERARCHY OBJECTS ARE MISSING AFTER MERGING RPDS
9665267: COMPARE RPD AND PATCH GENERATION
12977729: HIERARCHICAL COL DRILLING ON MORE THAN ONE PAGE OF RESULTS LOSES FOCUS ON DRILL
13688544: 'CASE WHEN' CHANGES TO 'CASEWHEN' IN XML AND CAUSES ERROR WHEN SET XML
13523548: ERROR OUT WHEN USING MULTIPLE DOUBLE COLUMNS IN SAVED FILTERS
13098323: AN ARITHMETIC OPERATION IS BEING CARRIED OUT ON A NON-NUMERIC TYPE
13350175: ADDING FILTER TO DIFFERENT LEVELS OF A HIERARCHY GETS IGNORED IN MDX
13511930: NEW COLUMN CREATED BASED ON TWO DIFFERENT DIMENSIONS RETURNS INCORRECT RESUTLS
13522060: RPD SESSION VARIABLE UNABLE TO IDENTIFY THE DYNAMIC SCHEMA NAMES FOR OLAP
13542805: BAD CACHE ENTRY BEING GENERATED
13626491: CONSISTENCY CHECK UPDATE FOR FACT JOINS DIRECTLY WITH A NON LEAF TABLE

Additional patches are also needed: 
* 13932572
* 13887566
* 13926409
* 13892934
* 13916045
* 13916045
* 13884769
* 13794002
Following is a compilation of the bugs that I cam across for the related patches for reference, an 
"official" list will be published soon from Support.
--------------------------------------------------------------------------
Patch 13932572:        Patch 11.1.1.6.2 Oracle Business Intelligence Installer
---------------------------------------------------------------------------
13560245:       BIDOMAIN/CONFIG/JDBC NOT FOUND.
13504454:       BLK - BIINSTANCE COPYCONFIG FAILURE ESSBASE MAXL LOGIN IS FAILING 
13510938:       NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD
13628293:       EMPTY PROCUREMENT DASHBOARD IN RC4
13565722:       BLK:        BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL
13589944:       BI T2P - PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR
13619973:       INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN
13683204:       STRESS:       FA:       CRM ERROR RESPONSE[NQSERROR:        43082] ILLEGAL OPERATION ATTEMPTED CLOSED
13724975:       RUP2 AIX HCM STARTERDB POSTCONFIGURE FAILED
13779029:       BI T2P BI RPD PLUGIN OPERATION ERROR WHILE LOADING SHARED LIBRARIES LIBARICU23
13687239:       RUP2_RC4 BI DOMAIN - BI ANALYTICS DATASOURCE TEST FAILS 
13780076:       USE BIPROV PROPERTIES FROM 13694505 
13404296:       BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS 
13485655:       T2P ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG
13896014:       RPDTRIM INCORRECT PROPERTY BIPROV.BI-HOME.DIR IN BI-CONTENT.XML FILE 
13896152:       TRIMRPD NOT ABLE TO CREATE BIPROJECTS.TXT BASED ON FAOFFERING LIST BAD XPATH ERR
13896209:       TRIMRPD RELATIVE BI ORACLE HOME LOCATION PASSED TO SCRIPTS DURING RPDTRIM
13898786:       TRIMRPD PLEASE MASK THE RPD PASSWORD WHICH IS LOGGED DURING _TRIMRPDTARGET EXEC
13910554:       MISSING CONNECTION PROPERTIES IN OBIEE RPD
13926479:       TRIMRPD FOR WINDOWS THE PROPS FILE SHOULD INCLUDE FORWARD SLASH IN DIR PATHS
---------------------------------------------------------------------------------
Patch 13887566:         Patch 11.1.1.6.2 Oracle Real Time Decisions
----------------------------------------------------------------------------------
13703826:       RTD Causes Bi_Server1 To Start Takes Long Right After Upgrade To 11.1.1.6.0
13240778:       Qa- Access- Ere- Rgrn- Error Accessing Lov Via Key; Can't Select Via Key 
9157691:        Server Need To Respond When The Timeout Expires, Not Wait Till End Of Request
13360752:       Unable To Load All Extension Columns For Customer In Rtd Studio 
13567294:       Removed 1St Value In Rule Becomes Nan 
13472560:       Qa-Access-High Contrast Setting Appears Cluttered, Some Items Not Visible 
13723256:       Rup2- Error While Accessing Oracle Rtd After Rup2 Patching
13537093:       Internal Server Error Shows When Click Print At Choice Group>Analysis>Quality
13779138:       Rule Editor Does Not Display Date In Operand
13539353:       Internal Error(Npe) For Entity Statistic
13780656:       New Studio Help Files For 11.1.1.6.2
13795529:       RTD Rule Editor Error-Cannot Move Focus To The Control
13408870:       Qa-Sdconfig 3X Values Copied To 11G But Not Used There
13409526:       Qa-Update Doc Copyrtddata_Readme.Txt For Stop Start 11G
13506987:       Copyright Information Needs To Be Extended To 2012
13347251:       Qa-Unable To See Ere In Dynamic Page In Safari Chrome
13805360:       Attribute Translations Not Seen In Adf Rules Editor
13816544:       Re Error When Selecting Double Without Decimal
-------------------------------------------------------------------------------------
Patch 13926409:         Patch 11.1.1.6.2 Oracle Business Intelligence Publisher
---------------------------------------------------------------------------------
11906714: QA:TIMEZONE NOT IN SYNC IN JOB MANAGER - JOB HIISTORY 
12312461: NLS:       MB DATA GARBLED IN JOB HISTORY USING SQL SERVER 
12645567: NLS:       WRONG WEEK OF YEAR FOR ORACLE DATE FORMAT CONTAINING WW 
12825409: INTERACTIVE VIEWER CONDITIONAL FORMATTING REPORT FAILS IN INTERACTIVE VIEWER 
13028918: CPU Bug 
13341249: BACKGROUND ON SCHEDULED REPORT DOES NOT PRINT 
13371841: QA:       ACTIONS DROPDOWN NOT SHOW CORRECT OPTION (NON ADMIN USERS) 
13445281: NLSHOT:       PREVIOUS 11G VERSION XLF FOR RTF TEMPLATE CAN'T WORK WELL ON 11.1.1.6 
13449368: DTE FARM MAIN NIGHTLY:        WEBPAGE ERROR WHEN EDIT DATA MODEL IN BIP 
13473493: XMLP TRANSLATION ISSUE OF MILLION (ENG) TO MILLIONES (SPANISH) 

---------------------------------------------------------------------------------
Patch 13884769:        Patch 11.1.1.6.2 Oracle Business Intelligence
---------------------------------------------------------------------------------
10167311: ADD TEST CASES FOR MDSXUDML GENERATOR AND PARSER
10199188: CHARTS X AXIS LABEL IS BLURRED AT 45/60 ANGLE
10391144: WEIRD BEHAVIOUR OF FILE OPEN DIALOG ON WINDOWS 7 COMPUTER
10647655: COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
11810127: ADMINTOOL TESTS FAIL:        EXTERNALIZATION
12411977: TERADATA RANK() IS NOT ALLOWED IN THE SUBQUERY
12426993: CHECKIN CONSISTENCY CHECK IS DIFFERENT FROM ADMINTOOL CONSISTENCY CHECK
12543094: EXPOSE THE SERVER ONLY CONSISTENCY CHECK IN THE ADMINTOOL UI
12612904: TOTAL PICKS VALUE IN FIRST ROW AND GIVES NOT A NUMBER WHEN AVERAGING NULL
12658173: SUMMARY ADVISOR STATS CACHE FILE NEEDS TO BE MORE ROBUST
------------------------------------------------------------------------------------------------------
Patch 13892934:        Patch 11.1.1.6.2 Oracle Business Intelligence ADF Components
-------------------------------------------------------------------------------------------------------
13365954: ERROR WHILE OVERWRITING AN ANALYSIS VIA BI COMPOSER
13597290: 11.1.1.7.0 ESSBASE DATA CONTROL CODE IS PRINTING UNWANTED DEBUG MESSAGES
13733098: REPORTS AND ANALYTICS, CANNOT  SAVE NEWLY CREATED REPORT
13858848: BIADFCOMPS - ANALYSIS CREATED USING COMBINE UNION IS NOT EDITABLE IN BI COMPOSER
--------------------------------------------------------------------------------------------------------
Patch 13916045:        Patch 11.1.1.6.2 Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
-----------------------------------------------------------------------------------------------------
13552700:       ORACLE.ESSBASE.EPM.JAPI_TEMPLATE SHOULD SET REQRD EPM PROPS IN SETDOMAINENV.SH
13631427:       DTE:       ESSBASE CANNOT CONNECT TO BI - BIFNDNEPM TXN
13614676:       CONFIGURE ESSBASE JAVAMAXOUTLINES FOR BI PLATFORM
13785544:       INCORRECT ALIASES ARE DISPLAYED IN THE FINANCIAL REPORTING MEMBER SELECTOR IN THE FINANCIAL REPORTING STUDIO AND IN WORKSPACE.
13785522:       FINANCIAL REPORTING REPORTS WITH ADVANCED MEMBER SELECTION DO NOT COMPLETE.
13769394:       FINANCIAL REPORTING REPORT FAILS WITH UNKNOWN MEMBER USED IN QUERY ERROR.
13741981:       SELECTING THE EXCEL ICON FOR FINANCIAL REPORTING REPORTS, THE PREVIEW USER POINT OF VIEW DIALOG IS NOT DISPLAYED IN FIREFOX.
13512669:       XMLSTREAMREADEREXCEPTION DISPLAYED IN BI STARTUP LOGS.
13427006:       THE FINANCIAL REPORTING BATCH NAME AND DUPLICATE EDIT PROPERTIES SHOULD BE IN VALID FORMAT.
13089241:       FINANCIAL REPORTING MAKES MULTIPLE API CALLS TO WEBCAT WHEN SAVING AN OBJECT.
11652873:       FINANCIAL REPORTING ANNOTATION VIEW PANE HAS PERMISSION ISSUES FOR ANNOTATION ON TEXT OBJECT.
9211682:        FAILED TO REGISTER THE FINANCIAL REPORTING WEB SERVICE CONFIG MBEANS.
13475602:       OFFSET MEMBER WILL NOT SHOW ON THE RIGHT HAND SIDE OF MEMBER SELECTOR 
13710417:       NLS:        MEDIUM DATE FORMAT FOR FR-CA SHOULD BE YYYY-MM-DD
13710429:       NLS:        MEDIUM DATE FORMAT FOR FR-CA SHOULD BE YYYY-MM-DD AT FLTER DIALOG 
13712484:       NLS:       NEED TO SUPPORT FRENCH_CANADA IN RUP4 
13509268:       FUSIONGL:       CHANGE THE DEFAULTS IN THE ALLCOAITON WIZARD TEMPLATE
13771676:       ALLOCATION MEMBERS SELECTOR IS NOT EXAPNDING FOR DIMENSIONS WITH BIG NUMBER OF MEMBERS
12530876:       PERFORMANCE OF FINANCIAL REPORTING REPORTS QUERYING ESSBASE APPLICATIONS WITH A LARGE NUMBER OF DYNAMIC CALCULATIONS MAY BE SLOWER.
12404364:       ESSBASE READ ONLY ACCESS INSUFFICIENT PRIVILEGE WITH PROMPT
13250047:       REMOTE ADM CAN'T GET ALL MEMBERS IN LARGE GRAINED INTERFACE
13686023:       IN FINANCIAL REPORTING REPORTS,  CHILD MEMBERS BECOME INVISIBLE IF THE SECURITY FILTER IS SET TO META READ ON PARENT MEMBER.
12765822:       DMS LOGS LOTS OF ERRORS WHEN ESSBASESERVER1 IS DOWN
13806230:       NULLPTR EXCEPTION WITH REGISTRYUPDATELISTENER (BIFNDNEPM PREFLIGHT)
13802437:       TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13801537:       TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13801547:       TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13684571:       INCREASE THE DEFAULT FOR JAVAMAXOUTLINES
10623654:        THE DATE AND TIME IS NOT LOCALIZED IN FINANCIAL REPORTING SCHEDULED BATCHES DETAIL INFORMATION.
13861897:       DURING THE LOGIN TIME THE ROLE OF THE GROUP BICONSUMERS IS NOT RETURNED BACK
13857776:       ESSOTLDELETEOBJECT CRASHED DURING SMARTLIST TEST ON LINUX64 AND WINDOWS32
11735177:       REHOSTING TOOL IS NOT TRANSFERRING PROPER USERNAME IN PARTITION DEFINITION
13826968:       SMBUARDESS2.SH AND SMBUARDMXL2.SH CAUSED .XCP FILE INTERMITTENTLY ON HPUX64
13874086:       Fix for backward compatabillity of getdatabaseinfo
13968116:       RUP3 ST5 CDRM:        ESS FAILS TO CONNECT TO ESSBASE
13967992:       RUP3 ST3/ST5 CDRM:       CANNOT CONNECT TO ESSBASE SERVER USING REGISTRY
13964528:       RUP3ST5CDRM / PROJECTS:         OLAP.SERVER.NETCONNECTRETRY ISSUE
13963796:       RUP3 ST3C:       ESS BASE SERVER IS DOWN LS BOUNCE
------------------------------------------------------------------------------------------------------
Patch 13794002:        Patch 11.1.1.6.2 Oracle Business Intelligence Platform Client Installer
-----------------------------------------------------------------------------------------------
13794002  BISHIPHOME 11.1.1.6.2 CUMULATIVE PATCH 1


Monday, April 30, 2012

Change Password (cont.)

I just noticed an interesting screen in BI-Publisher 11g (11.1.1.6) while looking at the screenshots in

Getting Started with Oracle BI Publisher 11.1.1.6.0

Using the "My Account" link, OBIEE 11g end-users can change their passwords without having to go through the not-so elegant approach documented in my previous blog entries.I might have missed this feature in 11.1.1.5, I remember seeing a screenshot in the help link, but the "Password" tab was missing in the app. 
- Log into BIP : http://HOST:PORT/xmlpserver/
- Select My Account

a+
Fiston