RSS

Yearly Archives: 2011

Allow IFrame bursting in/from OBIEE 11G

If you want to display OBIEE 11G content in any other portals using IFrames, You will end up with a message “OBIEE content cannot be displayed in an IFrame”. Because In OBIEE 11G, Oracle added framebusting check, to avoid the clickhacking security atatck.

To control the IFrame rendering we need to add the following tags in instanceconfig.xml within security key and restart the OBI Presentation Service.

<Security>

<InIFrameRenderingMode>allow</InIFrameRenderingMode>

</Security>

OBIEE 11G support 3 modes of IFrame bursting checks

1. prohibit: Never allow OBIEE 11G content to be rendered in IFrame.

2. sameDomainOnly: Allow rendering in IFrame if enclosing page was generated by the server in same domain.

3. allow: Always allows in-IFrame rendering.

So based on your requirement you need to change/add the IFrame bursting configurations to your OBI Presentation Server.

After this, Navigate to <Middleware_Home>\oracleBI1\bifoundation\web\app\WEB-INF\ and open the ‘web.xml‘ file.

Add the following highlighted entry to the file.

<servlet-mapping>
<servlet-name>SAWBridge</servlet-name>
<url-pattern>/saw.dll/*</url-pattern>
</servlet-mapping>

<servlet-mapping>
<servlet-name>RelatedContent</servlet-name>
<url-pattern>/RelatedContent</url-pattern>
</servlet-mapping>

<context-param>
<param-name>oracle.adf.view.rich.security.FRAME_BUSTING</param-name>
<param-value>never</param-value>
</context-param>

<login-config>
<auth-method>CLIENT-CERT</auth-method>
</login-config>

Restart all OBIEE 11G services to reflect these changes in application.

Thanks,

Shiva

Advertisements
 
11 Comments

Posted by on August 27, 2011 in BI Publisher, OBI EE, OBIEE 11g, Weblogic

 

Tags: , , , ,

How to Solve OBIEE 11G Authentication failure issue

After you migrate your RPD and Web Catalog t new environment,it is best practice to update the user GUIDs. If the same user name exists in both directory servers (original and new), then the original user GUID might conflict with the user GUID that is contained in new directory server. A refresh forces the system to reference the user GUID that is contained in the new directory server. Authentication errors might result if the GUIDs are not refreshed and the system detects a mismatch for the user GUID. And even after GUIDS referesh OBIEE 11g System will cache the UserID in webcatalog and always the cached ID will be callup instead of new GUID for User.This wrong GUID calling will leads to Authentication failure errors. Sometimes we can delete the user and recreate to solve this. But, This recreation of same user again miss its ID reference for Catalog objects.And We will end up with Missing My Folders and other objects. Because OBIEE 11G maps the RPD objects and Catalog objects based on system assigned GUID.To solve this we need to validate the Useraccounts to map the OBIEE RPD and Catalog object links.

To do this perform the following steps

1) Backup Instanceconfig.xml file from location:

<Middleware_HOME>\instances\instance1\config\OracleBIPresentationServicesComponent\

coreapplication_obips1\instanceconfig.xml

2) Open instanceconfig.xml, And update it with the content specified as following:

<Catalog>

<UpgradeAndExit>false</UpgradeAndExit>

<Validate>OnStartup</Validate>

<ValidateItems>None</ValidateItems>

<ValidateLinks>None</ValidateLinks>

<ValidateAccounts>Clean</ValidateAccounts>

<ValidateHomes>None</ValidateHomes>

</Catalog>

3) Save the file and re-start all of the BI Services through Enterprise Manager.

4) Now yo should be able to login to OBIEE 11g and you can see all your artifacts like My Folder content.

Once resolved, dont forget to remove the settings used to clean up the Cached catalog accounts in instanceconfig.xml. Restart the services. Test the login to make sure there are no issues.

Thanks,

Shiva

 
15 Comments

Posted by on August 26, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Export more than 6500 OBIEE 11g records to Excel

To Export more than 6500 OBIEE 11g records to Excel, perform the following steps:

1. Backup Instanceconfig.xml file from location:

<Middleware_HOME>\instances\instance1\config\OracleBIPresentationServicesComponent\

coreapplication_obips1\instanceconfig.xml

2. Edit instanceconfig.xml, with, for example, the content specified as following:

<Views>

<Pivot>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

<DisableAutoPreview>false</DisableAutoPreview>

<MaxVisibleColumns>300</MaxVisibleColumns>

<MaxVisiblePages>1000</MaxVisiblePages>

<MaxVisibleRows>1000</MaxVisibleRows>

<MaxVisibleSections>30MaxVisibleSections>

<DefaultRowsDisplayed>50</DefaultRowsDisplayed>

<MaxCells>500000<MaxCells>

</Pivot>

<Table>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

<MaxVisiblePages>1000</MaxVisiblePages>

<MaxVisibleRows>1000</MaxVisibleRows>

<MaxVisibleSections>30</MaxVisibleSections>

<DefaultRowsDisplayed>50</DefaultRowsDisplayed>

<MaxCells>500000<MaxCells>

</Table>

 

<Charts>

<MaxVisibleColumns>2000</MaxVisibleColumns>

<MaxVisiblePages>1000</MaxVisiblePages>

<MaxVisibleRows>2000</MaxVisibleRows>

<MaxVisibleSections>30</MaxVisibleSections>

<JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>

</Charts>

</Views>

 

3. Save the file and re-start all of the BI Services through Enterprise Manager.

Now you should be able to export more than 6500 records to excel.

 

 

Thanks,

Shiva


 
15 Comments

Posted by on August 26, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

List of Bug Fixes Included In OBIEE 11.1.1.5.0

When OBIEE 11g (11.1.1.3.0) released it has so many bugs including some spell mistakes too. Somebody might have got patches from oracle support for those issues.

Mostly, all of them are fixed in new OBIEE 11.1.1.5.0 release. for benefit of OBIEE supporters I am listing out full list of bugs fixed in OBIEE 11.1.1.5.0 release gathered from Oracle support.

The following is the list of Bugs fixed in OBIEE 11.1.1.5.0 Release including BI Publisher grouped by component :

Admin Tool

  • 7538753 SAP BW IMPORT DOES NOT RETRIEVE UNIQUE NAME FOR MEASURE COLUMNS
  • 10012297 ADMIN TOOL CRASH ON VERY LARGE EXPRESSIONS – OVERFLOW AT APPROX 3200 CHARACTERS
  • 10032385 TABLE MISSING IN SQL “FROM” CLAUSE – FWD PORT 8308443 TO 11G
  • 10045212 EQUALITY EXPRESSION IN LTS “WHERE” CAUSES INTERNAL SQORRQLIST ERROR ON QUERY
  • 10264475 ADMINISTRATION’S “SHUTDOWN SERVER” MENU SHOULD BE REMOVED
  • 10265121 ADMIN TOOL EXPRESSION BUILDER CRASHES ON DOUBLE-BYTE LOGICAL COLUMN NAME
  • 10394725 ON-LINE MODE CHECK-IN OF DYNAMIC INIT BLOCK CAUSES [43058] REFRESH LOCK FAILURE


Answers

  • 6521146 ERROR: “NO FILTER” WHEN USING “COMBINE WITH SIMILAR REQUEST” – UNION
  • 7534635 INACTIVATING DRILLDOWN ON COLUMN VALUE ALSO INACTIVATES COLUMN HEADER LINK
  • 9026854 CLARIFICATION REGARDING DATA FORMAT WHEN COMBINING REQUESTS
  • 9107277 KEEP THE NUMBER PRECISION IN DATABASE WHEN “DOWNLOADING TO EXCEL”
  • 9524080 PIVOT TOTAL DIFFERENT TO TABLE TOTAL WHEN REPORTAGGREGATEENABLED TRUE
  • 9697529 JAPANESE CHARACTER SET NOT PASSED CORRECTLY TO DRILL REPORT IN FIREFOX BROWSER
  • 9871470 SORTING ON A NULL VALUED COLUMNS GIVES ASSERTION ERRORS
  • 9886904 CORRECT DOC FOR ADDING CUSTOM DATE FORMAT STRING
  • 9918283 CORRECT DASHBOARD FORMATTING PROBLEMS WITH SCROLLING
  • 9928318 ROW HEADER MISSING AT PIVOT TABLE VIEW FOR MIGRATED REPORTS IN 11G
  • 9968574 SOME UPGRADED 10G CHARTS SHOW UP JAVA EXCEPTION
  • 10023165 MAPS DO NOT WORK IN MAP VIEWS WHEN JOIN COLUMN CONTAINS A “&” CHARACTER
  • 10065166 GAUGE RANGE IS NOT UPDATED WHEN IT CHANGES THE FIELD VALUE
  • 10078041 ACTION LINK DOES NOT WORK WHEN COMPOUND LAYOUT ONLY HAS A MAP VIEW
  • 10091354 “SCALE MARKERS” OPTION IS MISSING IN VERTICAL AXIS 2
  • 10147762 CANNOT SET GAUGE FOOTER (TITLE), KEEPS SHOWING “UNDEFINEDUNDEFINEDUNDEFINED”
  • 10182955 BUBBLE CHART IS NOT BEHAVING AS EXPECTED
  • 10213761 CONDITIONAL DASHBOARD SECTIONS (GUIDED NAVIGATION) ALWAYS RUNS REPORTS
  • 10229397 CANNOT SAVE REQUEST USING STANDARD DATE FORMATS.
  • 10282140 CELL IMAGE AT BLANK CELL OF PIVOT TABLE IS NOT DISPLAYED WHEN USING COND FORMAT
  • 10296730 UNABLE TO USE PRESENTATION VARIABLE IN SCALE MARKERS
  • 10312496 CHARTS. MEASURE LABEL IN GRAPH PROMPTS DOES NOT CHANGE CONTENT OF THE CHART
  • 10312795 ACTION LINK ON COLUMN HEADING NAVIGATION DOES NOT CONSIDER PROMPT VALUES
  • 10329343 CLICKING A LINE GRAPH BETWEEN TWO DATA POINTS DRILLS TO LAST VALUE IN HORIZONTAL
  • 10337649 PIVOT TABLE SHOWS BUTTONS FOR SORTING ON CALCULATED ITEMS.
  • 10402102 INCORRECT RESULT WHEN USING [NEW CALCULATED ITEM] PROP IN PIVOT TABLE
  • 10414887 DRILL DOWNS NOT WORKING IN CHART PIVOTED TABLE SELECTED FROM VIEW SELECTOR
  • 10418875 CHART SIZE IS CHANGING AFTER WEBCAT UPGRADE FROM 10G
  • 10634175 GRAPH ENGINE IS NOT RESPONDING
  • 10639913 COMPLETE TEXT IS NOT SAVED IN DB IF CURSOR IS MOVED AWAY DURING INSERT
  • 11711658 FILTER NEEDS TO SUPPORT UNTYPE LITERAL FOR RANK OPERATOR AS 10G DOES
  • 11805468 CUSTOMIZED GAUGE VIEW IS NOT CONSISTENT WHEN EXPORTED AS PDF,HTML AND XLS
  • 11817696 INCORRECT FILTER IS BUILT IF FILTER IS CONTRUCTED BEFORE SELECTING REQ. COLUMNS
  • 11845286 PIVOT TABLE WITH PERCENTAGES, GRAPHED PERCENTAGE VALUES DISPLAYED ARE INCORRECT
  • 11894921 GRAPH LABEL OPTIONS NOT AVAILABLE IN 11G
  • 11895279 INCORRECT FILTER VALUE WHEN USING ACTION LINK WITH GRAPH
  • 12412666 ALL PAGES LOSES CONDITIONAL FORMATTING
  • 12561361 PSE FOR BASE BUG 10295403 ON TOP OF 11.1.1.5.0 FOR GENERIC OS

CHARTING

  • 8990756 MISLEADING INFORMATION IN DOC REGARDING PIVOT TABLE SETTINGS

DASHBOARDS

  • 7459700 ABILITY TO SPECIFY FIXED COLUMN WIDTH TO A DASHBOARD PROMPT
  • 10177865 OBIEE 11G : DEFAULT VALUES CANNOT BE DE-SELECTED FROM MULTI SELECT PROMPT
  • 10279722 DASHBOARD SLIDER PROMPT SHOWS THUMB VALUES WITH TWO DECIMAL PLACES FOR INTEGERS
  • 10279829 DASHBOARD SLIDER PROMPT SHOWS WRONG VALUES FOR “ALL COLUMN VALUES” OR “SPECIFIC
  • 10310511 “REQUIRE USER INPUT” MESSAGE APPEARS THE FIRST TIME ONLY FOR THE REQUIRED PROMPT
  • 10389799 DASHBOARD NAVIGATION MAY CAUSE GETELEMENTBYTAGNAME ERROR IN IE
  • 10411545 PROMPT WITH BETWEEN OPERATOR AND SQL DEFAULT VALUES ARE NOT UPGRADED PROPERLY
  • 11056057 ERROR WHILE UPGRADING THE DASHBOARD WITH CERTAIN FILTER FUNCTIONS
  • 11076452 ABILITY TO CONSTRAIN PROMPTS AGAINST A SLIDER PROMPT
  • 11717024 ERROR 500 OCCURS WHEN SETTING ACCESSIBILITY MODE TO ON
  • 12620143 PSE FOR BASE BUG 12561330 ON TOP OF 11.1.1.5.0 FOR LINUX X86 [46] (PSE #602152)

INSTALL

  • 9459177 PREREQUISITES FOR DEPLOYMENT ON SEPARATE MACHINES
  • 9540009 UNIXCHK.SH ENCOUNTERS HOST NOT FOUND ERROR WHEN DNS IS NOT AVAILABLE.
  • 10071302 ENTERPRISE INSTALL: CONFIGURE PORTS : FORMAT OF INI FILE
  • 10126542 OBIEE 11G INSTALATION FAILS AT AS INSTANCE CREATION DUE TO PERM SIZE ERROR
  • 10287335 CANNOT START BISERVER1 . SWITCH TO JSSE FRAMEWORK REQUIRED
  • 10302421 OBIEE 11G WINDOWS PROMPTS FOR USERNAME / PASSWORD AFTER ENCRYPTING CREDENTIALS
  • 11849674 SAG: DISCREPANCY IN DOCUMENTED ORACLE DATABASE REQUIRED FOR MAPVIEWER

MIGRATION

  • 7432799 ORACLE EUL CONVERTER CRASHED WHILE GENERATING A REPOSITORY

REL_NOTES

  • 12604761 TWO STEPS OF THE UPGRADE TO 11.1.1.5.0 ARE NOT CLEARLY DOCUMENTED

SCHEDULER

  • 10036466 “RE-RUN INSTANCE(S) NOW” MENU IS NOT AVAILABLE FOR COMPLETED JOB INSTANCES

SECURITY

  • 8996295 PROVIDE DETAIL INFORMATION TO SETUP WNA(KERBEROS) FOR OBIEE AUTHENTIFICATION
  • 9216995 PROVIDE LATEST DETAIL INFORMATION ABOUT HOW TO SETUP LDAP SSL FOR OBIEE
  • 10194154 TECHNOTES- PROVIDE DETAIL INFORMATION TO SETUP WNA(KERBEROS) FOR OBIEE AUTHENT
  • 10198837 BIEEHOME LOGIN PAGE IS NOT DISABLED EVEN AFTER ENABLING THE SSO
  • 10218031 USING EXTERNAL DB TABLE TO SET ROLES SESSION VARIABLE DOESN’T ACCEPT LONG NAMES
  • 10373788 IF OBJECTGUID PUBLISHED AND SAMACCOUNTNAME CHANGED USER CANNOT CONNECT ANYMORE
  • 11731080 QA:SECURITY GUIDE NEEDS UPDATE FOR DEFINING A USER SESSION VARIABLE

SERVER

  • 6510747 NETWORK FAILURE DURING PHYSICAL QUERY HANGS END USER WITHOUT ERROR MESSAGE
  • 6836444 OBIEE SERVER SYSTEM DATE IS WRONG AND DOES NOT MATCH MACHINE SYSTEM DATE
  • 8371912 BI SERVER CRASHES ON NAVIGATION SPACE MAP RACE – SR 3-887711721
  • 9433198 DOCUMENT SYSLOG ENTRIES IN SYSTEM ADMINISTRATOR’S GUIDE
  • 9696424 DOC INSTANCECONFIG PARMS ALLOWEDLANGUAGES & ALLOWEDLOCALES IN SYSADMIN GUIDE
  • 9954411 PSR:MOD_SUPPORTED NOT ENABLED FOR TERADATA AND CAUSES CAMPAIGN SLOW PERFORMANCE
  • 10258683 REQUEST WITH COMPLEX FILTER IS CONSUMING ALMOST ALL CPU & NO SESSION IS CREATED
  • 10258755 EXCEL FAILS TO CONNECT TO 11G BI SERVER USING ODBC DSN
  • 10335924 REPORT-BASED TOTALS FAIL ON MEASURES CONTAINING AGGREGATION EXPRS SUCH AS FILTER
  • 10374571 NEED FLEXIBILITY TO OVERRIDE HOSTNAMES WHEN CUSTOMER DNS IS INCORRECT OR BROKEN
  • 10650122 PIVOT VIEW WITH UNION OF NON – COMPATABLE TYPE ERROR IN OBIEE 11G AFTER UPGRADE
  • 11804596 NQQUERY LOG LEVEL 2 IS TOO VERBOSE – BACKPORT 10308263 TO 11.1.1.5
  • 11809295 NQUDMLGEN NOT GENERATING UDML FILE IN UTF FORMAT

UPGRADE

  • 9886765 ERRORS ENCOUNTERED WHEN UPGRADING WEB CATALOG USING UA.BAT
  • 10121344 ERROR IN LOG USING UA TO UPGRADE BI SCHEDULER SCHEMA ON SQL SERVER DATABASE
  • 11069928 UPGRADE SHOULD HANDLE PROMPT WITH INCONSISTENT VALUES AS 10G DOES

WEB_ADMIN

  • 8564456 SHARED FOLDER ACCESS PERMISSION ISSUE
  • 9381764 CATALOG MANAGER COPY FUNCTION NOT WORKING AS EXPECTED
  • 9739865 EXITING MANAGE SESSION RESULTS IN HTTP ERROR
  • 10016252 LACKING INFORMATION ON FORCEABSOLUTECOMMANDURL FOR ABSOLUTECOMMANDURLPREFIX
  • 10144989 WEB CATALOG DOES NOT UPGRADE TO 11.1.1.3.0
  • 10218524 VALIDATION ERROR AFTER THE UPGRADE OF WEBCATALOG TO OBIEE 11G
  • 11723425 INCORRECT DEFAULT VALUE OF DEFAULTROWSDISPLAYED IN THE INSTANCECONFIG.XML
  • 11827202 OPMN NOT STARTING AFTER SETTING UP THE REPLICATION AGENT

WEB_GNRL

  • 10191078 FILTER VALUES ARE RESET IN GO URL WHEN COLUMNS ARE SORTED OR RE-ARRANGED
  • 10360461 NEED ABILITY TO CONTROL NEW, DASHBOARD AND OTHER HEADER LINKS
  • 11780508 10G COLUMN FILTER PROMPT WITH PROMPTCAPTION ATTR NOT UPGRADING
  • 12416695 TOOLTIP EMPTY IN MAPVIEWER

WEB_INTGRT

  • 10294759 FMAP-REFERENCED IMAGES IN ANALYSIS HEADERS DON’T APPEAR IN DOWNLOADS TO EXCEL

WEB_MKTG

  • 8692820 DIRECT DATABASE CAMPAIGN LOAD FORMAT COMBINED LISTS FAILS
  • 9908019 SAW SERVER CRASH WHEN LOADING A PARTICULAR CAMPAIGN
  • 9935859 UNGROUP OF SEGMENT BLOCKS CORRUPTS SEGMENT DEFINTION AND BAD COUNTS
  • 10331355 MOVING CRITERIA WITHIN A SEGMENT’S GROUP CORRUPTS THE INCLUSION OPTIONS

List of Bug Fixes Included In Oracle BI Publisher 11.1.1.5.0

The following is a list of all bug fixes included in Oracle BI Publisher 11.1.1.5.0, grouped by type:
  • Administration (ADMIN)
    • Bug 9381019 XMLP ROLES NOT HONORED WITH SSO ENABLED FOR AD SYNCHED USERS.
    • Bug 9934771 UNABLE TO LOGON TO PUBLISHER USING SECURITY MODEL EBS: JAVA.LANG.ILLEGALACCESSER
    • Bug 10326227 EBS SECURITY MODEL INTEGRATION SIGNON W/CASE SENSITIVE PASSWORD NOT SUPPORTED
  • Install and Upgrade (BIPUPGRADE)
    • Bug 11665472 BI PUBLISHER REPOSITORY UPGRADE FROM 10G TO 11G FAILS WHEN A 10G FOLDER IS EMPTY
  • Core Formatting API (CORE)
    • Bug 9727000 CSV OUTPUT COLUMN ORDER DOES NOT MATCH SQL SELECT COLUMN ORDER
    • Bug 10182980 ER: WAY TO FORMAT DATES (E.G. D HH:MM:SS) ON Y AXIS AND MARKER TEXT IN CHART
  • Data Model (DATAMODEL)
    • Bug 10226625 MDX STATEMENTS THAT INCLUDE “+” DO NOT WORK WITH PUBLISHER 11G
    • Bug 10231671 MDX QUERY WITH NAMED SETS NOT RETURNING EXPECTED RESULTS.
    • Bug 10303941 BIP11G: RESPONSEDATA XPATH FILTER NOT APPLIED TO XML DATA RETURNED BY WS SOURCE
    • Bug 10365310 EXCEPTION/ERROR WHEN THERE IS A COLUMN NAMED IN CHINESE IN BI ANALYSIS
  • Delivery Service and API (DELIVERY)
    • Bug 9848981 SFTP FAILS TO NEGOTIATE SECONDARY CIPHER
    • Bug 9937937 SSHTOOLSPRIVATEKEYFORMAT.CLASS & OPENSSHPRIVATEKEYFORMAT.CLASS FAILS TO LOAD
  • Integration (INTG)
    • Bug 9646599 USER ROLE DEFINED AS PRIMARYGROUP IN ACTIVEDIRECTORY GROUP ARE NOT RECOGNIZED
    • Bug 9664768 ER: NEED TO BIND USER ATTRIBUTE VALUES DEFINED IN ACTIVEDIRECTORY IN DATA QUERY
    • Bug 9704401 ER: NEED TO SUPPORT DEFAULT GROUP FOR ALL USERS IN LDAP/AD SECURITY
    • Bug 9753736 SOME ROLES FROM ACTIVEDIRECTORY ARE NOT LISTED IN ADMIN ROLE-FOLDER MAPPING
    • Bug 10221061 CATALOG NOT DISPLAYED USING BI SERVER SECURITY W/ EXTERNAL TABLE AUTHENTICATION
    • Bug 10367106 CANNOT CREATE DATA SET IF BI ANALYSIS HAS JAPANESE COLUMN NAME
  • Layout Tools (LAYOUTTOOL)
    • Bug 9811428 CANNOT INSTALL BI PUBLISHER DESKTOP ON WINDOWS 7
    • Bug 10036545 UNABLE TO UPLOAD OR VALIDATE RTF TEMPLATE WITH UNNAMED MERGEFIELD
    • Bug 10037640 LOGIN SCREEN APPEARS AFTER INSTALL OF ANALYZER FOR EXCEL USING SSO
    • Bug 11061157 HYPERLINK WITH DATA PARAMETERS IS NOT WORKING CORRECTLY BI PUBLISHER LAYOUT
  • Scheduler (SCHEDULE)
    • Bug 9053770 CSV REPORT OUTPUT WHEN SENT VIA EMAIL HAS .DAT EXTENSION OR NO EXTENSION
    • Bug 10052481 ETEXT REPORT FAILS WHEN RUN AS A SCHEDULED JOB
    • Bug 11685035 OBIEE 11G : BI PUBLISHER WEBSERVICE CALL TO SCHEDULE A REPORT FAILS
    • Bug 11776420 CURRENT PARAMETER VALUE IS NOT BEING DISPLAYED USING SCHEDULER
    • Bug 12347367 SCHEDULE FAILS IF A REPORT HAS HIDDEN PARAMETER
  • Templates (TEMPLATES)
    • Bug 9571670 ER: EXCEL TEMPLATE TO SUPPORT XSLT LOGIC AND XSL CUSTOM EXTENTIONS
    • Bug 9706624 FONT MAPPING FOR PDF TEMPLATES IS NOT WORKING FOR CZECH CHARACTERS
    • Bug 10072475 ER: PARAMTERS INCLUDED IN PRINT HEADER FOR EXCEL EXTRACTS
    • Bug 10118898 BI PUBLISHER TEMPLATE VIEWER ADDS UNEXPECTED BLANK PAGES IN FIXED SIZE TEMPLATE
    • Bug 10139027 RTFPROCESSOR THROW EXCEPTION
    • Bug 10143841 ER: PARAGRAPH-ALIGNMENT LOST WHEN BLOCK IN A LIST AND OUTPUT-FORMAT IS RTF
    • Bug 10143943 ER: PARAGRAPH-PROPERTIES ARE LOST WHEN PARAGRAPH IS IN A LIST
    • Bug 10303133 ER: BI PUBLISHER TABLE IS NOT GETTING CENTERED WHEN OUTPUT IS HTML
    • Bug 10304256 BULLETS AND NUMBERING DO NOT WORK TOGETHER
  • Web Server (WEBSERVER)
    • Bug 7420229 QUERY FROM BI PUBLISHER REPORTS APPEARS TO MISS/SKIP THE CACHE FOR LIST OF VALUE
    • Bug 9669973 ER: NEED TO SUPPORT PRE-PROCESSING XML WITH XSL FOR EXCEL TEMPLATE
    • Bug 10337868 TAB DELIMITER DOES NOT WORK FOR A CSV OUTPUT
    • Bug 11670678 RUNNING CLOCK INDICATOR ( HOURGLASS ) DOES NOT SHOW UP FOR HTML OUTPUT
    • Bug 11679262 SYSDATE SYNTAX {$SYSDATE()$} NOT WORKING FOR DEFAULT VALUE IN REPORT PARAMETERS
    • Bug 11718291 DATE PICKER OF DATE PARAMETER IN A REPORT HIDES BEHIND THE PDF OUTPUT IN IE8
  • E-Business Suite – XDO (XEBS)
    • Bug 9747198 WATERMARK IN ARABIC IN PDF APPEARS FROM LEFT TO RIGHT – SHOULD BE RIGHT TO LEFT
    • Bug 9836706 INCORRECT NUMBER FORMAT FOR CARRY FORWARD CALCULATION
    • Bug 9860192 CONVERSION TO PDF FORMAT FAILS WITH ERROR – FOR INPUT STRING: “4901001241”
    • Bug 10321578 PERFORMANCE ISSUE WHEN USING PDF TEMPLATE
Hope this post helps you to find the fixes for OBIEE 11G product.
Thanks,
Shiva
 
1 Comment

Posted by on June 23, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

BI Publisher Usage Tracking in OBIEE 11g

In new OBIEE 11.1.1.5.0 oracle added more data to audit and monitor especially more BI Publisher reports specific information such as:

  • Report output format type
  • Layout Template name
  • Reporting locale
  • If the reports is run online (on-demand) or through the scheduler
  • Processing time
  • Reporting data size
  • Report error message
  • Scheduled job information

And these information can be all available through the database tables so you can use BI Publisher to generate your Auditing reports or visualize the data to gain more insights about how your users are doing on your reporting platform.

A detailed walk through video on this New feature can be found here:

 

 

Thanks,

Shiva

 
3 Comments

Posted by on June 19, 2011 in BI Publisher, OBIEE 11g

 

Tags:

OBIEE 11.1.1.3.0 to 11.1.1.5.0 – In-Place-Upgrade

During my 11G journey am frequently asking for “How to upgrade new OBIEE 11.1.1.5.0 on top of OBIEE 11.1.1.3.0” i.e. In-Place-Upgrade. So thought of writing a post on this topic today. Hope this helps you in your executions.

When we are moving from OBIEE 11.1.1.3 to 11.1.1.5 there are two ways to upgrade our environment.

  1. out-of-place upgrade : This is quite simply installing new OBIEE 11.1.1.5.0 by uninstalling 11.1.1.3.0 or maintaining two Middleware homes.
  2. in-place upgrade : This upgrade operates on existing files. Moving from one 11g release to another 11g release. The advantage of this is we can still have custom configurations which are configured in 11.1.1.3.0 version. Because technically this just upgrade the new BI binaries not the configurations.

As you all know how to do the out-of-place upgrade. Today am going to explain about in-place upgrade.

Here are the basic steps of the ‘in-place upgrade’. And also you can find the upgrade document @ http://download.oracle.com/docs/cd/E21764_01/bi.1111/e16452/bi_plan.htm#BABECJJH

  1. Download the appropriate Product Installers
  2. Patch Oracle WebLogic Server to the latest version (10.3.5)
  3. Run the Oracle BI Product Installer, and perform a Software Only installation, specifying the existing Middleware home to be upgraded.
  4. Run the Patch Set Assistant for each of the Oracle BI schemas created with RCU.
  5. Upgrade BI system components
  6. Update Fusion Middleware Shared Libraries
  7. Update configurations and stores
  8. Upgrade code grants (that is, security policy artifacts) for Oracle BI
  9. Upgrade OBIEE catalogs
  10. Start servers and processes.

Before you start perform the following general pre-upgrade tasks:

  • Stop all WebLogic Servers, Node Manager, OPMN, and OPMN-managed system components that are part of all Oracle BI domains that use the Middleware Home that you must upgrade.On Windows systems, also stop the component that is called Oracle WebLogic NodeManager (name).
  • Back up directories.

 

Patch Oracle WebLogic Server to the latest version (10.3.5):

 

With OBIEE 11.1.1.3.0 installation we will have WebLogic Server (WLS) is 10.3.3. But the new OBIEE 11.1.1.5.0 requires weblogic 10.3.5. so you need to upgrade this to 10.3.5 before installing/upgrading OBIEE. In order to upgrade weblogic you will need this 10.3.5 upgrade version of WLS, which you can download from Oracle Metalink site.

Upgrade WebLogic Server

1. After unzip the downloaded file, launch wls1035_upgrade_generic.jar if you’re on Windows 64bit family.(e.g.: java –jar wls1035_upgrade_generic.jar)

2. Accept all the default values and keep ‘Next’ till end, and start the upgrade.

Once the upgrade process completes you’ll see the following window. But don’t select Run QuickStart checkbox and click Done button.

 

Run the Oracle BI Product Installer, and perform Software Only installation:

Download the OBIEE 11.1.1.5 version from  OTN page.

1. Launch the installer by double click ‘setup.exe’ (for Windows)

2. Select ‘Software Only Install’ option

3. Select your original Middleware Home where you installed OBIEE 11.1.1.3.

4. Click ‘Install’ button to start the installation.

This upgrades the OBIEE System to 11.1.1.5.0 from 11.1.1.3.0

Run the Patch Set Assistant for each of the Oracle BI schemas created with RCU:

You need to upgrade the BIPLATFORM and MDS Schemas. Run the Patch Set Assistant for each of the Oracle BI schemas created with RCU.Update the MDS schema first.

  1. MDS
  2. BIPLATFORM

Upgrade MDS schema:

psa.bat -dbConnectString Shivapc:1521:orcl -dbaUserName sys -schemaUserName DEV_MDS

Upgrade BIPLATFORM schema:

psa.bat -dbConnectString Shivapc:1521:orcl -dbaUserName sys -schemaUserName DEV_BIPLATFORM

 

Upgrade BI system components:

This step is required for any system component that is associated with a WebLogic domain.

After you have patched your system component software that is associated with a WebLogic domain, you must run E:\MW\Oracle_BI1\opmn\bin\upgradenonj2eeapp.bat (on Windows operating systems) script to update your system components.

Before running this script, make sure:

  1. The Administration Server is up and running.
  2. The OPMN instance in the bin directory in the Instance home is up and running.

Here is the syntax for the ‘upgradenonj2eeapp.bat command.

upgradenonj2eeapp.bat
-oracleInstance Instance_Home_Location
-adminHost WebLogic_Server_Host_Name
-adminPort administration_server_port_number
-adminUsername administration_server_user

And here is an example:

cd E:\MW\Oracle_BI1\opmn\bin
upgradenonj2eeapp.bat -oracleInstance E:\MW\instances\instance1 -adminHost Shivapc -adminPort 7001 -adminUsername weblogic

Update Fusion Middleware Shared Libraries:

 

Upgrade Shared Library (JRF)

For each WebLogic Server domain, you must run the updateJRF() WLST command to update the shared libraries in your domain. Before you do this, you need to stop all running instances, Managed Servers, Administration Server, and Node Manager in the domain.

Here is an example of the ‘upgradeJRF()’ command:

cd E:\MW\oracle_common\common\binwlst.cmdupgradeJRF(‘ E:/MW/user_projects/domains/bifoundation_domain’)

Upgrade Fusion Middleware Security (OPSS)

For each WebLogic Server domain, you must run the upgradeOpss() WLST command to update your configurations and stores from previous releases to Release 11.1.1.5.0 configurations and stores using a system-jazn-data file in Release 11.1.1.5.0. You can use ‘upgradeOpss()’ WLST command. Here is a syntax for the command.

upgradeOpss(jpsConfig=”existing_jps_config_file”, jaznData=”system_jazn_data_file”)

The ‘existing jps-config.xml file can be found under E:\MW\user_projects\domains\bifoundation_domain\config\fmwconfig\jps-config.xml and the ‘system_jazn_data_file’ can be found under E:\MW\oracle_common\modules\oracle.jps_11.1.1\domain_config\system-jazn-data.xml.

And here is an example:

cd E:\MW\oracle_common\common\binwlst.cmdupgradeOpss(jpsConfig=”E:\MW\user_projects\domains\bifoundation_domain\config\fmwconfig\jps-config.xml”, jaznData=”E:\MW\oracle_common\modules\oracle.jps_11.1.1\domain_config\system-jazn-data.xml”)exit()

Upgrade Code Grants for Oracle BI Domain

If you are updating to the latest version of Oracle Business Intelligence (BI) from Release 11.1.1.3.0, you must run the bi-upgrade.py script in each Oracle BI domain. This script configures the code grants necessary to ensure that SSL works correctly for Oracle BI, and must be run even if SSL is not used. And if you have multiple BI domains (Enterprise deployment) then you need to run this on each domain.

Here is an example:

cd E:\MW\oracle_common\common\binwlst E:\MW\Oracle_BI1\bin\bi-upgrade.py –bioraclehome E:\MW\Oracle_BI1 –domainhome E:\MW\user_projects\domains\bifoundation_domain

Upgrade OWSM Policy Repository

This is to upgrade OWSM (Oracle Web Service Manager) policy repository, you can use WLST command ‘upgradeWSMPolicyRepository()’. In order to run this command you need to have your WebLogic Server up-and-running. Here is an example.

cd E:\MW\user_projects\domains\bifoundation_domain\binstopWebLogic.cmdcd E:\MW\oracle_common\common\binwlst.cmd
connect (‘weblogic’,’weblogic14′,’t3://Shivapc:7001′)
upgradeWSMPolicyRepository()exit()

Upgrade OBIEE catalogs:

When updating your Oracle Business Intelligence (BI) software from Release 11.1.1.3.0 to 11.1.1.5.0, you must manually update your Oracle BI Presentation Catalogs. Instructions are provided below:

  • Shut down Oracle BI Presentation Services using Oracle Enterprise Manager.
  • Back up your Release 11.1.1.3.0 catalogs by using the 7-Zip utility to create a compressed file for it.
  • Create a backup copy of the instanceconfig.xml file.

The instanceconfig.xml file is located in the E:\MWH\instances\instance1\config\OracleBIPresentationServicesComponent\ coreapplication_obips1.

Change the upgradeAndExit option to true in the instanceconfig.xml file.

Find the following code:

<ps:Catalog xmlns:ps=”oracle.bi.presentation.services/config/v1.1″>

   <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
</ps:Catalog>

Change it to the following:

<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
   <ps:UpgradeAndExit>true</ps:UpgradeAndExit>
</ps:Catalog>
  • Start Oracle BI Presentation Services using the following OPMN command the update the catalogs:
  • opmnctl startproc ias-component=coreapplication_obips1

For example, On a Windows operating system:

cd E:\MW\instances\instance1\bin
opmnctl startproc ias-component=coreapplication_obips1
  • After the catalogs are updated, edit the instanceconfig.xml file again and change the upgradeAndExit option back to false.
  • Restart Oracle BI Presentation Services using Fusion Middleware Control.

Login to analytics and make sure it’s working fine.

 

 

Thanks,

Shiva

 
4 Comments

Posted by on June 19, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , ,

New OBIEE 11.1.1.5.0 available for download on OTN

The new OBIEE 11.1.1.5.0 is released with lot of bug fixes and few new features and with mostly Zero training to interact on iPhone/iPad. Oracle also released OBI Apps 7.9.6.3 which is the first BI Apps for OBIEE 11g. These are available for download on Oracle Technology Network.

Below I have listed out few resources links.

OBIEE 11.1.1.5.0 and OBI Apps 7.9.6.3 download link:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html

OBIEE 11.1.1.5.0 documentation link:

http://download.oracle.com/docs/cd/E21764_01/bi.htm

OBI Apps 7.9.6.3 documentation link:

http://download.oracle.com/docs/cd/E20490_01/index.htm

Thanks,

Shiva

 
2 Comments

Posted by on May 6, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: ,