X

An Oracle blog about BI Publisher

  • APEX
    January 9, 2012

BI Publisher January patch for 11.1.1.5.0

The BI Publisher January patch for 11.1.1.5.0 is now available on Metalink; look for patch 13554951. Thanks to Shinji and team, this is one of the easiest posts of the year so far :0) Contents of the readme below, enjoy!


One-off patch for
Oracle Business Intelligence Publisher 11.1.1.5.0
READ ME File
==================================================

This patch contains fixes of following bugs for Oracle Business Intelligence Publisher 11.1.1.5.0.

 9102877 - QA: QUERY BUILDER GENERATES INCORRECT SQL FOR MANY DBS
10071370 - IF 'USE SECURE FTP' IS CHECKD ON ADMIN PAGE, ITS SERVER IS NOT LISTD WHEN SCHED
10402890 - SETTINGS FROM "DELIVERY CONFIGURATION" PAGE NOT BEING HONORED WHEN REPORTS RUN
11725468 - ER: RTE HTML SUPPORT IN DATA XML
11828672 - QA: INCORRECT INACTIVE WARNING MESSAGE
11835845 - 11G SQL DATA SET CREATION ORA-01756 ERROR BECAUSE COLON IS READ AS BIND VARIABLE
11850902 - SHARE REPORT LINK "NO PARAMETERS" AND "DOCUMENT ONLY" RENDER INCORRECTLY
11870449 - BI PUBLISHER XDOXSLT:SDIV() FUNCTION RESULTS NOT CORRECT
12312539 - QA: REPORT VIEWER SCREEN FREEZES FOR A FLEX REPORT WHEN SESSION EXPIRES
12376386 - REMOVETEMPLATEFORREPORT API DOESN'T REMOVE TEMPLATE
12405904 - CANNOT DEPLOY BIP WHEN DEPLOYMENT PATH INCLUDES SPACE CHARACTERS
12406034 - CANNOT USE JAVA DB - DERBY - FOR SCHEDULER DATABASE
12570248 - PROJECTS : -GENERATE REV/INV PROCESS ERRORING OUT
12588342 - DELETEOBJECT RANDOM FAILURE
12595931 - WHEN PRINTING CHARTS TO PDF, NUMBERS BECOME ARABIC NUMBERS
12615821 - MISSING MEMBERS ON THE XML GENERATED BY BIP
12634030 - RE-PACKAGING MLR#11893189 TO XDOPARSER11G.JAR
12646493 - ORA-22902 CURSOR EXPRESSION NOT ALLOWED
12666066 - ER: EXCEL 2007 SUPPORT IN REST API
12705244 - JOINED MDX DATA SETS DO NOT PRODUCE CORRECT DATA - DATA MISSING
12726163 - NUMBER OF SESSIONS INCREASES AFTER RUNNING SCHEDULED JOBS
12737670 - GROUP BY FOR MDX DATA SET MISSING IN 11.1.1.5 - WAS PRESENT IN 11.1.1.3
12741858 - BI ASNWERS ANALYSIS IMPLEMENTING CASE WHEN STATEMENTS CAN NOT BE CONSUMED IN BIP
12750192 - ER: GENERATE NATIVE COMBINATION DUAL Y GRAPH IN PPTX OUTPUT FROM RTF AND XPT
12766932 - VERTICAL DUAL Y COMBO CHART MISSING SETTINGS TO ASSIGN VALUES TO AXIS
12775400 - DBFW:GENERATING IN XLXS OUTPUT IS THROWING AN ERROR
12822514 - SQL WITH CLAUSE - DATASET DOESN'T WORK (AND DIAGNOSTIC ISN'T HELPFUL)
12828845 - ISSUE WITH XDO_USER_NAME PARAMETER ON BIP 11.1.1.5.0
12835431 - INTRANSIT VALUATION REPORT QUERY GIVING ERROR IN EDITOR
12847306 - BI PUBLISHER DATA SET - WON'T SAVE
12872831 - EXCEL TEMPLATES GENERATING INCORRECT RESULTS FROM NESTED GROUPS
12879801 - ALLOW SAVING DATA MODEL WITH SPECIAL CHARACTER
12945367 - NOT ABLE TO EDIT DATA MODEL WHEN LINKS EXIT AMONG DATA SETS
12945475 - IE: NOT ABLE TO EDIT DATA MODEL WITH MANY DATA SET AND LINKS
12956901 - IN SQL SERVER CLOB IN DATA MODEL UI MARKED AS STRING DATA TYPE
12956915 - INCORRECT DATA WHEN PROCESSING OF CLOB COLUMNS FOR SQLSERVER
12956934 - DATA MODEL SHOULD RESPECT CASE SENSITIVITY FOR COLUMN AND TABLE NAMES
12972559 - XML DATA FILE TRUNCATED
12972852 - DYNAMIC IMAGES BROKEN FOR FO/PDF
12989467 - NEED TO CONVERT DOCUMENT FORMAT "EXCEL" TO "EXCEL2000"
13005659 - PSR:PERF:BIP:POOR PERF ACCESSING CATALOG FOLDER IN BIP 11G WITH SECURITY ENABLED
13007341 - DISPLAY ISSUES IN PARAMETER TAB OF OBI PUBLISHER 11G
13095050 - STRESS: OUTOFMEMORY ERRORS WITH VIEW REPORT STRESS
13100021 - BI PUBLISHER: QUERY BUILDER RESULTS RETURN COLUMN TYPE (APPEARS) INSTEAD VALUE
13100220 - HOW TO USE 11.1.1.5 WITH THE IDENTITY ASSERTER
13250009 - FOR METADATA LOGICAL SQL BIND WITH DUMMY VALUES INSTEAD OF NULL
13321449 - RESOURCELIMITEXCEPTION DURING ANY OPS THAT USE JNDI DATA SOURCE
13346737 - MULTIPLE VALUES IN A DASHBOARD PROMPT DOESN'T WORK WITH BI PUBLISHER INTEGRATED
13351305 - QUERY BUILDER DOES NOT BUILD CORRECT SYNTAX FOR SQL SERVER
13393658 - PRINTER DELIVERY [0] STATUS: FAILED PRINTING FROM WEB SERVICE CALL FROM EXTERNAL
13421264 - ADDING PARAMETER TO SQL BI SERVER DATA SET CORRUPTS DATA MODEL
13481659 - CAN'T SAVE ON BI DEV ENV RC2
13501838 - ORA-00923 ISSUE WHEN CREATING A BI PUBLISHER DATASET
13521951 - BIP UPGRADE FROM 10G TO 11.1.1.5.0 IS NOT SUCCESSFULL FOR TIAA-CREF
13529494 - BI REPORT NOT GENERATED WHEN HTML CONTAINS INVALID ATTRIBUTES

