Back to the OBIEE Future

rssBlogs of the week

Have a look at our blogger database. Is yours there? Contact us if you would like to be added on.



I am planning on heading over to Kscope 15 next year.  Are you?


1. BUCKET_WIDTH: Calculating the size of the bucket

Brendan Tierney writes that he had a query about one of the functions BUCKET_WIDTH. The question was wondering if it was possible to get the width of the bucket in each case. There does not seem to be a build in feature to get this value, so we have to calculate this ourselves. He gives an example of how to calculate this.

2. OBIEE – Fines and Payments (or Orders and Order Lines) with correct totals

Boris Dahav says, “The problem is a “popular” one. You have 2 facts with different levels of aggregation. It’s often Orders fact and Order Lines fact (where there are Order Total in the Orders fact and Lines values in Lines Fact that might not the same due to shipping or general discount). In my case this is Fines fact and Payments fact. In this case they sums often don’t match since they might be only partial payment of the fine.”

3. Capturing Environment Variables in Oracle APEX

The post focuses on the Environmental Variables as they are vital in coding conditional statements , says Vishal Pathak.

4. Oracle BI Mobile App

Gerd lists the changes and new features as:

  • Support for action links, including action link navigation history
  • Support for dashboard sections
  • Support for Briefing Books
  • Add to Favorites now at the dashboard-page level
  • Location support on maps in dashboards
  • Bug fixes

5. Stupid Programming Trick No. 18 — Modifying the Period dimension in Planning

Cameron Lackpour says, “What you will see is how to manipulate custom periods in a Planning Period dimension to get quarter totals.  I will also show how custom Period members outside of YearTotal.”

Read on!

6. How to report on two datasets across different database in OBIEE

Bojie talks about the feature in OBIEE that allows cross db reporting.  He talks us clearly through how to do it, complete with screenshots.

7. ODI Agents

Ram Reddy links to Oracle Data Integrator 12c – Creating a Standalone Agent and Oracle Data Integrator 12c – Creating a Collocated Agent

twitter logoThis week on Twitter

OraNa info tweeted 10 tips for getting started with MAF

Bernard Marr shared The 25 KPIs every manager must know

Doug Correa posted #Kscope14 Video: Ron Dimon

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logo

This week on LinkedIn

Kevin Hsu posted Keeping big data small 

Gerd Aiglstorfer shared Oracle BI Coaching

Daisy Ding linked to An Illustration of Processing Big Text Files with esProc Cursor

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

OBIEE News – Edition of 28th July

Stories from and

Videos such as

Foiling camp finale: “Everyone has a smile on their face”

and What Does Real-World Performance Mean?