Saturday, October 26, 2013

Installing OBIEE Patchset 11.1.1.7.131017 on Windows

Please note OBIEE Bundle Patch 11.1.1.7.151020 is available. You might prefer it.

First download the single big patch file of   Patch 17530796 and the small file of  Patch 16569379 (you need 16569379 only if you didn't install it with 11.1.1.7.1) as described in OBIEE BUNDLE PATCH 11.1.1.7.131017 AKA 11.1.1.7.2 or 11.1.1.7.3 is available.

Don't know why, but I had trouble downloading the WIN64 patch with Firefox (all 4 time failed), while Chrome did the job well.
Unzip the patches. You should have 2 directories named by the patch number.
Now in the directory 17530796, you have 8 zip files and a useful readme.htm. You are advised by the readme to move the 17530796 directory to  prod_mwhome\Oracle_BI1. Unzip all 8 zip files. At the moment you should have 8 directories under prod_mwhome\Oracle_BI1\17530796.

PLEASE read carefully section 3.1 if you are upgrading from 11.1.1.6.X.

In section 3.2 we are advised to check conflicts. I promise to do it later, after I set the path and Oracle_Home.

Next we are advised to do is to back up the Oracle BI system, including the following:
  •     The <Oracle BI Home>\bifoundation\server directory.
  •     The <Oracle Instance>\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository directory.
  •     The <Oracle BI Home>\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml file, if you have modified it.
There is a tip: The location of the Oracle BI Home directory and the Oracle Instance directory depend on where Oracle BI was originally installed, and on the platform. For example:
        On UNIX, the Oracle BI Home directory might be prod_mwhome/Oracle_BI1
        On Windows, the Oracle BI Home directory might be c:\prod_mwhome\Oracle_BI1
In my case it's D:\or\MWHOME\Oracle_BI1\bifoundation\server and D:\or\MWHOME\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository.
I prefer to backup D:\or\MWHOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog as well.

In point 3 you are advised to stop the BI System and told how to do it, step by step. It's all very nice but to me it looks simpler just to run "Stop BI Services" from the Start/All Programs/Oracle Business Intelligence menu. I guess wee see the full details due to Linux needs (and anyway, it's very educational).

Point 4 advises to clear cache: from prod_mwhome\Oracle_BI1\bifoundation\web\catalogmanager\configuration\ (in my case D:\or\MWHOME\Oracle_BI1\bifoundation\web\catalogmanager\configuration\) you should delete 2 files (if they exist) org.eclipse.osgi  &  org.eclipse.equinox.app.

As you remember we have directory 17530796 with 8 sub-directories in  prod_mwhome\Oracle_BI1 (in my case D:\or\MWHOME\Oracle_BI1).
make sure the extracted directory 16569379 is under prod_mwhome\Oracle_BI1 as well, only if you didn't install this patch before (you did, if you installed 11.1.1.7.1).

Open CMD prompt as Administrator on  prod_mwhome\Oracle_BI1. (Right Click with Shift pressed on the CMD or Right Click and CMD here as Administrator in the File Browser).

The readme states:

On UNIX: If you are using a command shell derived from the C shell, then set the environment variables by entering the following:
setenv ORACLE_HOME $PWD
setenv PATH $ORACLE_HOME/bin:$PATH
setenv JAVA_HOME $ORACLE_HOME/jdk
setenv PATH $JAVA_HOME/bin:$PATH
setenv PATH $ORACLE_HOME/OPatch:$PATH
 
On Windows: If the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, then set the environment variables by entering the following:
set ORACLE_HOME=C:\prod_mwhome\Oracle_BI1
set PATH=%ORACLE_HOME%\bin;%PATH%
set JAVA_HOME=%ORACLE_HOME%\jdk
set PATH=%JAVA_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\OPatch;%PATH%
 (in my case the first line is set ORACLE_HOME=D:\or\MWHOME\Oracle_BI1)
DON'T leave empty spaces in the set, such as set ORACLE_HOME=   D:\or\MWHOME\Oracle_BI1. 
Right Click does the paste action in CMD window.

 Now if you remember we need to conflict detection from section 3.2.
Assuming we are in directory 17530796 (cd 17530796), run:

cd 16913445
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463314
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17300417
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463395
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463376
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17300045
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\16997936
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463403
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

In all cases you should see:
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
 In point 10 we have 2 options: Run Once all 8 patches or do each manually.
