Thursday, October 30, 2014

Why it’s time to switch to Cloud BI


Displaying image1.jpg


  •          Quick, Reliable, and Versatile    
The Oracle Cloud BI allows you to create analysis’ in seconds. It allows you to edit views to create graphs that will allow your customers/consumers to easily distinguish the data you have provided for them. In Cloud BI you are now able to use all the BI apps on any mobile device. This allows for a very easy access to any of your data that is put into the Oracle Cloud. Cloud BI may be used through small groups all the way up to an entire organization. The product can be personalized for the optimal use for any amount of members.


  •          Secured
Cloud BI is moderated through the Oracle Public Cloud. The Oracle Public Cloud meets all of the industry's strictest standards for security. The data that is stored into the Oracle Cloud is never passed through third parties. This should allow the customers to know that their data can be stored safely and not have to worry about hackers accessing their private information.


  •          Easy to Learn
Cloud BI has a substantial amount of guidance that allows all users to easily access any type of training and tutorials that they please on the product. There are already many tutorials and training videos that Oracle has put out to allow customers to n and get a head start on the product.

Here is a good website to start on your training and tutorials:
http://docs.oracle.com/cloud/latest/reportingcs_use/index.html





Oracle Cloud BI is a necessity for any organization that is trying to get the most reliable and efficient analytics platform while reducing the need for dedicated hardware and software installations


Displaying image2.jpg

Wednesday, October 22, 2014

OBIEE 11g PDF printing bug related to Page Number on Footer of analysis

When attempting to print an analysis that has a Page Number variable displayed in the page header or  footer, the following error is displayed:

Error: "Sax parser returned an exception. Message: Expected whitespace. Error Codes: UH6MBRBC"

The problem is related to OBIEE 11g bug 18601947 which is described on Oracle Support below:


When Exporting a Dashboard to PDF with a Page Number in the Header or Footer
(Doc ID 1913713.1)
https://support.oracle.com/epmos/adf/images/t.gif


https://support.oracle.com/epmos/adf/images/t.gif

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140415 to 11.1.1.7.140527 [Release 11g]
Information in this document applies to any platform.
**Updated on 15-Oct-2014**

Symptoms

When you export a dashboard that has a page number (@{pageNumber}) in the footer or header to PDF, the following error appears:
Error
====
Sax parser returned an exception. Message: Expected whitespace, Entity publicId: , Entity systemId: , Line number: 33, Column number: 21
Error Details
Error Codes: UH6MBRBC
Location: saw.subsystem.portal, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Note: If you remove the page number (@{pageNumber}) from the footer that has been set at the dashboard properties level, this error no longer occurs.

Cause

Bug 19010387 - SAX ERROR WHEN EXPORT A DASHBOARD TO PDF WITH PAGE NUMBER (FOOTER OR HEADER)
Bug 18601947 - PM: RESOLVE BASIC HTML IN VIEWS CONTAINING FMAP AND PAGENUMBER
 

Solution

