Friday, June 28, 2013

OBIEE 11.1.1.6.11 is available for OBIEE and Exalytics + bug fixed

The patch 11.1.1.6.11 is available from Oracle support site (support.oracle.com). The first part of the patch is Patch 16747681

It's the most updated / latest version (actually patch bundle) of OBIEE, installed on top of the basic 11.1.1.6.0 version.

It can be installed on OBIEE 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1, 11.1.1.6.4,11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7, 11.1.1.6.8, 11.1.1.6.9 and  11.1.1.6.10.

As usual, the real patch has 7+1 parts. The installation steps for the first 7 are similar. I recommend reading the first readme – patch 16747681 readme file. 

Since 11.1.1.7 is available, I suspect we will not see many more 11.1.1.6.X patches.

The Oracle Business Intelligence 11.1.1.6.11 patchset comprises a number of patches:
Patch Abstract
16747681 Patch 11.1.1.6.11 (1 of 7) Oracle Business Intelligence Installer
16747684 Patch 11.1.1.6.11 (2 of 7) Oracle Real Time Decisions
16747692 Patch 11.1.1.6.11 (3 of 7) Oracle Business Intelligence Publisher
16747699 Patch 11.1.1.6.11 (4 of 7) Oracle Business Intelligence ADF Components
16747703 Patch 11.1.1.6.11 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
PLEASE note, this is platform specific patch (Windows 32, 64, Linux X86, X86-64, IBM AIX Power 64, Solaris SPARC 64, Solaris X86-64, HP-UX Itanium)
16717325 Patch 11.1.1.6.11 (6 of 7) Oracle Business Intelligence
PLEASE note, this is platform specific patch (Windows32,  64, Linux X86-64, IBM AIX Power 64, Solaris SPARC 64, Solaris X86-64, HP-UX Itanium) 
16747708 Patch 11.1.1.6.11 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer

Additionally there is the patch number 8, it is named JDeveloper Patch, but it is for OBIEE as well. It's the same patch you used if you installed 11.1.1.6.2 BP1 or later. So if you already installed it, I see no reason to do it again.
Patch 13952743JDeveloper patch -   - RUP3 MLR4.3  CUMULATIVE: BASED ON JDEVADF_11.1.1.6.2_GENERIC_120329.1447.6268.1 (last release 11.1.1.6.2)
The installation steps are same as 11.1.1.6.2 BP1 as we described here.
Please note, that readme tell you to do the following backups:
  • The ORACLE_HOME\bifoundation\server directory
  • The ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
  • The ORACLE_BI_HOME\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml, if you have modified it. This last bullet is relevant to those who configured the OBIEE Maps (described, in Hebrew here).
HP Itanium users, please note: HP Itanium platform must first download and apply patch 14016752 from My Oracle Support.

 I'm not aware of any new features in 11.1.1.6.11.

Bugs Fixed By This Patch

Publisher

13496612: EXPORT TRELLIS TO EXCEL 2007 DOES NOT RENDERED THE IMAGE IN THE CORRECT PLACE
14733191: DATA FIELDS THAT CONTAIN A BACKSLASH '\' IN A PARAMETER CAUSE DATA MODEL TO FAIL
15886427: SCHEDULED JOBS NOT RUNNING AS SCHEDULED IN 11.1.1.6.5
15986061: SECTION 508 MENU SELECTION NOT WORKING IN IE8
16310873: CELL PADDING CALCULATIONS FOR PDF, RTF AND HTML OUTPUTS ARE NOT THE SAME
16384964: CONDITIONAL FORMATS ARE NOT DEEPLY COPIED FOR EACH SHEET IN EXCEL TEMPLATE
16440558: JVM OUT OF MEMORY WHILE ADDING IMAGE TO BIP REPORT
16453917: INCONSISTENT ALIGNMENT IN INTERACTIVE REPORTS WITH PIVOT TABLES USING IE9.0
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


EPM

13974353: CONNECTION STRING USED TO ACCESS LEASING TABLE IS INCORRECT


OBIEE

13860440: REPORT SHOWS AN ERROR WHEN A FILTER CONTAINS [ ] AGAINST ESSBASE
14080494: DELIVERS NOT ABLE TO SEND CONTENT USING DX-MAIL AS SMTP SERVER
14246348: SORTING NOT WORKING ON MEASURE COL WITH A COLUMN IN THE PIVOT TABLE PROMPTS
14301662: EXPORTED EXCEL LINES ARE MISSING
14406555: ACTION LINK INTERACTION FAILS WITH GETLEVELINFO ERROR
14482447: DRILL DOWN IS NOT CORRECT INTO BUBBLE GRAPH WHEN DIMENSION USED FOR VARY COLOR
14527683: BUBBLE CHART WITH CONDITIONAL FORMATTING ON CASE STATEMENTS SHOWS ONLY ONE COLOR
14571347: THE MASTER DETAIL ACTIVITY IS NOT PERFORMING CORRECTLY ON PARETO GRAPH
14641758: 10G TO 11G UPGRADE: PARSER LOGIC DOES NOT ACCEPT NEGATIVE NUMBERS IN MEMBER NAME
14771782: IBOTS CALLING JAVA PROGRAM IN CLUSTER STICK AT STATUS 'RUNNING'
14832580: SEGMENT TREE PERFORMANCE WHEN SAMPLING REMAINDER BRANCH
14839368: RESTORE SUPPORT FOR VALUE SUPPRESSION IN DOWNLOADS TO EXCEL 2003
15863409: PROMPTS FROM CONDITIONAL SECTION DO NOT APPEAR IN PROMPT BAR.
15867064: SELECTION RULES: SUBJECT AREAS NOT SHOWN FOR ONE TARGET LEVEL
16081724: SPECIFICATIONS FOR THE COLOR OF GRIDLINES ARE NOT APPLIED CORRECTLY
16088305: COLUMN DATA MISSING WHEN VIEW IN BI OFFICE USING EXCEL
16222516: COMPILATION TIME FOR A SPECIFIC REPORT TAKES TOO LONG
16270623 ASSERTION ERROR IN FILE PREKNOWNMETADATA WHEN ADVANCED SQL SETTING EXISTS
16281981: BI SERVER CRASH
16285224: SAVED CUSTOMIZATIONS ARE IGNORED, NOT APPLIED, WHEN VIA IBOT / AGENT
16321247: INVALID SCHEMA VALIDATION FOR CALCULATED ITEM WITH CONCAT FUNCTION
16323282: SAWSERVER GENERATING CORE DUMP SAW::CONDITIONALREQUESTEVALUATOR
16326283: DYNAMIC REPOSITORY VARIABLES NOT BEING READ FROM CSV FILE UPGRADE FROM 10G
16342203: ACTION LINK TO DASHBOARD PAGE SECTION THE CONDITIONS EVALUATE WRONG
16353193: OBIEE EDIT FILTER DOES NOT SHOW DROP DOWN ON EDIT SEGMENT
16365896: ODBC ERROR IN CONDITIONAL FORMATTED REPORT AFTER UPGRADE FROM 10G.
16423872: AFTER APPLY 11.1.1.6.6G JAVAHOST STARTS CRASHING.
16447124: RAGGED HIERARCHY IN ORACLE OLAP DOES NOT WORK IN ANSWERS ANALYSIS
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 AFTER MERGE PATCH 16300022 WAS APPLIED
16558154: OBIEE 6.9: GRAPHING ENGINE NOT RESPONDING FOR FEW REPORTS AFTER UPGRADE
16563394: ORDER BY ITEMS MUST APPEAR IN THE SELECT LIST IF SELECT DISTINCT IS SPECIFIED
16606433: INVALID COLUMN IN SELECT LIST NOT CONTAINED IN EITHER AGGREGATE FN OR GRP BY
16624321: INFINITE LOOP IN PS WHEN IBOT DELIVERED CONTENT CONTAINS ILLFORMED LINE ENDINGS
16680403: KEEP ONLY RELATED FEATURE WITH REPORT BASED ON HIERARCHY COLUMNS CRASHES BIPS
16694816: PRESENTATION SERVER CRASH DURING QUERYCACHE CLEANUP OF OLD WAITING CURSORS
16779536: LABELS ARE MISSING ON SOME DASHBOARD PROMPT COLUMNS AFTER APPLYING 6.10


Known Bugs With This Patch

14228519: ADMINTOOL CLIENT MISSING ALL FILES UNDER EXTENDER DIRECTORY IN CLIENT INSTALLER
14244844: NAVIGATE TO URL ACTIONS BASED ON ENCODED URLS MAY RESULT IN DOUBLE ENCODING
14743304: FIX FOR BUG 14170374 REQUIRES ADDITIONAL CHANGE TO OPMN.XML
15854192: ERROR MESSAGE RETRIEVED WHEN TRYING TO CREATE AGENT WITH EMAILS AS RECIPIENTS
16531368: DOCUMENT THE ROW SPANNING ISSUE IN RELEASE 11.1.1.6.10
16687063: FIX FOR BUG 15911537 REQUIRES ADDITIONAL SETTING TO THE INSTANCECONFIG.XML FILE
 

OBIEE 11.1.1.7.1 Bundle Patch is available

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

OBIEE 11.1.1.7 first bundle patch, 11.1.1.7.1 is available in Patch 16556157: OBIEE BUNDLE PATCH 11.1.1.7.1.
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)

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
16453010 Patch 11.1.1.7.1 (1 of 6) Oracle Business Intelligence Installer (BIINST)
16849017 Patch 11.1.1.7.1 (2 of 6) Oracle Business Intelligence Publisher (BIP)
16916026 Patch 11.1.1.7.1 (3 of 6) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
16850553 Patch 11.1.1.7.1 (4 of 6) Oracle Business Intelligence Server (BIS)
16842070 Patch 11.1.1.7.1 (5 of 6) Oracle Business Intelligence Presentation Services (BIPS)
16869578 Patch 11.1.1.7.1 (6 of 6) 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.


PLEASE read the 16453010 Readme file carefully before applying this patch or upgrading from 11.1.1.6.9 - 11.1.1.6.11 it's HERE.

There is a detailed installation guide at Installing OBIEE patch set 11.1.1.7.1 on Windows Including reference to the post of Abhinav Agarwal about Smart View Version to use with OBIEE 11.1.1.7.1 and the needed  steps, as a result.

New Features

Enforce Limits Per Logical SQL Query
New Feature: Support for TimesTen Parallel Insert


Bugs fixes (available in Oracle note 1566140.1 HERE)

  Known Bugs With This Patch

9783769: CANNOT ADD CONDITIONS FOR SELECTED COLUMNS IN COLUMN SELECTOR VIEW
9924321: MOUSE POINTER CHANGES TO A HAND POINTER WHEN NO LINK EXISTS
12320264: MULTI-SELECT PROMPT AND CLIENTSESSIONEXPIREMINUTES SETTINGS THROW ERROR
14228519: ADMINTOOL CLIENT MISSING ALL FILES UNDER EXTENDER DIRECTORY IN CLIENT INSTALLER
14635134: CANNOT BUILD FILTERS ON DATE COLUMNS IN BI COMPOSER
14695698: METADATA DICTIONARY SHOWS INCORRECT MAPPING WHEN NAMES CLASH DUE TO TRUNCATION
15905237: CUSTOM COLUMN HEADING DOES NOT REFLECT IN THE FILTERS VIEW
15917103: DISABLED LTS DURING AFTER UPGRADE FROM OBIEE 10 TO OBIEE 11 CANNOT BE ENABLED
16068402: GRAPHS NOT SHOWN ON IE WHEN OBIEE IS BEHIND A REVERSE PROXY
16090809: NESTED FOLDERS ARE FLATTENED WHEN VIEWED THROUGH ANALYTICS->NEW->SEGMENT
16941321: SMART VIEW CLIENT INSTALLER COMPATIBILITY


Presentation Services

Bugs Fixed By This Patch

13404311: "NOTIN" / "NOTEQUAL" CONDITIONAL FORMATTING IS NOT WORKING FOR GRAPHS
13533513: GRAPH LEGEND LABEL CONCATENATION ISSUE
13824436: LAUNCH MOBILE APP FROM LINK INTO SPECIFIC DASHBOARD OR REPORT
13824444: CALL OTHER APPS FROM WITHIN BI MOBILE APP.
14043444: GRAPH DYNAMIC SCALE MARKER NOT SCALING CORRECTLY
14251555: ACCESSING SPECIFIC CONTENT ON OBI MOBILE APPS WITHOUT DESKTOP RESTRICTIONS
14482447: DRILL DOWN IS NOT CORRECT INTO BUBBLE GRAPH WHEN DIMENSION USED FOR VARY COLOR
14488588: ACTION LINK PASSING TOO MANY PARAMETERS
14509257: UNWANTED EXPANDATION OF BACKGROUND OF GAUGE CHART/BULB
14571347: THE MASTER DETAIL ACTIVITY IS NOT PERFORMING CORRECTLY ON PARETO GRAPH
14597361: UNABLE TO DELETE HEADER FROM NEWLY ADDED COMPOUND LAYOUT
14650457: SECTION CONDITION IS NOT RE-EVALUATED IN 11G AFTER DASHBOARD REFRESH
14701862: DRILL ON PIE CHART WITH HIERARCHY DOES NOT DISPLAY THE CORRECT CHART LABELS
14766020: A FILTER DIALOG CANNOT DISPLAYED WHEN USING SINGLE QUOTE FOR TIMESTAMP TYPE
14769682 - MEMORY LEAK IN OBIEE 11.1.1.6.4 WHEN EXPORTING LARGE REPORTS TO EXCEL
14796461: THE "=" CHARACTER IS NOT PASSED TO PRESENTATION VARIABLE FROM TEXT FIELD
14832439: BLOCKING ANALYSES BASED ON CRITERIA NOT WORKING ON RESULTS TAB
14832723: BLOCKING ANALYSES IS BROKEN AFTER SAVNG AND REOPENING THE ANALYSIS
14834396: OPENING THE ADMINISTRATION - MANAGE PRIVILEGE VIEW IS SLOW
15840909: CANNOT USE SET VARIABLE IN SQL RESULTS TAB FOR DEFAULT SELECTION IN PROMPT
15873335: UPGRADED ANALYSIS PROMPT DOES NOT WORK UNLESS REPORT IS MANUALLY SAVED
15879674: WHEN A VALUE WITH THE '&' SIGN IS CHOSEN, SCORECARD WATCHLIST RESULTS ARE NOT BE
15902956: CONDITIONAL DASHBOARD PROMPTS NOT WORKING. APPLY BUTTON IS NOT VISIBLE
15903315: VARIABLES IN HEADER OR FOOTER OF PDF EXPORT OF DASHBOARD NOT FORMATTED CORRECTLY
15911357: DISPLAY AS RUNNING SUM NOT SHOWING ZERO WHEN IT IS A NULL VALUE
15912205: ACTION LINKS WITHIN KPI NOT PASSING PARAMETERS LIKE REGULAR ACTIONS
15935614: OPTION TO SELECT A SUBSET OF DASHBOARDS THAT ARE DISPLAYED IN THE BROWSER
15961449: REQUEST VAR DEFAULT VALUE SET BY REPOSITORY VARIABLE DOES NOT WORK CORRECTLY
16081724: SPECIFICATIONS FOR THE COLOR OF GRIDLINES ARE NOT APPLIED CORRECTLY
16163313: EXPORT TO EXCEL WITH CUSTOM NUMBER FORMATS HAS ISSUES WITH PERCENTAGE
16195598: DOUBLE CLICK ON DIMENSION COLUMN RESULTING IN DUPLICATED COLUMNS ADDED TO VIEW
16321247: INVALID SCHEMA VALIDATION FOR CALCULATED ITEM WITH CONCAT FUNCTION
16387359: PRESENTATION SERVICES CRASHES WHILE NAVIGATING VIA ACTION LINKS
16401538: UPGRADE ISSUE WHEN NO COLUMNS IN COLUMN/MEASURE SECTION
16432997: PROMPT DEFAULT TO SESSION VARIABLE NOT SETTING PRESENTATION VARIABLES INITIALLY
16473120 - GRAND TOTAL ON PIVOT TABLE CAUSING QDR TO BE CREATED FOR EVERY CELL
16481343: IE 8 BROWSER IS TIMING OUT WHILE WAITING FOR EXCEL 2007 DOWNLOADS
16655063: DASHBOARD LINK DO NOT FOLLOW EXACT DESTINATION PAGE
16673838: QA:UNABLE TO OPEN AN EXCEL 2007+ FORMAT DELIVERED FORMAT IN MS EXCEL 2007
16674936: CANNOT MODIFY A UNION REPORT WITH A SECOND UNION ONCE IT IS CREATED
16727109: BETTER ERROR MESSAGE WHEN EXPORTING TO EXCEL FAILS
16757080: THE TEMP FILES UNDER USER/_TMP FOLDER ARE NOT GETTING CLEANED
16758001: DO NOT ALLOW MULTIPLE DOWNLOADS OF EXCEL 2007 FORMAT SIMULTANEOUSLY
16765598: "_TMP" FOLDER FROM USER FOLDER IS BEING EXPOSED IN UI
16788791: EXPORT 2 EXCEL2K7: INCONSISTENCY IN NUMBERS FORMAT IN EXCEL EXPORTS
16898561: HUGE TEMPORARY FILES ARE GENERATED IN TEMPORARY FOLDER

