Pages

▼
Wednesday, October 29, 2014

BI Publisher reports showing stale data?

›
Oracle has done a great job at integrating BI Publisher (BIP) with OBIEE. However not may folks are aware of the fact, that BI Publisher was...
Tuesday, October 7, 2014

Open World 2014 Customer Appreciation Event

›
I should be blogging about new learning from Open World 2014 :( (I will very soon) Here is a small preview of customer appreciation event...
Wednesday, October 1, 2014

Oracle Openworld 2014

›
Gaining insight at Oracle Open World 2014. Here are few images from the event.
Tuesday, June 10, 2014

How to select last updated transaction for every ID from a history table?

›
Here is the scenario: You have multiple invoices in a table, with one record everytime the Invoice goes through a process, for example Invoi...
Friday, April 4, 2014

Table not found in Database

›
This could be annoying when analyzing databases for available tables in the schema. For quick reference, here is the query that can help loc...
Wednesday, March 26, 2014

OBIEE BI Publisher prompts not visible when added to dashboard page

›
When creating a BI Publisher report from a BIP data model, we can add prompts on the report directly to have interactivity on the report. Th...
2 comments:
Friday, March 21, 2014

Date column showing values 0/0/0 12:00:00 AM in OBIEE 11g

›
Noticed strange appearance of dates in certain cases as below: I checked the database, the date values for these records was null. It appear...