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