Back to the OBIEE Future

Blogs 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

This week on Twitter