Tuesday, June 6, 2017

Oracle Baseline Validation Tool

The Oracle BI Baseline Validation Tool enables you to identify differences during life cycle operations, such as migrating from the Oracle BI 11g release to the 12c release (or regression testing).
It became available with release 12, to support and improve the tedious process of upgrade validation. To the best of my knowledge, it's free with OBIEE.
Baseline Validation Tool is a command line tool, available for Windows and Linux.

I was very surprised lately that many of my customers were unaware of it.

So here is the download link. The documentation is part of the download.

You can find many blogs covering the subject such as enterprisebisolution, here (no part 2) and vlamis, here or a short introduction on YouTube.


Monday, June 5, 2017

Oracle Israel BI Forum June 22





בואו ללמוד UX במערכות Analytics
יום חמישי, 22 ביוני, 2017, 9:00-14:00, בית אורקל (כניסה
B) , רח' אהרון ברט 18, פתח תקווה

 Register now

כנס בנושא UX Design ובניית מערכות אנליטיות בענן
בין נושאי המפגש:
  • מגמות וטרנדים בתחום מערכות אנליטיות בענן
  • בניית תצוגות חכמות ונכונות למשתמשי הארגון
  • כללים בבניית Dashboard
  • כללי אצבע לUX נכון
  • Deep Dive העברת מערכות לענן
  • תהליך בניית/העברת מערכת BI בענן
המפגש מיועד ל: מנמ"רים, מנהלי ומפתחי BI, אנליסטים, מנהלי שיווק, מנהלי כספים ויועצים.
ההשתתפות במפגש אינה כרוכה בתשלום אולם מחויבת ברישום מראש, על בסיס מקום פנוי.
Agenda
09:00
התכנסות וכיבוד קל
09:30
דברי פתיחה
סטפן טבקארו, מנהל פיתוח עיסקי
BigData, IOT וBI
09:50
מוטיבציה להעברת ובניית מערכות BI בענן
טובית לייבה – יועצת טכנולוגית, אורקל ישראל
10:30
UX לא רק Buzz Word
אירית חומסי - מומחית חווית משתמש, בלה גוטייה - מומחית לאנליטיקה חזותית והדמיית נתונים
12:00
תהליך בניית והעברת מערכות BI לענן
בוריס דהב – יועץ טכנולוגי, אורקל ישראל
13:00
ארוחת צהריים

קישור להרשמה




 

Wednesday, March 1, 2017

Oracle Israel Cloud Tech day

הנכם מוזמנים לכנס טכנולוגי על הענן של אורקל
הוא יתקיים יום שלישי,21 במרץ 2017 ,
בלאגו ראשל"צ.

http://www.oracle-ilnews.com/cloudday/inv.php?BannID=1020&utm_source=boris.dahab@oracle.com&utm_medium=eMail


בכנס נציג לראשונה בישראל את הדור הבא של טכנולוגיות הענן של אורקל בהרצאות מליאה, בשני מסלולים: IaaS & DevOps ו-Cloud Platform וב-Demo Ground.
בין אם אתם רוצים להעביר פעילות קיימת לענן, בין אם הצורך שלכם הוא להשלים ולהרחיב אפליקציות SaaS שכבר רצות בענן, ובין אם אתם נדרשים לפתח שירותים חדשים אבל לא רוצים להשקיע בתשתיות, Oracle Cloud Day הוא המקום להיות בו.


כמובן גם BI וBig Data יהיו שם, ולא פחות חשוב, אני מרצה!

 (למען הסר ספק, המציג/ה בתמונה אינו אני).
הקישור לרישום כאן.


אם אתם לא עומדים במתח, הנה משהו שסטפן כתב: ביג דאטה – זה לא חייב להיות ביג דיל

Sunday, January 22, 2017

OBIEE 11.1.1.9.170117 bundle patch is available