Since I don't enjoy tedious manual labor, I preferred the first option.

Be sure you are back to the basic  prod_mwhome\Oracle_BI1\17530796 directory (by running:  cd.. in CMD, if you follow me.)

Enter the following command: 
opatch napply –skip_duplicate



My system is 11.1.1.7.1 so I was asked twice "Do you want proceed?"

And was asked to be sure "the local system is ready for patching" (shut down).

My installation finished with warning:
From what I see in the log, it's all because of previous patches (11.1.1.7.1 ?) components that are replaced by newer ones.



In case you don't trust opatch or simply enjoy unnecessary work you can run each patch separately with opatch apply. Wait for the  "Opatch Succeeded" and repeat in the next directory. (Repeat the Conflict Resolution list, just with opatch apply, instead of  opatch prereq CheckConflictAgainstOHWithDetail -ph ./)
As I said twice before, only if you didn't install 16569379 before,  go to directory 16569379 and Run opatch apply (in both types of installation).


You are advised to check all patches were applied using opatch lsinventory.


The next part has some manual labor (I use the readme numbers starting with 14):

14. Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the prod_mwhome\Oracle_BI1\clients\bipublisher\repository\Tools directory to the prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Tools directory.
In my case, from D:\or\MWHOME\Oracle_BI1\clients\bipublisher\repository\Tools to D:\or\MWHOME\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Tools.
(Should I copy ExcelAnalyzer.exe as well?)

15. Copy the msmdacc64.dll file from the <Oracle BI Home>\clients\bipublisher\repository\Admin\DataSource directory to the prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Admin\DataSource directory.
There seems to be a problem here since the source does not exist. I don't know if it's a documentation bug or missing file. Had the same thing in 11.1.1.7.1.

16.  Remove the jsp_servlet subdirectory associated with Oracle BI Publisher (if it exists), as follows:

  A.  Go to the directory containing the jsp_servlet subdirectory (using a file manager application or the command line). If it exists, then the jsp_servlet subdirectory is located in one of the directories below the <Middleware Home>/<Domain Home>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1 directory.

    For example:
        On UNIX: If the Middleware Home directory is /prod_mwhome and the Domain Home directory is /user_projects/domains/bifoundation_domain, then go to the following directory:
        /prod_mwhome/user_projects/domains/bifoundation_domainservers/bi_server1/tmp/_WL_user/bipublisher_11.1.1
        On Windows: If the Middleware Home directory is C:\prod_mwhome and the Domain Home directory is \user_projects\domains\bifoundation_domain, then go to the following directory:
        C:\prod_mwhome\user_projects\domains\bifoundation_domainservers\bi_server1\tmp\_WL_user\bipublisher_11.1.1

B.  Look in each directory below <Middleware home>/<Domain home>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1, and remove any jsp_servlet subdirectory that you find.

  17. If you backed up mapViewerConfig.xml because it had been modified, then copy the backed-up file to its original location at <Oracle BI Home>\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\.

Now you should be able to start the server, but before you do, there is one more part not in the readme file.

 You might remember the post of Abhinav Agarwal  Smart View Version to use with OBIEE 11.1.1.7.1
You are advised there to download the new SmartView here. Both zip files seem to be the same. They contain both SmartView files (the 32 and 64 bit).

The readme there states:
"With the availability of Oracle Business Intelligence Enterprise Edition release 11.1.1.7.1, it will no longer be possible to make use of the default Oracle Smart View client installer which is available through the Oracle BI EE Home Page. For this release only, it will be necessary to access an updated version of the Oracle Smart View client installer version 11.1.2.3.000_16909989 (from My Oracle Support), or later.

This updated version can be used to replace the default Oracle Smart View installer in the default Oracle BI EE Home Page location

/<middleware>/Oracle_BI1/clients/epm/SmartView/SmartView.exe
/<middleware>/Oracle_BI1/clients/epm/SmartView/SmartView-x64.exe
2.    Make backup copies of smartview.exe and version.xml before deploying the replacement files.

3.    Download the Smart View zip file from My Oracle Support.

4.    Unzip the file.

5.    Copy smartview.exe and version.xml to the location of the Workspace installation, typically: C:\Oracle\Middleware\EPMSystem11R1\common\epmstatic\wspace\SmartView"

Well you don't have to go to support... you just downloaded the zip file.
Backup  <Oracle BI Home>\clients\epm\SmartView (In my caseD:\or\MWHOME\Oracle_BI1\clients\epm\SmartView),  extract the content of the Zip file to that directory. 