-----------------------------
INSTALLATION FOR ENTERPRISE
-----------------------------

1. Login to BI Domain Weblogic Administration Console.

2. Find the location of the "bipublisher" application.

3. Stop the bipublisher application.

4. Open a terminal and go to the directory.

5. Back up the existing xmlpserver.ear to xmlpserver.ear.org.

6. Copy new xmlpserver.ear from this patch.

7. In Admin Console, select "Lock & Edit".

8. Select the application "bipublisher" and "Update".

9. Leave all options same and proceed to Finish.

10. Select "Activate Changes".

11. Start the bipublisher application.


-------------------------
MDX Query Limitation
-------------------------

Joins of two MDX queries on a dimension that uses a MDX function in the Select Clause that requires the stipulation of the same dimension, such as Intersect, MemberRange, Union are not supported.
Example)
SELECT
NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
Hierarchize(Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)) ON Axis(1)
FROM Demo.Basic

It should be written using a With Set member:
with set [UnionMarket] as '{Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)}'
SELECT
NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
Hierarchize(([UnionMarket]) ON Axis(1)
FROM Demo.Basic

This MDX set is recreated for the Join clause to:
with set [UnionMarket] as '{Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)}'
SELECT
NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
Hierarchize(Filter([UnionMarket], [Market].CurrentMember.Member_Name = "Boston")) ON Axis(1)
FROM Demo.Basic

-----------------------------------------
Query Builder limitation with Microsoft SQL Server
-----------------------------------------


Query Builder doesn't support a cross join that does not have a WHERE clause and
produces the Cartesian product of the tables involved in the join.
The size of a Cartesian product result set of such join is the number of rows
in the first table multiplied by the number of rows in the second table. A cross join has
a very limited use in everyday data retrieval.


-----------------------------
HTML text support in XML
-----------------------------

This patch supports HTML embedded in XML. The following new layout command
is added to retain HTML format from data in the final output.
<?html2fo: xpath?>
Example:
html code in xml data:
user should input the html code to xml data file as CDATA.
sample, html code is embedded in field RTECODE.

<?xml version="1.0" encoding="UTF-8"?>
<RTECODE>
<![CDATA[
<font style="font-style: italic; font-weight: bold;" size="3"><a
href="http://www.oracle.com">oracle</a></font> <br/>
<font size="6"><a href="www.oracle.com">www.oracle.com</a></font><br/><br/>
]]>
</RTECODE>


Sample usage in rtf template (assume the data.xml is as above).
<?html2fo:RTECODE?>

Supported html formats:
Paragraph
Font style ( bold, italic, plain, underline,
subscript, superscript and strikes-through)
Font size
Font family
Background color
Foreground color
Paragraph alignment (center, left, right and justify)
Paragraph indent
URL link
List
Bullet List
Number List
Non-Supported formats:
Nested List (List with Indent)
Some HTML tags/attributes which manually inserted like Table, Image, etc... in stead of HTML editor
Sample Report:
XML: html_test.xml
RTF tempalte: html_test.rtf

Join the discussion

Comments ( 1 )
  • Tony F Friday, January 13, 2012

    Hi Tim,

    Can I apply this January patch directly to default 11.1.1.5.0 install or so I need all the previous patches like December patch, ect? Basically is this a cumilative patch for 11.1.1.5.0 or does it only include fixes from December to January?

    Tony


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha