OBIEE Went to Las Vegas

We have been busy, and so have all the OBIEE Bloggers.
This year I thought it was about time we went to Collaborate, and boy was it worthwhile. Our room at the Delano was massive. The hotel was massive. The conference was huge. Grand Canyon unbelievable. And what can I say about Vegas? It has to be seen to be believed.

Talking of BIG, One thing that strikes me is how the Oracle Business Intelligence world get bigger each year. Not just more people (buying our book :)) but more features and more ways to achieve the results. In the beginning there was a simple Nquire system. Then Siebel Analytics, along with the Warehouse and the Informatica ETL as Siebel Analytics Applications. Oracle came next, re-branding as Oracle Business Intelligence (and OBIA), adding BI Publisher. Next we had Essbase, APEX, OWB and Discoverer to learn and figure into our projects. Integration with Fusion came along (what ever happened to IIS Implementations?) and the new hardware of Exadata and Exalytics. Now we have ODI to replace Informatica, move to the Cloud services of BICS and outsource our hardware to PaaS providers. This year sees the advent Data Visualyser in Cloud, on Premise and on Desktop (soon), while we decommission OWB and Discoverer projects, and learn the new APEX interface. Whilst this is happening there is the explosion of the ‘BIG Data’ tech wave which we have to plug in somewhere. Data Science is becoming mainstream so we have to integrate tools such a R into OBIEE.

The point is, the Oracle BI world is constantly developing, evolving and growing. The best way to keep up is to go to conferences with good BI technical content (and nice beaches!), join user groups (UKOUG, OAUG and/or ODTUG) or find yours at
You should, of course, read the blogs, buy the books and keep on learning!
Heres some for you to read now….

Blogs of the week

  1. BITeamwork API In Action – Calling Basic Interactions

Christian Screen sasy, “This post looks at the BITeamwork API in action, calling basic interactions such as those mentioned above for launching the cell annotation process and the dashboard comment editor.”

It covers:

  • Calling Dashboard Editor Via BITeamwork API JavaScript
  • Calling Cell Annotation Workflow Via BITeamwork API JavaScript
  • Bringing the Examples Together

2. Configuring the Remote Data Connector (RDC) for BI Cloud Service (BICS)

Richard Williams writes, “The BICS Remote Data Connector (RDC) was released in March 2016.  It allows reports and analyses in BI Cloud Service (BICS) to directly connect to an On-Premise Oracle Database.  When a report is run, a SQL request is generated by BICS and sent to the on-premise Weblogic server.  Weblogic sends that request to the on-premise database, and then compresses the results before returning those to BICS where it is displayed.  This gives customers with large on-premise data sets the ability to use BI Cloud Service without having to push all of that data to the cloud.”

It covers:

  • Install RDC Application
  • Configure Data Source
  • Download and Deploy Public Key
  • Set up RPD Connection and Publish RPD to BICS

3. Views as “stored text”

Connor McDonald says, “You’ll often see comments that views are not copies of the data, they are merely the stored text of a query that defines. This is by and large true, but don’t forget, this is not  the same as saying we simply take whatever text you give us, and store it. Let’s take a look at a simple example proving that this is not the case.”

4.  2 Reports You Might Enjoy in Oracle SQL Developer

Jeff Smith shares ‘Finding Unindexed Foreign Keys’ and ‘Top SQL – Tune It!’

5. Installing RStudio Server on an (Oracle) Linux server

Brendan Tierney says, “In a previous blog post I showed how you can install and get started with using RStudio on a server by using RStudio Server. My previous post showed how you could do that on the Oracle BigDataLite VM…The purpose of this blog post is to go through the install steps you need to follow on your own server or Oracle Database server.”

6. Temporal validity, multiple end dates

Alex Nuijten says, “Recently I got involved in a question on Temporal Validity Periods. The question was along the lines of: “What if I have a single start date but two possible end dates. One of the end dates is filled automatically by a background process (could be a job) while the other one is to signal that the end date is set manually by the user. Could you use Temporal Validity to get the correct rows?” It got me thinking though… would it be possible to define a single validity period when three (one start and two end dates) are involved?”

Read the full blog for more.

7. SQL Analytics in every day APEX

Scott Wesley asked if we were looking for a way to apply analytical functions to APEX applications?

8. How To Be More Productive with JDeveloper 12c Application Redeployment

Andrejus Baranovskis writes, “When you work on larger JDeveloper/ADF 12c project, most likely you will experience issues with application redeployment (rerun).”

Read his full blog to help solve the issue.

9. Post Hotsos Symposium 2016

Ric Van Dyke reviews the Post Hotsos Symposium 2016

10. BICS External Data – Reloadable

Wayne D Van Sluys writes, “This past weekend I wrote a post about the March 2016 BICS upgrade. I just stumbled on this nice new feature in the latest upgrade to BICS. The part about external data that I found frustrating was once it was loaded in as a data set I could not refresh the data.”

Read the full blog for more.

This week on Twitter

ODTUG tweeted ODTUG EPM, BI and Database Community Meetup at COLLABORATE16

Mark Rittman asked, “Is #OBIEE12c dead-and-buried & pushing up daisies … or the best BiModal BI platform ever?”

This week on LinkedIn

Stories from OTN and iTrain

Videos such as:

Cardinal Sins in OBIEE Development

and Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Security