You might want to delete the patch installation files from <Oracle BI Home> and free the 2.5GB of disk space.

Now you can Start up the server. Bon Voyage.




For Oracle Business Intelligence Client Tools only: Having applied the Oracle BI EE Suite Bundle Patch 11.1.1.7.131017, you must also update each desktop installation of the Oracle Business Intelligence Client Tools (Oracle BI Administration Tool, Job Manager, and Catalog Manager) as follows:

Deinstall the Oracle Business Intelligence Client Tools from every computer where the client tools have been installed by following the instructions in Chapter 5 of Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.

Reinstall the Oracle Business Intelligence Client Tools on every computer where the client tools have been deinstalled by following the instructions in Chapter 5 of Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.



Section 5.1: Copying BICharts.swf to Custom Directories


The Oracle white paper "Customizing Oracle Business Intelligence Enterprise Edition 11g" describes how to customize Oracle BI Presentation Services by storing custom skins, styles, and messages in a custom directory.

If the Oracle BI system has been customized as described in the white paper and custom skins are stored in one or more custom directories, then follow these additional instructions to complete the Suite Bundle Patch installation:

1.Copy the BIChart.swf file from the <Oracle BI Home>\bifoundation\web\app\res\sk_blafp\dvt directory to each custom directory in the BI System, replacing the existing file of that name.

    For example, on Windows, you might copy the BIChart.swf into the following custom directory:

    c:\prod_mwhome\Oracle_BI1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\sk_mylookandfeel\dvt

 2. Stop and restart the Oracle BI Presentation Services system component

3. Clear the browser cache.




Section 5.2: Editing Settings in OracleBIJavahostComponent