OBIEE 11.1.1.9 bundle patch is available:
Patch 25189841: BI BUNDLE PATCH 11.1.1.9.170117 is available from Oracle.
It is available for:
  • Linux x86
  • Linux x86-64
  • Microsoft Windows 64bit
  • HP-UX Itanium
  • IBM AIX on POWER system (64-bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86-64 (64-bit)

The readme is here.
The Oracle BI EE Suite Bundle Patch 11.1.1.9.170117 under the top-level patch 25189841 consists of the following component patches:
Patch Abstract
25054309 Oracle BI Mobile App Designer (BIMAD)
25214874 Oracle Business Intelligence Server (BISERVER)
25217499 Oracle Business Intelligence Presentation Services (BIPS)
24533980 Oracle Enterprise Performance Management Components Installed from Oracle BI Installer 11.1.1.9.0 (BIFNDNEPM)
25214935 Oracle Business Intelligence Publisher (BIP)
25266214 Oracle Business Intelligence Platform Client Installers and MapViewer
24346370 Oracle Business Intelligence ADF Components (BIADFCOMPS)
21517672 Oracle Business Intelligence Third Party  (same as last one)



The patch includes the following bug fixes:

Oracle Business Intelligence Presentation Services (BIPS)


23569560     QA: ERROR - DUPLICATE ID: 'NULL' FOUND ON DASHBOARD `CLOSED ISSUE ANALYSIS¿
23528459     ACCESS REL12: JAWS CAN'T READ VALUES IN UNLABELED TABLES IN TAX AUTHORITY REPORT
23502030     VPAT - DUPLICATE ID ERROR ON MANY DASHBOARDS WITH OGHAG STRUCTURE RUN
21192948     QA:ACC:ERROR:DUPLICATE ID AT 'PERMISSIONS' AND 'ABOUT' DIALOG WITH OGHAG>STRUCTU
23643225     REPORT PREFIX CAUSES FAILURE WHEN SINGLE QUOTE IS PRESENT INSIDE OF VARIABLE
22384242     NEED A WORK-AROUND/SOLUTION FOR DISABLING FAULTY JOBS IN AN AUTOMATED FASHION
19568323     CONDITION FORMATTING OPERATOR ¿IS NOT NULL¿ ON A GRAPH.
21265568     SUPPORT ICAP BASED VIRUS SCANNING IN SAWSERVER
20258650     THE REPORT LINKS WITH MULTIPLE PARAMETERS ARE NOT WORKING.
23254924     USERS ARE INTERMITTENTLY LOGGED OUT
21674920     OBIEE TABLE SCROLLING SNAPS BACK TO FIRST ROW SECTION CONDITION IS USED
21347308     PRINTING TO PDF OR HTML DISPLAYS SESSION VARIABLE, NOT ITS CONTENT
24623887     Fix for Bug 24623887
22382923     CASCADED DASHBOARD PROMPT DOES NOT WORK ON IE11
21979698     NEW DMS METRICS REGARDING BI USAGE
24362101     Fix for Bug 24362101
21259784     NEED TO ADD "CONTAINS HTML MARKUP" IN NO RESULT VIEW MESSAGE EDITOR
25203978     EXPORT MENU ITEM NOT WORKING IN EPM WORKSPACE
21178536     Fix for Bug 21178536
25070137     TRYING TO REMOVE GROUP-FATAL:AN XML INSTANCE WAS INVALID AND UPGRADE NOT ALLOWED
23569936     ER: REL13: RESYNCREPOSITORY FAILS "ORACLE INSTANCE LOCATION MUST BE PROVIDED"
24973040     CHANGE IN FILTERS FOR HIERARCHIAL COLUMNS BETWEEN 12C AND 11G ENVIRONMENTS
23148164     SERVICE/API FOR EXPORTING BULK DATA FROM ANSWERS
21215489     ACC: ERROR:" MULTIPLE LABELS FOUND: UNDEFINED" IS THROWN WITH OGHAG>FORM
19608547     QA:ERROR OR MISSING LABEL SHOULD'NT OCCUR FOR WATER FALL REPORT WITHIN DB PAGE.

Oracle Business Intelligence Server (BISERVER)


24836865     RPD PROVISIONING FAILED WITH BISERVERXMLEXEC ERROR 25
24703052     REL11 : CSAEXTENDER  WITH NEW UTILITY THROWS FALSE SEVERE MESSAGES
24428269     REL11BP160711 UNABLE TO SET PREFERRED_CURRENCY VARIABLE
24343818     BISERVERPROVISIONBIAPPSRPD TO SKIP EXTRA CONNECTION POOLS VARIABLE PROJS
24343815     REL11BP160711 BISERVERPROVISIONBIAPPSRPD TO ACCEPT NAME AND PARENTNAME
21630121     BICS VA PROJECTS SHOWS NQS ERRORS AFTER UPGRADE TO 15.2.6
24831219     R12PREFLIGHT: INACCESSIBLE COLUMN: "AUXILIARY CLASSIFICATION 1". "BASE LEVEL AUXI
24570785     MANY CORE* FILES ARE CREATED UNDER INSTANCES FOLDER AFFECTED OBIEE IN REL10
24966137    TRACKING BUG TO PULL OUT REGRESSION CAUSED BY BUG 22903243
24651853    NOT STRESS:FA: FIN:QA: CRASH IN CATALOGCRAWLER ON 11.1.1.9.160912
24715052    TRACKING BUG FOR SERVER CHANGES REQUIRED FOR BUG 22384242
24413997     FAILED TO INVOKE EXTRACTCUSTOMSUBJECTAREAS_CPP FROM BI PATCHING ORCHESTRATION
25248099     NEED TO CHECK THE RETURN CODE OF BUILDROLEHIERARCHY
23579474     CALL TO NQSMODIFYMETADATA BRINGS DOWN BI SERVER
25229711     REL12:BP170117:EXTRACTPROJECT FAILS TO EXTRACT WITH -U OPTION
25063469     BISERVERRNRPATCHER NEEDS OPTION TO VALIDATE ONLY MODIFIED SUBSET
25209112     QA: BISERVERAPPLYVERTICALRULES COMMAND FAILING IF PASSWORD IS PROMPTED
24504161     BIEXTENDER -F OPTION SHOULD HANDLE THE OBIEEBROKER FAILURE
25182868     QA:BISERVERRNRPATCHER EXITING IF THERE IS NO SA WITH PREFIX CUSTEXT
25167669     REL11 RPD RIP AND REPLACE : ERROR , EXCEPTION  MESSAGES IF NO VERTICAL CONTENT
25167629     REL11 : BI HEALTH CHECK FAILING AT VALIDATERPD
25142292     RNR PATCHER: CORE DUMP IF ANY UTILITY MISSPELT (LINUX)
24622664     FIX COMPLEX JOINS (SWITCHING POSITIONS)
24312833     FEW DFF VO'S NOT IMPORTED CAUSING THEM TO NOT BE MAPPED
25065583     BI JDBC IS NOT USING OPTIMIZED RECORD FORMAT
24794615     VALIDATERPD DOESN'T WORK WHEN PLUGGED IN BISERVERRNRPATCHER
24387222     ER TO HAVE BI EXTENSION RUN IN FULL ALL THE TIME
20781025     BI EXTENDER ENHANCEMENTS AFTER THE ATG EQUALIZATION PROCESS ENHANCEMENT
25041330     RNR PATCHER: CORE DUMP IF ANY UTILITY MISSPELT (WINDOWS)
24973824     VALIDATION TAKING TOO MUCH TIME IN MAIN
24823241     RNR PATCHER : EXITS AFTER STARTING EXTRACTVCUSTOMIZATION
24823166     RNR PATCHER : CORE DUMP IF INPUT XML IS NOT FOUND IN PLACE
24808824     EXTRACTCUSTOMIZATION INTRODUCES DIFF DURING SINGLE UTILITY RUN
24760194     UPDATE EXTRACTCUSTOMIZATION UTILITY AS A CONSEQUENCE TO BUG 24740744 FIX
24757097     VALIDATERPD CONSEQUENCE TO BUG 24740744 FIX
24748849     ADD AUTOMATED TEST CASE FOR SINGLE PATCHING UTILITY FRAMEWORK
24740744     SINGLE PATCHING UTILITY SHOULD PROVIDE OPTION TO DISABLE RPD CHECK
24677401    SINGLE PATCHING UTILITY FRAMEWORK AND PROVISIONING UTILITY INTEGRATION CHANGES
24664928     MODIFY VALIDATERPD UTILITY FOR RNR SINGLE PATCHING UTILITY
24664909     MODIFY BISERVERAPPLYVERTICALRULES UTILITY FOR RNR SINGLE PATCHING UTILITY
24664888     MODIFY BISERVEREXTENDER UTILITY FOR RNR SINGLE PATCHING UTILITY
24664862     MODIFY CSA UTILITY FOR RNR SINGLE PATCHING UTILITY
24664827     MODIFY BISERVERPROVISIONING UTILITY FOR RNR SINGLE PATCHING UTILITY
24657032     RNR:IMPROVEMENT ON OBJ CREATION IN-MEMORY WITHOUT UDML IN BIEXTENDER AND VERTICA 
21942801     OTBI-E V3:PSR:FA REL9.2:LOT OF SPACE CONSUMED BY EXTRACTOR QUERY.
24792199     REL11: VALIDATERPD SCRIPT FAILS ON REL11 SAAS POD RPDS

Oracle Business Intelligence Publisher (BIP)


24554203     FIX FOR USING <DEFINE LEVEL> WITHOUT <GROUPING CRITERIA>
24662344     "USE OF XPATH EXPRESSION IN SORT AND GROUPING CRITERIA SUMMARY:     REQUIRED"
19524875     CAN ENTER ANY ALPHA NUMERIC VALUE FOR MEMORY GUARD RUNTIME PROPERTIES
23030301     Fix for Bug 23030301
23038891     Fix for Bug 23038891
23180883     NLS: FRENCH: BURSTING: UNABLE TO VIEW SPLIT-BY.DELIVER-BY VALUES
22252794     PARAMETER PASSING DEFAULT VALUE RATHER THAN NULL
23322845     OPTIMIZE_BURST FLAG SHOULD HAVE DEFAULT VALUE SET TO TRUE
22898301     STRESS: AUTENTICATION ERROR.INVALID SESSION ID OR SESSION EXPIRED
23172894     OUTPUT FORMAT DROPDOWN LIST OPTIONS IS NOT DISPLAYING CORRECTLY ON UI
23152011     FUSION- BIP ORA-01841: (FULL) YEAR MUST BE BETWEEN -4713 AND +9999, AND NOT BE 0
23271391     ENABLE XSL TEMPLATE REPORTS CANCELLABLE FROM SERVER SIDE
24749837     QA: 12C: 23508707: MEMGRD CMD LINE TOOL GENERATES UNNECESSARY FILES UNDER /TMP
22938413     ADD BOM FOR ETEXT OUTPUT WHEN OUTPUT ENCODING IS UTF-8
23319129     BIP CLIENT API ENHANCEMENT TO SUPPORT HIGH VOLUME HCM PAYROLL PROCESSING
21135840     BI PUBLISHER CANNOT DELIVERY ON WEBDAV USING DIGEST AUTHENTICATION
25170389     "IGNORE USER TIMEZONE" CHECKBOX DOES NOT STICK AFTER NOV-2016
23124602     PRINT LOG MESSAGE FOR IGNORED EXCEPTION
25065019     FIX RETRY OF ESS JOBS IN CASE OF NON-SYSTEM ERROR
22865151     BIP ETEXT OUTPUT LENGTH MODE CANNOT CONTROL DOUBLE BYTE CHARACTER
22729509     NOTSTRESS: SAW SERVER-INVALID SESSION ID OR SESSION EXPIRED ERROR
21098317     RE-INDEXING OF METADATA TAKES TOO LONG AND BLOCKS OTHER REPORT EXECUTIONS
23016235     Fix for Bug 23016235
22554427     NEW PDF FORM FIELD FOR DOCUMENT-REPEAT-ELEMENTNAME
23233792     FUSION APPLICATIONS - BI PUBLISHER - FTP -  ORACLE.XDO.DELIVERY.SSH2.SSHEXCEPTIO

Oracle BI Mobile App Designer (BIMAD)


24675627     Fix for Bug 24675627
22601855     MOBILE APP COMPOSER REPORT - NO DATA FOUND ISSUE
24762294     Fix for Bug 24762294
24605653     Fix for Bug 24605653