This issue has been fixed in Patch 18601947 which can be download from My Oracle Support (http://support.oracle.com).

Thursday, October 16, 2014

More than 5000 people have taken at least one of these #OBIEE quizzes... best free prep for certification exam 1Z0-591

If you can pass these quizzes, you are well prepared to pass the OBIEE certification exam (1Z0-591)

OBIEE 11g Answers Quiz 1
http://quizegg.com/q/67021

OBIEE 11g Answers Quiz 2
http://quizegg.com/q/67377

OBIEE 11g RPD Quiz 1
http://quizegg.com/q/62269

OBIEE 11g RPD Quiz 2
http://quizegg.com/q/62396

OBIEE 11g RPD Quiz 3
http://quizegg.com/q/62397

OBIEE 11g Security Quiz
http://quizegg.com/q/67439

OBIEE 11g Bundle Patch 11.1.1.7.141014 is available for download from Oracle Support #OBIEE

No new features in the 1414014 patch release.   Bug fixes are listed below.

Section 8.1: Oracle Business Intelligence Installer (BIINST)
No new bug fixes.
Section 8.2: Oracle Business Intelligence Publisher (BIP)
New bug fixes in this patch are shown in the following list:
19685263:       QA:SEARCH OPTION FOR SINGLE SELECT PARAMETER NOT WORKING
19236186:         SEARCH VALUES NOT REFLECTED CORRECTLY WHEN CANCEL SELECTED IN SEARCH BOX
19550559:       PARAMETER VALUES GETTING DUPLICATED WHEN CLICK ON REMOVE OR REMOVE ALL
16364586:       MULTIPLE VALUE PARAMETERS ARE NOT PASSED TO NEW ENGINE.
17412119:       JKF - FUSION BI PUBLISHER PAGE HAS STOPPED WORKING ON PRODUCTION
17846765:       BIP - BUG 17463451 - QA: SECTION BACKGROUND COLOR DOES NOT SHOW IN THE EXCEL
17979086:       DEFAULT SELECTED VALUE IN PROMPT NOT APPEARING IN SEARCH WINDOW(ISSUE WHEN PROMP
17979327:       REPORTSERVICE WEB SERVICE ALWAYS RETURNS FALSE FOR MULTIVALUESALLOWED
18025050:       BIP RUNS OUT OF MEMORY WHEN OS IS SET TO NON EN_US LOCALE
18077559:       IYA - MOZILLA FIREFOX CRASHES WHEN EDITING DATA SET
18113617:       R8BP: HTTP 500 ERROR WHILE TRYING TO EDIT PAYABLES TEMPLAT UNDER CUSTOM REPORT
18173394:       Fix for Bug 18173394
18306507:       QA: NO LINE BREAK SHOWS ON EXCEL NARRATIVE VIEW
18332362:       Fix for Bug 18332362
18336186:       11G:SCHEDULE PAGE IS NOT TRANSLATED ACCORDING TO LANGUAGE
18429472:       NLS:BIP WEB UI PAGE CAN NOT BE LOADED IN FA USER LANG IN CERTAIN SCENARIOS
18515334:       SCHEDULING REPORTS FAILS WITH SPECIAL CHARACTERS IN SEARCH CRITERIA FOR BIP 11G
18539339:       PARAMETERS PASSED FROM PROMPT TO BIP CONVERT COMMA (
18542946:       'FIRST WEEKDAY' NOT WORKING CORRECTLY IN SCHEDULER
18609529:       2:PSR:PERF:BIP: NEED OPTION TO SET DATA MODEL SCALABILITY MODE AT INSTANCE LEVEL
18622456:       LAYOUT EDITOR 'REPEATING SECTIONS' DESCENDING SORT NOT WORKING FOR PDF OUTPUT
18632799:       BI REPORT JOBS STOPPED RUNNING AFTER THE POD WAS TAKEN DOWN FOR MAINTENANCE
18665704:       LOV DISPLAYS PRODUCT ID INSTEAD OF PRODUCT NAME FOR SEARCH BEYOND LOV LIMIT
18712052:       PREVIOUSLY SELECTED VALUES NOT REFRESHED WITH DEPENDENT LOVS WITH 1000+ VALUES
18745662:       OPEN FILE HANDLES NOT BEING RELEASED
18816952:       PSR:PERF:BI BIP PLSQL CALL AT THE ROW LEVEL IN THE JDBC LAYER CAUSES OOM
18889966:       EXCEL FOUND UNREADABLE CONTENT IN 'NAME OF EXCEL FILE.XLSX'
18967973:       FOPROCESSOR GENERATES HUGE *.FO FILES UNDER /TMP
19032857:       ONCE CACHE TIMEOUT HAS EXPIRED, ANY OTHER REPORT RUNS ARE NOT FETCHED FROM CACHE
19131461:       SEARCH VALUES NOT REFRESHED IN DM EDITOR WHEN SELECTING LOV FROM SEARCH DIALOG
19214907:       WHEN LOV IS OF FIXEDDATA ,REPORT IS THROWING CLASSCASTEXCEPTION.
Section 8.3: Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
No new bug fixes.
Section 8.4: Oracle Business Intelligence Server (BISERVER)
New bug fixes in this patch are shown in the following list:
17804119:       OBIEE/BIP: UNABLE TO SEARCH LIST OF VALUES WHERE LOV QUERY USES A PARAMETER
18504891:       AFTER UPGRADE FROM 11.1.1.6, %AGE CALCULATION IN PIVOT TABLE IS INCORRECT 
18968751:       BI SERVER TAKES LONG TIME TO PROCESS OTBI LOGICAL REPORTS AFTER REL7->REL8 UPG
15845044:       NEWLY ADDED PRESENTATION TABLE ALWAYS GOT PUSHED TO THE BOTTOM IN SA
16371472:       UNEXPECTED RESULTS WITH LOCATE AND SUBSTRING FUNCTION
16796272:       ENABLE AUTOCOMMIT AND ADD TIMESTEN OPTIMIZER HINTS TO QUERIES
17407252:       REPORT WITH HFM CONNECTOR CRASHES HFM WITH MORE THAN 50 CHOICES
17442448:       FILTER ON HIERARCHY COLUMN WITH HFM CONNECTOR ERRORS:OPR4ONWY:U9IM8TAC:OI2DL65P
17503750:       EXTREMELY SLOW MUD CHECKINS - PARTLY DUE TO CONSITENCY CHECKS
17651328:       REPORT ERRORS OUT WHEN DRILLED DOWN ON A HIERARCHICAL COLUMN.
17820357:       EQUALIZERPDS VERSION STRING STORED IN .DATA SECTION INSTEAD OF .ORACLEVERSION
17831621:       INTERNAL ERROR WHEN TRYING TO DO "KEEP ONLY RELATED PARENTS" FROM ASO APPLICATIO
18160174:       CUSTOMGROUPMEMBERS IN MDX SHOWS NO RESULT BY ESSBASE-METHODS LIKE MEMBER.CURRENT
18171844:       REPORT ERRORS OUT WITH ESSBASE ERROR: REPEATED DIMENSION [ANALYSISCODE] IN MDX
18178380:       DELETING PHYSICAL COLUMNS IS NOT REFLECTED IN MASTER REPOSITORY
18234853:       AGGREGATE DATA INCORRECT FROM SAP BW DATASOURCE
18475438:       CSSTOKEN CODE PATH BROKEN
18615083:       RPD ACCESS CONTROL CHANGES BETWEEN 10G AND 11G
19076537:       OBIEE11.1.1.7.140415 [NQSERROR: 46008] INTERNAL ERROR: SQOIMDXGENERATORHYPERION.
18763373:       TIME DIM CUSTOM GROUP WITH SUM/+ GIVES WRONG RESULT ON TIME BALANCE MEASURE
New bug fixes in this patch are shown in the following list:
19546808:       TRACKING BUG TO DELIVER BUG 16068402 FIX TO 11.1.1.7.141014 (OCT 2014 PATCHSET) 
17311027:       PROMPTING ON GROUPS CAUSES ERRORS WHEN EXPORTING REPORTS.
17220399:       CANNOT GET BACK TO TOTALS USING PIVOT TABLE PROMPT 
19277857:       PSUEDO HTML TAGS IN COLUMN FORMULA FAIL TO EXPORT IN JULY BP
18826493:       OBIEE 11G: NARRATIVE VIEW  EXPORT TO PDF CAUSES SAX PARSER ERROR:UH6MBRBC 
14782647:       CUSTOM CSS STYLE OF COLUMN HEADING DOES NOT WORK ON IE BROWSER
14803272:       QA:EXCEPTION ON EXPORTING A REPORT WITH CUSTOM NUMBER FORMAT EXCEL 2007
16556274:       QA: VALUE MENU NO POPULATED IN CONDITIONAL FORMT>NEW CONDITION IF BINS CASE STMT
16875993:       CHANGING SLIDER VALUE-YEAR,VERTICAL AXIS VALUES DISAPPEAR IN CHART WITH STYLING
16907102:       11G DISPLAY A PRESENTATION VARIABLE IN COLUMN TITLE FOR GRAND TOTALS SHOWS HTML
16919893:       RETURN LINK CLEARS DASHBOARD FILTERS
17057555:       UNABLE TO USE ESCAPE CHARACTERS IN CALCULATED ITEM - FAILS WITH SYNTAX ERROR
17308853:       SSO CANNOT WORK FOR EPM WORKSPACE
17342813:       PARTIAL DATA SHOWN AT PARENT LEVEL WHEN USING HIERARCHY OBJECT IN TABLE/PIVOT
17449621:       SELECTION  ON HIERARCHY COLUMN : CAN'T SELECT MEMBER  'OK GREYED OUT'
17515912:       'NO EDGE DEF: SAW_8834_B' ERROR AFTER CLICKING ON DRILLABLE COLUMN. IE7.
17653504:       HIERARCHICAL PRESENTATION VARIABLE NOT SET WHEN NAVIGATED VIA ACTION LINK.
17719891:       OBIEE 11G: SAVED RESULT SETS NOT PHYSICALLY DELETED
17734913:       CHOPPY AND PAUSED SCROLLING ON 11.1.1.7 SERVER VS 11.1.1.6 SERVER.
18191433:       OBIEE 11G - MULTIPLE DEVICE PROFILE NOT WORKING
18289005:       QA:FATAL ERRORS ARE THROWN WHEN TRYING TO EXPORT COLUMN PROMPT WITHIN DB PAGE.
18299341:       PRINT TO PDF ONLY SENDS FIRST 25 ROWS WHEN USING VIEW SELECTOR
18421243:       RELEASE LABEL VERSION EXTRACTION SHOULD USE UNDERLYING DATED LABEL
18430260:       PSR:FUNC:BI:BETTER THREAD QUOTA ERROR MESSAGE THAN STD::BAD_ALLOC
18512339:       INSERT PAGE BREAK NOT WORKING WHEN USED TOGETHER PLACE VALUE IN NEW ROW
18531410:       AUTO COMPLETE PROMPT BOX NOT DISAPPEARING WHEN TABBING
18601947:       PM: RESOLVE BASIC HTML IN VIEWS CONTAINING FMAP AND PAGENUMBER
18677382:       ADDING CALCULATED ITEM WITH FORMULA $N FAILS IN DIRECT DB REQUEST ANALYSIS
18699238:       LOG REASON FOR SESSION LOGOFF
18770064:       [1602241] SAWSERVER CRASHED ON 11.1.1.7.140225
18787874:       CLICKING ON 'NEXT 25 ROWS' ALWAYS RETURNS COMPOUND VIEW
18828701:       GETCOLUMNVALIDVALUE THROWS AN EXCEPTION WHEN A SEARCH EXPRESSION IS GIVEN
18896901:       PASSING VARIABLES TO THE HTMLVIEWSERVICE WEB SERVICE
18957880:       PAGE BREAKS NO LONGER WORKING IN 11.1.1.7.1.X
19065395:       COPYITEM SHOULD ALLOW COPYING ALL CONTENT OF A READONLY FOLDER TO A NEW FOLDER
No new bug fixes.
Section 8.7: Oracle Business Intelligence ADF Components (BIADFCOMPS)
No new bug fixes.
Section 8.8: Oracle Business Intelligence Platform Client Installers and MapViewer

No new bug fixes.OBIEE