For customers exporting data into Microsoft Excel: To improve the functionality of exporting data from analyses, dashboards, and other Oracle BI Presentation Catalog objects into Microsoft Excel, edit settings in OracleBIJavahostComponent by performing the following steps to complete the Suite Bundle Patch installation:

    1. Navigate to the /instances/instance1/config/OracleBIJavaHostComponent folder.

    2. Perform the following actions:

       a. In the config.xml file, configure the XMLP tag for large data as follows:

        <XMLP> <InputStreamLimitInKB>0</InputStreamLimitInKB>

        <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing></XMLP>

        b . In the xdo.cfg file, change the setting for xlsx-keep-values-in-same-column to True. (See note 1632002.1 at Oracle Support if you don't know what they are talking about).

    3. Restart the WebLogic Administration Server (and Managed Server and BI System).

Friday, October 25, 2013

OBIEE BUNDLE PATCH 11.1.1.7.131017 AKA 11.1.1.7.2 or 11.1.1.7.3 is available

Please note OBIEE Bundle Patch 11.1.1.7.151020 is available. You might prefer it.


OBIEE 11.1.1.7 second general bundle patch, 11.1.1.7.131017 is available in Patch 17530796:
The new naming convention is to use date based numbering. Why is patch 131017 released on  13-10-25? Don't ask me,I'm just a writer in an OBI blog.

The Patch is platform specific and is available for:
  • HP-UX Itanium
  • IBM AIX on POWER Systems (64-bit)
  • Linux x64
  • Linux x64-64
  • MS Windows (32-bit)
  • MS Windows (64-bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86-64 (64-bit)
You can read the readme file here.

Unlike 11.1.1.6 patches, this patchset is downloaded in a single big file+one bonus patch. So just for the record (since you don't need to download them separately):
Patch Abstract
16913445 Oracle Business Intelligence Installer (BIINST)
17463314 Oracle Business Intelligence Publisher (BIP)
17300417 Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
17463395 Oracle Business Intelligence Server (BISERVER)
17463376 Oracle Business Intelligence Presentation Services (BIPS)
17300045 Oracle Real-Time Decisions (RTD)
16997936 Oracle Business Intelligence ADF Components (BIADFCOMPS)
17463403 Oracle Business Intelligence Platform Client Installers and MapViewer

As usual there is a bonus patch: Patch 16569379 - Dynamic Monitoring Service patch. It is platform dependent. If you installed it with 11.1.1.7.1, that's enough. It's the same.

New Features

  • Support for Microsoft Internet Explorer 10
  • Solution for Chrome 30 problem
  • Support for Improved Exporting Functionality into Microsoft Excel
  • Support for Oracle BI Mobile App Designer 
    • Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 integrates support for Oracle BI Mobile App Designer into Oracle BI Presentation Services. The Home page displays a new Create Mobile App option and a link to the Mobile Apps Library; the New menu now also includes a Mobile App option. Note that to use these new options, you must also install the Oracle BI Mobile App Designer. Oracle BI Mobile App Designer is available in a separate patch (17220944) available from My Oracle Support. Apply the Mobile App Designer patch after installing Oracle BI EE Suite Bundle Patch 11.1.1.7.131017. Note that if you have previously installed Oracle BI Mobile App Designer on the BI system, then you do not have to re-apply Mobile App Designer patch (17220944). However, you will have to make a configuration change to re-enable the new Mobile App options.See the Oracle BI Mobile App Designer Installation Notes for more information: http://www.oracle.com/technetwork/middleware/bi-foundation/bi-foundation/installation-guide-1989222.pdf

In the ReadMe here there are special instructions for upgrading from 11.1.1.6.X to 11.1.1.7.131017 at  "Section 3.1: For Customers Moving From 11.1.1.6.x to 11.1.1.7.131017". DON'T upgrade before you read and understand it.
Please read Section 4: Installation Instructions, before any patch installation.



Bugs fixes 

BI Publisher
 
Bugs fixed in this patch:

16310873: CELL PADDING CALCULATIONS FOR PDF, RTF AND HTML OUTPUTS ARE NOT THE SAME

16478234: "KEEP-WITH-NEXT.WITHIN-PAGE"-ATTRIBUTE SET TO "ALWAYS"UNWANTED PAGE BREAK IN PDF

16478894: LOCAL SUPER USER LOGIN FAILS

16532915: REQUIRE CONFIGURATION OPTION TO CREATE PDF FILES WITH OR WITHOUT EXTGSTATE

16724466: BIPUBLISHER REPORTS "PROCESSING CLOCK","CANCEL BUTTON" AND "NO DATA FOUND" MSG

16777005: IMPLEMENT A SETTING TO LIMIT MEMORY USAGE - MEMORY GUARD

16851866: ADD MORE CONTENT OR DATA FIELDS IN BIP AUDITING AND MONITORING

16858593: ADD CHECKBOX TO CONTROL "ADDPARTEXTINTRANSFER" PROPERTY IN SFTP/FTP CONFIG

16860347: SCHEDULED PROCESSES ARE NOT RUNNING CORRECTLY

16864706: ADDING EVENT LOGGING TO HELP DIAGNOSIS

16870216: LABEL LANGUAGE NOT IN ENGLISH BY DEFAULT WHILE RUNNING JSPX

17012856: ER: ENHANCE DATAMODEL PROCESSING TO WRITE DIAGNOSTIC DETAILS AND LIMIT XML SIZE

17012910: ER: DERIVE SYSTEM TEMP DIRECTORY FROM SERVER PROPERTY

17044333: NEED TO REDUCE DEFAULT REPORT THRESHOLD AND DB FETCH SIZE TO MINIMIZE OOM IN FA

17062414: A REDUNDANT TEMP FILE CREATION OCCURS DURING REPORT GENERATION BY SCHEDULER

17322161: TRACKING BUG FOR DELIVERING BIP CHANGES FOR DOWNLOAD EXCEL ISSUES INTO BUNDLE



 BISERVER

Bugs fixed in this patch: 

 
13861292: MSSAS DATE FILTERING WITH TIME FUNCTIONS DOES NOT WORK WITH BUG 12578133 FIX

14281720: OBIEE MSSAS DOES NOT HANDLE UNCONFORMED DIMENSIONS CORRECTLY

14578828: MDX FILTERS NOT PASSED DOWN FOR DERIVED COLUMNS

15936733: PUSH DOWN SORT WITH ROWNUMBER OFFSET LIMIT INCORRECTLY PUSH NON-COMPATIBLE SORTS

16222516: COMPILATION TIME FOR A SPECIFIC REPORT TAKES TOO LONG

16281981: BI SERVER CRASH

16326283: DYNAMIC REPOSITORY VARIABLES NOT BEING READ FROM CSV FILE

16345484: SIMPLIFY CONSTANT EXPRESSIONS IN LOGICAL SQL

16365896: ODBC ERROR IN CONDITIONAL FORMATTED REPORT

16390642: ADD SUPPORT FOR BEGINS WITH AND LIKE FILTER ON ANALYSIS SERVICE

16513391: IMPORT METADATA STOPS ON ERROR

16538633: SCALAR METRICS IN CROSS SUBJECT AREA QUERIES TREATED AS DIMS

16563394: ORDER BY ITEMS MUST APPEAR IN THE SELECT LIST IF SELECT DISTINCT IS SPECIFIED

16717750: NO DRILLDOWN BUTTON WHEN GENERATING QUERIES FOR A MULTI-HIERARCHY OLAP DIMENSION

16727989: DASHBOARD REPORT RETURNED - ERROR CODES: OPR4ONWY:U9IM8TAC:OI2DL65P

16840835: NQSSERVER CRASHES FREQUENTLY DURING QUERY

16866618: BI SERVER CRASHING

16881007: CAST FUNCTION IN ANSWERS HAS PERFORMANCE PROBLEM

16906637: HIERARCHY ATTRIBUTES NOT WORKING IN GL BALANCES SA

17017686: USE INTEGER FOR LOGLEVEL SESSION VARIABLE IN CONNECT STRING DURING CONNECTING

17083234: ORA-24550: BI SERVER CRASHING FREQUENTLY

17242119: DATA FILTERS FAIL TO TRIGGER FOR CUST APP ROLE WITH PROXY FUNCTIONALITY ACT AS

17301949: MODIFY ADF_BUNDLE FORMULA TO USE A NEW DELIMITER BETWEEN BUNDLE AND KEY

17302034: BI BROKER ENHANCEMENT FOR LOOKUP FUNCTION IN CRM FIXED CHOICE LISTS

17336589: FA CRM CUSTOM SUBJECT AREA SHOW ERROR WHILE PUBLISHING

17348272: ADD ADF_BUNDLE VARIABLE SUPPORT IN PRESENTATION COLUMNS


Presentation Services
Bugs Fixed By This Patch

9783769: CANNOT ADD CONDITIONS FOR SELECTED COLUMNS IN COLUMN SELECTOR VIEW

12320264: MULTI-SELECT PROMPT AND CLIENTSESSIONEXPIREMINUTES SETTINGS THROW ERROR

14246348: SORTING NOT WORKING ON MEASURE COL WITH A COLUMN IN THE PIVOT TABLE PROMPTS

14278050: UNABLE TO APPLY CONDITIONAL FORMAT FOR COLUMN HAVING CASE STMT IN GRAPH PIVOTED

14527683: BUBBLE CHART WITH CONDITIONAL FORMATTING ON CASE STATEMENTS SHOWS ONLY ONE COLOR

14635134: CANNOT BUILD FILTERS ON DATE COLUMNS IN BI COMPOSER

14695698: METADATA DICTIONARY SHOWS INCORRECT MAPPING WHEN NAMES CLASH DUE TO TRUNCATION

14832580: SEGMENT TREE PERFORMANCE WHEN SAMPLING REMAINDER BRANCH

14848445: ENCOUNTERING "[NQSERROR: 37005] TRANSACTIONAL UPDATE FAILED." IN ONLINE MODE

15863409: PROMPTS FROM CONDITIONAL SECTION DO NOT APPEAR IN PROMPT BAR

15867064: SELECTION RULES: SUBJECT AREAS NOT SHOWN FOR ONE TARGET LEVEL

15917103: DISABLED LTS DURING AFTER UPGRADE FROM OBIEE 10 TO OBIEE 11 CANNOT BE ENABLED

15989894: UNABLE TO ADD BIN IN COMBINED REQUESTS

16068402: GRAPHS NOT SHOWN ON IE WHEN OBIEE IS BEHIND A REVERSE PROXY

16090809: NESTED FOLDERS ARE FLATTENED WHEN VIEWED THROUGH ANALYTICS - >NEW->SEGMENT

16270623: ASSERTION ERROR IN FILE PREKNOWNMETADATA WHEN ADVANCED SQL SETTING EXISTS

16346261: SEARCHING ICON (CLOCK ICON) IS DISPLAYED IN CENTER

16353193: OBIEE EDIT FILTER DOES NOT SHOW DROP DOWN ON EDIT SEGMENT

16412609: CUSTOM COLS ARE SHOWN AS EXTENSION ATTRIBUTES IN FCRM ENVIRONMENT

16436422: COMPARERPD FAILS WHEN PROMPTING PWD FROM USER FOR BOTH THE RPD

16465412: JH NULL POINTER EXCEPTION WHEN HIDING MEASURE LABELS ON PIVOT CHART

16480156: HIERARCHY WITH SELCTION STEPS AND WITH OVERRIDE PROMPTS CAUSES LOGOUT

16498595: INCORRECT RESULTS DURING THE NAVIGATION AFTER SELECTING A PIVOT TABLE PROMPT

16516420: SAWSERVER CRASH

16558154: GRAPHING ENGINE NOT RESPONDING FOR FEW REPORTS AFTER UPGRADE

16599775: REPORT RUNS AFTER THE CONDITION OF SECTION ON WHICH IT IS EMBEDDED FAILS

16666982: PATCH FILE CONNECTION SCRIPTS ARE NOT ADDED TO CONNECTION POOL AFTER PATCH RPD

16746208: EMPTY ROW AND COLUMNS IN PIVOT TABLES IS CAUSING INCORRECT FORMATTING

16746990: REPORTS FAIL WHEN PRESENTATION VARIABLE IS USED IN COLUMN FORMULA

16800986: GREEN BAR STYLING SHOWS DOUBLE WHITE ROWS

16819138: FORMAT SECTION ON DASHBOARD PAGE DOES NOT WORK CORRECTLY

16843663: CANNOT RECREATE THE SAME CURRENT RPD FROM BISERVERXMLEXEC.EXE

16848280: DASHBOARD PROMPT BASED ON VARIABLE DOES NOT FILTER BIP REPORT LINK ON DASHBOARD

16855967: BREADCRUMB DOES NOT WORK FOR ACTION LINKS

16914895: MERGE RESULTS IN CONSISTENCY CHECK ERROR WHEN PHYSICAL KEY ADDED TO ADF TABLES

16925168: BAD XML INSTANCE! ERROR WHEN SAVING DASHBOARD CUSTOMIZATION

16932974: PROPERTIES OF A THE CUBE TABLE "ALIAS" IS GRAYED OUT

16933719: IMAGE IN ANALYSIS HEADER IS FAILING TO DOWNLOAD TO PDF, EXCEL, POWERPOINT

16934246: REPOSITORY MERGE DELETING SAMPLE SALES EXTERNAL NAME SETS ENTRIES

16968753: INTERNAL ASSERTION WHILE DUPLICATING OBJECTS IN RPD IN MUD ENV

16978767: COPY/PASTE ERROR WHEN CRITERIA WITH A BINNED EXPRESSION IS IN A COMBINED REQUEST

16980396: ADMINTOOL CRASHES WHEN COMPARING TWO RPD FILES

16984731: RPD UPLOAD RESETS VERSION NUMBERS IF /TMP IS WIPED

17030702: EXTEND DELIVERS OUTPUT TYPES FOR DASHBOARD PAGES FOR EXCEL

17039849: NAVIGATION IN IE DOES NOT WORK WITH A FOOTER IN DASHBOARD PRINT OPTIONS

17056251: FILTER VIEW SOMETIMES NOT REFRESHED WHEN PROMPT SELECTION CHANGES

17071629: PORTALPATH SESSION VARIABLE IS INEFFECTIVE

17192703: GO URL SHOWS ENTIRE PORTAL CONTENT IN 11.1.1.7.1 REPORT

17239172: MANAGE PRIVILEGES SHOWS UNKNOWN ROLES WITH GUID VALIDATION DISABLED.

17239730: SECTION CONDITION NOT BEING RE-EVALUATED WITH PROMPT ON DIFFERENT PAGE

17246512: APPLIED PATCH OF 14296026 AND VIEW DISPLAY ERROR HAPPENED

17250940: CLICKING BACK TO ANAYTICS BUTTON TAKES TO DIFFERENT SET OF RECORDS IN 11G

17307744: FORMULA WITH VARIABLE NOT RESOLVED IF USED IN CONDITIONAL ACTION

17372558: TRACKING BUG FOR DELIVERING PS CHANGES FOR DOWNLOAD EXCEL ISSUES INTO BUNDLE

Includes the following fixes:

    17192703: OBIEE PORTAL CONTENT IS SHOWING IN GO URL REPORT IN 11.1.1.7.1

    17071629: PORTALPATH SESSION VARIABLE IS INEFFECTIVE

    16783677: EXPORT TO EXCEL2K7: BROWSER NOTIFICATION IS NOT CONSISTENT WHILE EXPORTING EXCEL

    16576787: EXCEL EXPORT: CELLS SHIFTING IF THE DIMENSION/S ARE USED IN PIVOT SECTIONS

    14126454: SOME CELLS GOT MERGED AFTER EXPORTING REPORT FROM 11G TO EXCEL

17422014: INTERNAL ASSERTION WHILE PERFORMING CHECK IN OPERATION IN RPD - MUD ENV

 


Ignore the readme.txt files in the Oracle BI EE Suite Bundle Patch component patches. The readme.html file in patch 17530796 contains all the installation instructions and list of bugs fixed.

P.S.

In case you wonder why I describe it as 11.1.1.7.2 or 11.1.1.7.3... This is the second general Bundle Patch for 11.1.1.7. But a month ago there was a 11.1.1.7.2 bundle for FA customers only. So I'm not sure if that counts.

PATCH 17606196 for OBIEE 11.1.1.7.1 - IE10 & Chrome 30 solution

If you are on OBIEE 11.1.1.1.7.0 / 11.1.1.7.1, you might be interested in patch 17606196. It should be installed on top of OBIEE 11.1.1.7.1 and covers Chrome 30 & IE 10 problems:

16068402:GRAPHS NOT SHOWN ON IE WHEN OBIEE IS BEHIND A REVERSE PROXY
16667503:QA: PROMPTS: RESET TO LAST APPLIED VALUE IS NOT WORKING
16371801:QA: IE10: GAUGES VIEW OVERLAPPED WITH OTHER VIEWS
16455904:QA: IE10: SLIDER PROMPTS CANT SLIDE TO LOWEST LIMIT
16382296:QA: IE10: MAP VIEW SHOWS SERIES OF ERRORS
16402964:QA:IE10: NEW CONDITION THROWN ERROR"OBJECT DOESN'T SUPPORT PROPERTY OR METHOD'
16391455:QA:NEW AGENT PAGE IS NOT DISPLAYED IN IE10
16390205:QA: IE10: RESIZE COLUMN SELECTS ALL TEXT IN TABLE/PIVOT VIEW
16389347:QA:UNABLE TO OPEN OR CREATE A KPI WATCHLIST USING IE10 BROWSER
16389210:QA: CAN NOT CREATE OR OPEN A SCORECARD WITH IE10 BROWSER
16382198:QA: IE10: ANALYSIS PROMPT FOR HIERARCHY: VALUE TEXTBOX NOT FULL SIZE BUT WORK OK
16371672:QA: IE10: FREEZE HEADER: LONG SCROLL SHOWS TRIMBUFFER ERROR
16371553:QA: IE10: SIGN IN PANEL IS NOT AT CENTER POSITION
15935506:IE10 NOT ABLE TO CREATE OR EDIT AN ANALYSIS IN ANSWERS

 
The first bug, 16068402, has a specific patch 16068402, but I didn't see patch 17606196, replacing it formally.

Wednesday, October 23, 2013

OBIEE - Grouping measures and counting group members

Few days ago I was asked for something like this: "We have a table of Revenue for each Product. How can the end user assign the values of Revenue into groups he invents and then count the number of Products in each group." 
It seems easy but, try it in SQL. It's not trivial at all. 

For some reason I had a blackout. Since I reinvent the answer to similar questions for the third time at least; It's time to write about it here. The process actually takes about 3 minutes, but it will be a bit long post, since it's a very detailed explanation.

We start with the basic analysis: Product and the Revenue (twice). One Revenue column to work with and the other for QA.
 Next edit one of the Revenues formula and select "Bins". Here we can easily create groups, we could otherwise create by a big manual case statement.
I created a bin named "1. Under 100K" with condition of Revenue<100000.
It's important to uncheck the "Treat result as numeric value ..." since the result is textual.

otherwise you will get the following error:
I created few bins and then created the last one by marking "create a bin of all other values".
Since I want to use the result of the bins as attribute later (count the number of Products in each bin), I'll check the "Treat as an attribute column",at the bottom of the function screen.
I named the column "Bins".
In "results"Tab, we have a result table, I'll delete it and create a Pivot table.
Now it's time to edit the pivot:
I will switch the Products column and the Bins column in the Pivot Table:
 
First I'll move the Bins column to the left axis of the pivot:
Next move the Products column to the Measures section of the Pivot:
Of course the Product Names can't be aggregated and are left blank in the Result.
So it's time to click the Products column and select "Aggregation Rule" and "Count":
Now it's perfect.
If you prefer you can exclude the regular Revenue column or add a Chart:
This is the result:

Monday, October 21, 2013

OBIEE - Sorting the Pivot by Totals

I was requested to sort  a pivot table by a total column.
For example:

In my 11.1.1.7 I can easily sort on any of the year Revenue but no on the total.
My initial reaction was to create a calculation in criteria, something like sum("Base Facts"."Revenue" by "Products"."Product Type") and put it in the left axis. 
But I preferred a better solution.

I created a new calculated item:
Based on Time.Per name Year (the one I have in the top axis)

The calculation,  I named Total Revenue, is sum(*). With "custom formula" in function.

Now I can get rid of the original Total:
And have this:
I can sort by 2008, 2009, 2010, but unfortunately I still can't sort by Total Revenue!!??

To achieve that switch the measure location in the pivot.
Now I can sort the relevant Revenue:

And rearrange the top Axis if I desire that:

Rearrange using the Layout (see bellow) and not by direct dragging of the axis. For some reason, this option breaks the order by...

 

Sunday, October 20, 2013

OBIEE 11g Chrome 30+ problem, follow up

Lets start with the good news, I installed the patch 16068402 on my local Win7, OBIEE 11.1.1.7.1 and the chrome issue on my Chrome 30.0.1599.101 was solved.
I will have to double check with my customers or patiently wait for the next Patch bundle.

But I write this post not only to brag about my computer.

Since the above patch is relevant for 11.1.1.7.1 and the latest 11.1.1.6 bundle patches solve the issue there, I still have few 11.1.1.5.X customers that haven't upgraded yet (soon I hope).
One of them tried the advice of Nosferatu84 at http://productforums.google.com/forum/#!topic/chrome/X0uMqd7sE6E and says its working. (Didn't try it myself, but similar logic is described at Oracle support site). Please note it's absolutely not supported procedure.

So to summarize Nosferatu84 (I hope it's OK I copied the answer here):
It looks like Oracle found a solution, they haven't post it in the official blog but I tested in our DEV environment and it works.
At line 810 in Ajax.js there is the functioning code that allows Firefox to work: 
if (saw.userAgent.is_nav && d && this.submitMethod == "post") { 
e.setRequestHeader("Content-Type", "application/x-www-form-urlencoded") } 

Proposed fix, add: 
if (saw.userAgent.is_webkit && d && this.submitMethod == "post") { 
e.setRequestHeader("Content-Type", "application/xml") }

You would need to redeploy the analytics.ear

When Nosferatu84 was asked how to redeploy the Analytics.ear, the answer was:
 The process is a little bit surgical...
(Please change the paths to your server conditions)
You need to modify the sources of the analytics.ear, you can find this file on:
.../Oracle_BI1/bifoundation/jee
Copy the ear file to some temp folder, and as usual make a backup of the original analytics.ear
- Uncompress the contents of analytics.ear
- Run the command: C:\tmp1> d:\Java\jdk1.6.0_29\bin\jar xvf analytics.ear
- Copy the analytics.war into another tmp folder
- Uncompress the .war file C:\tmp2> d:\Java\jdk1.6.0_29\bin\jar xvf analytics.war
- Now you will have the source of analytics, find in  c:\tmp2\res\b_mozilla\common
the file ajax.js, modify this file with the instructions on my first post.
- Now we need to compress everything back how it was before
- delete the current analytics.war from the folder tmp2
- Run C:\tmp2>d:\Java\jdk1.6.0_29\bin\jar cvf analytics.war *
- Copy the new generated analytics.war into the tmp1 folder
- In tmp1 folder remove delete the old analytics.ear
- Run C:\tmp2>d:\Java\jdk1.6.0_29\bin\jar cvf analytics.ear *
Almost done....
Copy the new generated .ear file again to .../Oracle_BI1\bifoundation\jee
In console delete the application and Redeploy... (or better replace the ear file and restart)

Sunday, October 13, 2013

OBIEE 11g Chrome 30+ problem, solution

Many of you probably noticed since last week, OBIEE mostly stopped working on Chrome, since it was automatically upgraded for most of us to version 30+ (30.0.1599.69 (Official Build 226629), to be 100% correct).
Oracle team at support solved the issue within few days. For 11.1.1.6 and 11.1.1.7 see:Update to OBIEE Chrome 30 issue.

Due to it's current support state (see Premier Support Product Life Cycle for OBIEE 11.1.1.5 ends March 2013, for example), I'm not aware of similar patch for 11.1.1.5.