HCMinsight - OBIEE Analytics: 2014

Thursday, December 11, 2014

Oracle Support - Browser Certification for #OBIEE

Document 1615805.2) on Oracle Support shows the supported browser versions for all versions of OBIEE.

OBIEE - Browser Certification Advisor (Doc ID 1615805.2)

IE 6
This is only supported with OBIEE 10g.
IE 7
Supported with OBIEE 10g and OBIEE 11.1.1.3.0 and later
IE 8
Supported with OBIEE 10g (10.1.3.4.1.and later) and OBIEE 11.1.1.3.0 and later.
IE 9
Supported with OBIEE 10.1.3.4.2, OBIEE 11.1.1.6.0 and 11.1.1.7.0 (recommended browser)
IE 10
Supported with OBIEE 10.1.3.4.2 and OBIEE 11.1.1.7.131017 and later.
IE 11

Supported with OBIEE 11.1.1.7.140527 Bundle Patch

Firefox 1.5
Supported with OBIEE 10g.
Firefox 2.0
Supported with OBIEE 10g.
Firefox 3.0
Supported with OBIEE 10.1.3.4.1
Firefox 3.5+
Supported with OBIEE 10.1.3.4.2 and OBIEE 11.1.1.3.0 and later
Firefox 6+
Supported with OBIEE 11.1.1.6.0 and later
Firefox 10+
Supported with OBIEE 11.1.1.5.0 and later
FireFox 13+
Supported with OBIEE 11.1.1.7.0 and later
Firefox 17+

Supported with OBIEE 11.1.1.6.0 and later

Google Chrome 12+
Supported with OBIEE 11.1.1.6.0 and later
Google Chrome 19+
Supported with OBIEE 11.1.1.7.0 and later
Google Chrome 25+
Supported with the OBIEE 11.1.1.7.1 Bundle Patch and later
Google Chrome 30
Supported with OBIEE 11.1.1.6.10 and later

Supported with the OBIEE 11.1.1.7.131017 Bundle Patch and later

Safari 4.x and Safari 5.x
Supported from OBIEE 11.1.1.5.0 and later

Wednesday, December 3, 2014

OBIEE Dashboard Prompt Scope - How to tell? #OBIEE #OBIEEtips

If you want to see if the scope of a dashboard prompt is set to Dashboard or Dashboard Page, there is an easy way to tell.

Here's a prompt that is set to scope Dashboard:

and here's the same prompt set to scope Dashboard Page:

Can you see the difference? Look closer.

Scope = Dashboard

Scope = Dashboard Page

The icon for the Dashboard scope has a little folder graphic above the page graphic.

Tuesday, November 4, 2014

Summary of Quantitative Relationships

You can find the following excerpt in the book "Show Me The Numbers": Designing Tables and Graphs to Enlighten written by Stephen Few.

Front Cover

Quantitative Relationships

Quantitative information consists of two types of data:

Quantitative
Categorical

Quantitative information always describes relationships
These relationships involve either

Simple associations between quantitative values and categorical subdivisions or
More complex associations among multiple sets of quantitative values.

There are four types of relationships within categories:

Nominal
Ordinal
Interval
Hierarchial

There are three types of relationships between quantitative values

Ranking
Ratio
Correlation

You can purchase a copy of "Show Me The Numbers": Designing Tables and Graphs to Enlighten online at the following web address: http://www.amazon.com/dp/0970601972/ref=cm_sw_su_dp

Thursday, October 30, 2014

Why it’s time to switch to Cloud BI

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

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)

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

Section 8.5: Oracle Business Intelligence Presentation Services (BIPS)

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

Section 8.6: Oracle Real-Time Decisions (RTD)

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

Tuesday, September 23, 2014

Level based measure example - #OBIEE #RPD

Here’s an example of level based measure. I created a new measure on the Booking Line Amount

that set the content level on the measure to Year on the Date dimension. When I run a query with Year, Booking Line Amount, and Booking Line Amount Year I get the same value for both metrics:

Now, if I add in the Month, I will get the Booking Line Amount for the Month but the Booking Line Amount Year will remain the same across all months:

So I can now create a calculation that shows the percentage of the year’s total for each month:

The only change on the logical column is this:

And now that metric shows up under the Date dimension hierarchy Year level:

The SQL for the query with Year and Month looks like this.. the red highlighted part is where it is rolling up the amount by year for that metric:

WITH

SAWITH0 AS (select sum(case when T405715.BOOKING_ORD_QTY_LBS * T405715.BOOKING_UNIT_PRICE_LBS is null then T405715.BOOKING_ORD_QTY_EA * T405715.BOOKING_UNIT_PRICE_EA else T405715.BOOKING_ORD_QTY_LBS * T405715.BOOKING_UNIT_PRICE_LBS end ) as c1,

T333493.PER_NAME_YEAR as c2 -- this C2 is referenced below for the rollup by year,

sum(case when T405715.BOOKING_ORD_QTY_LBS * T405715.BOOKING_UNIT_PRICE_LBS is null then T405715.BOOKING_ORD_QTY_EA * T405715.BOOKING_UNIT_PRICE_EA else T405715.BOOKING_ORD_QTY_LBS * T405715.BOOKING_UNIT_PRICE_LBS end ) as c3,

T333493.PER_NAME_MONTH as c4,

T333493.X_MONTH_SORT as c5,

T333493.X_YEAR_SORT as c6

from

W_DAY_D T333493 /* Dim_W_DAY_D_Common */ ,

WC_QBBPF_F T405715 /* Fact_WC_QBBPF_F */

where ( T333493.ROW_WID = T405715.DATE_WID )

group by T333493.PER_NAME_MONTH, T333493.PER_NAME_YEAR, T333493.X_YEAR_SORT, T333493.X_MONTH_SORT),