Known Bugs With This Patch

14244844: NAVIGATE TO URL ACTIONS BASED ON ENCODED URLS MAY RESULT IN DOUBLE ENCODING
15854192: ERROR MESSAGE RETRIEVED WHEN TRYING TO CREATE AGENT WITH EMAILS AS RECIPIENTS
16531399: DOCUMENT THE REMOVAL OF ACTION LINK IN EXCEL IN RELEASE 7.1
16723809: DOCUMENT THE ROW SPANNING ISSUE IN RELEASE 11.1.1.7.1
16918693: MT PERMISSION CHANGES DO NOT TAKE ACCOUNT OF NEW OBIPS PRIVS
16941537: CELL MERGE ISSUE IN EXCEL XLSX OUTPUT, FIXED BY NEW PROPERTY IN XDO.CFG

Publisher

Bugs Fixed By This Patch

12866751: SCHEDULESERVICE - DELIVERYSERVICE REQUIRES SPECIFIC ELEMENT FOR REPORT FILENAME
13720037: BISERVER QUERY FAILS IF AMPERSAND IS USED IN COLUMN NAME
13825454: USER ABLE TO LOGIN AFTER PASSWORD_GRACE_TIME EXPIRED
13990460: BIPREGION IS NOT WORKING AFTER CALLING SAME REPORT USING REPORTSERVICES API
14831544: FILE NAME W/ DOUBLE BYTE CHARACTERS NOT DECODED PROPERLY AFTER EXPORT
15886427: SCHEDULED JOBS DO NOT RUN AFTER START UP UNTIL A USER LOGS IN
15886696: MENU PARAMETERS WITHOUT DEFAULT VALUES ALLOW MANUAL ENTRY OF DATA USING IE7
15953794: UNABLE TO DELIVER LARGE FILE VIA SFTP
15982594: SELECTING THE DATE FROM CALANDER ICON IS REMOVING THE TIME ZONE INFORMATION.
15986061: UNABLE TO SELECT CERTAIN MENU CHOICES IN IE8 WHEN IN ACCESSIBILITY MODE
16036921: MDX QUERIES FAIL TO LOAD WHEN SAVING, OR IF SAVED, GENERATE NO DATA
16183449: SCHEDULE TRIGGER DOES NOT ACCEPT VARIABLE PARAMETER {$SYSDATE()-7$}
16191483: UNABLE TO SEE REPORTS AFTER UPLOAD ON ONE OF TWO NODES
16303357: 10G RTF TEMPLATE FAILS IN 11G WITH XPATH ERROR DUE TO INVALID DATA TYPE CASTING
16384964: CONDITIONAL FORMATS ARE NOT DEEPLY COPIED FOR EACH SHEET IN EXCEL TEMPLATE
16385344: XLSX FORMAT OUT OF MEMORY DUE TO LARGE NESTED TABLE
16440558: OUT OF MEMORY ERROR DURING QUICK MULTIPLE EDIT AND SAVE OF REPORT WITH IMAGES
16453917: INCONSISTENT ALIGNMENT IN INTERACTIVE REPORTS WITH PIVOT TABLES USING IE9.0
16480634: ER: IN XLSX REPORT SAVE SINGLE IMAGE INSTANCE FOR REPEATED IMAGES
16725621: NESTED FORMULAS IN PIVOT TABLE FAIL IN LAYOUT EDITOR/VIEWER/PDF
16754485: INCORRECT VALUES FOR SUBTOTALS IN TABLES WITH 2 OR MORE NESTED FUNCTIONS
16842141: BI PUBLISHER:PROBLEMS WITH CUSTOM FORMULA IN A SUBTOTAL CELL IN INTERACTIVE MODE


MapViewer

Know Bugs with this Patch

16906678: UPGRADE OF BIEE FROM 11.1.1.6.0 TO 11.1.1.7.1 CAUSES MAPVIEWER RUNTIME FAILURE


EPM

Known Bugs With This Patch

13974353: CONNECTION STRING USED TO ACCESS LEASING TABLE IS INCORRECT




There is a general note (1488475.1 - OBIEE 11g: Required and Recommended Patches and Patch Sets) HERE .


You might also be interested in:

PATCH 17606196 for OBIEE 11.1.1.7.1 - IE10 & Chrome 30 solution

Wednesday, June 19, 2013

Mark Rittman in the Hollyland

יומיים של כנס ILOUG צפויים בירושלים ביולי (10-11).
בין המשתתפים מרק ריטמן מRittmanMead, טום קייט ואחרים.

הקישור לרישום לכנס הוא כאן.

רשימת ההרצאות בתחום הBI היא כאן.



Saturday, June 8, 2013

How to Google any column value from OBIEE

What is an easy thing to do for a OBIEE developer, that brings lots of happiness to end users? Add a link to Google. So users can Google (search) for the value in the cell.
For example, Click on Bluetooth Adaptor in the following analysis:
  and get the relevant Google window

















If you know your way with OBIEE action, all you need to know is the recommended Google URL:  www.google.com/search?q= that is slightly different from what you get by default from Google (for example I searched "hello"): https://www.google.co.il/#site=&source=hp&q=hello&oq=hello&gs_l=hp.3..0l10.1439.2196.0.3419.5.5.0.0.0.0.148.610.1j4.5.0...0.0...1c.1.16.hp.iyvGVf687sY&bav=on.2,or.r_cp.&bvm=bv.47534661,d.bGE&fp=f34ff85f33209633&biw=1600&bih=796
 
If that is not enough, lets show some more details how to achieve it:
Create an action in OBIEE:
 Select Navigate to Web Page:

Paste the URL www.google.com/search?q=:

And Press "Define Parameters":

 Remove the "optional" mark for the parameter and save. I named my saved action "google".


How to use this action in an Analysis?
I created the above analysis and in the Products column properties -> interaction, selected Action Links as primary Interaction for value.
 Now I selected "Select existing Interaction":
And chose my "google" action.
There we can select the "column value" as the parameter value:
Select the relevant column:
and mark the "hidden" (and "fixed") options:
That is all.
And thanks to Nir for reminding me.

Tuesday, June 4, 2013

OBIEE - Allow me to offer an advice

This is not as good advice as was given to the class of 99 about the sunscreen but I have an advice as well.
Subscribe to 2 sourced of good information from Oracle. You will need access to Oracle support for both.

1. The support Hot topics. You can receive emails from Oracle about updates related to your interests. Its not BI specific at all. You select the products. You can use this link My Oracle Support and select what you want to receive, and how often.
If the link doesn't work, just login to http://support.oracle.com select "More" -> "Settings"  and on the right "Hot Topics E-Mail".




2. The OBIEE support comunity.


I could also advise you to brush your teeth and read RittmanMead blog, but that is common knowledge.