SAWITH1 AS (select sum(D1.c1) over (partition by D1.c2) as c1,

D1.c2 as c2,

D1.c3 as c3,

D1.c4 as c4,

D1.c5 as c5,

D1.c6 as c6

from

SAWITH0 D1)

select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4, D1.c5 as c5, D1.c6 as c6, D1.c7 as c7 from ( select distinct 0 as c1,

D1.c4 as c2,

D1.c2 as c3,

D1.c5 as c4,

D1.c6 as c5,

D1.c1 as c6,

D1.c3 as c7

from

SAWITH1 D1

order by c5, c4 ) D1 where rownum <= 65001

Wednesday, September 17, 2014

Two quick answers on RPD design: Foreign Keys

Why must line must be drawn from fact to dim in physical diagram join?

When you create the join between the two tables, the table at the start point of the drawn line will be where the foreign key object will be created that describes the reference from the fact to the dim. If one does not already exist, a key object will also be created on the join column(s) on the table at the end point of the drawn line (the dimension). So foreign key on fact, key on dimension as would be expected in a 1:M join.

Why should you uncheck foreign keys when importing tables?

The only references I could find to unchecking this box during import suggested that including the foreign keys might make the import take longer. If the foreign keys are imported, it would still be a good idea to review all join conditions between the tables after importing.

Thursday, September 11, 2014

Error when attempting to schedule an agent that has a calculation in an IS PROMPTED filter

When attempting to schedule an agent for an analysis that has IS PROMPTED filters, an error occurs if any of the filters are based on a calculation (for example, a case statement).
You will need to save a copy of the analysis without those calculated filters in order to schedule the agent.

OBIEE Favorites Menu privileges

Came across this issue today. Users with only BI Consumer application role were unable to see the Favorites link on their dashboards even though the privilege had been granted to BI Consumer on the Home and Header->Favorites Menu option on the Manage Privileges page in OBIEE.

The reason? Because they also needed to have the Personal Storage (My Folders and My Dashboard) privilege granted as well under the Catalog section as well. In this case, that privilege had only been granted to BI Authors.

Friday, June 27, 2014

Free online OBIEE quizzes:

Test your knowledge on a wide range of OBIEE topics with the following quizzes:

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

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

OBIEE 11g BI Mobile App Designer Quiz
http://quizegg.com/q/81447

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

Oracle BI Applications Implementation
http://quizegg.com/q/67948

Oracle BI Peoplesoft HR Applications Implementation
http://quizegg.com/q/67748

Oracle DAC 10g Administration
http://quizegg.com/q/66429

Monday, May 12, 2014

Rittman Mead post on future of OBIEE

Mark Rittman has an excellent post covering the current and future states of OBIEE.

The State of the OBIEE11g World as of May 2014 - Rittman Mead

My take aways:

1) Transition from Informatica to ODI - need to get people trained on this; DAC skills will become less relevant over time (not immediately but over the next year or two)

2) Pushing cloud based OBIEE - this will impact the need to have resources who do installs, patches, manage the servers; this also means new features will become available to those on the cloud much faster;

3) End users want the ability to create their own data visualizations using their own data merged with OBIEE -accessible data (think Excel on steroids) without having to deal with IT. Expect to see the ability for users to upload data into webcatalog structure to combine with corporate data in their own reports.

Wednesday, April 16, 2014

Unannounced Oracle OBIEE 11.1.1.7.10?

There is documentation on the Oracle website for version 11.1.1.7.10 that does not appear to have been announced yet.

Some interesting new features are mentioned in the documentation:

A new style named Skyros
Ability to delay the execution of dashboard pages. This will force users to select values from a prompt before executing the reports on the dashboard.
Ability to set and send multiple values in a dashboard prompt for request variables when the request variable is a string or numeric data type.
A new view type named treemap. Treemap is a space-constrained, two-dimensional visualization for displaying hierarchical structures with multiple levels. The treemap is limited by a predefined, rectangular area and displays two levels of data. The size of each tile (or rectangle) is based on a measure, and the color of the tile is based on the second measure.
Ability to add global variables. A global variable is a column created by combining a specific data type with a value.
Using options on the Administration page, you can set the logging levels for Oracle BI Presentation Services.

Click here to view the 11.1.1.7.10 documentation

Monday, February 3, 2014

New Oracle BI Mobile App Designer quiz

A new free online quiz is available for testing your knowledge of Oracle's BI Mobile App Designer tool. Go here: OBIEE 11g Mobile App Designer Quiz to take the quiz. You can create an account with the test hosting site (Quizegg) but no personal information is collected.