OBIEE Integration with Salesforce.com – Intro

I am planning to write about OBIEE and Salesforce integration in the coming weeks. There will be a few parts to it. I do hope there will be some interest in this area.

Turning this

SFDC_Campaign

in to this

OBIEE_Campaign

Real time reporting for SFDC is great as OBIEE can create great visuals and management may not even be using SFDC too often. Filtering in OBIEE is a lot easier too!

 

  1. Part 1 Setting Up SFDC
  2. Part 2 Setting Up ODBC Driver
  3. Part 3 Creating Your First Answers (Analysis) Report
  4. Part 4 Embed OBIEE to SFDC

OBIEE 11.1.1.7.150714 Patch Released

So I previously said that the last release which was 11.1.1.7.150120 was supposed to be the last patch for OBIEE. However, on the day of Pluto Fly By, Oracle released 11.1.1.7.150714. Oracle only states that this patch only fixes a major bug for Oracle Business Intelligence Third Party with bug number 20247002. I searched for this bug and could not find relevant information.

If you are stable on 11.1.1.7.150714, then I would probably not patch to this version. For more information on Oracle Support page, you can go here.

Did You Know? OBIEE Dashboard Excel Export Characteristics

There are currently 4 different Excel export options in OBIEE Dashboard. But did you know they all have different characteristics?

In 11.1.1.7.150120, we have the following options:

1. Export Current Dashboard

2. Export Entire Dashboard

Dashboard_Export_Options_1

3. Export Answer Excel 2003 (Using Dashboard Report Links)

4. Export Answer Excel 2007+ (Using Dashboard Report Links)

Dashboard_Export_Options_2

The following table will show what is supported.

Continue reading “Did You Know? OBIEE Dashboard Excel Export Characteristics”

Demystifying OBIEE Essbase Date Measure – The Solution

About the mystery

One of my readers, Saptarshi, asked an excellent question. Original post here: http://mondaybi.com/2014/08/07/an-essbase-obiee-integration-walk-through-with-tips-and-tricks/

He asked:

I am integrating Essbase and OBIEE. I have few measures (accounts) as date in Essbase, such as Receipt Date etc.

Now when I fetch this in OBIEE, they appear as numbers.

How to get date measures from Essbase to OBIEE exactly the way they are sitting in Essbase?

And he’s right! They do appear as numbers. So I Googled and see how frequent this question is asked and if there were already answers I can refer him to. This is what I got!

OBIEE_Essbase_Date_Google_Results

 

Opps, just questions, no answers! Questions like this comes in every few years. Saptarshi actually also posted in Oracle Community too, 16 hours ago! Good job Google! As promised last night, I’m going to demystify and give you a solution to this! In return, just like my Facebook page which was just launched yesterday! Click here!

Continue reading “Demystifying OBIEE Essbase Date Measure – The Solution”

OBIEE 11.1.1.9 Features that makes you upgrade today!

You get what you want! Oracle is listening!

To download 11.1.1.9 click here! Also like to take this chance to congratulate KScope15 which I’m missing out this year! Hopefully Chicago KScope16 will be easier for me to get to. Remember to pay a visit to BITeamwork and being able to Collaborate in OBIEE is really a great feature!

It’s been a long while since I’ve been properly writing. A list of 11.1.1.9 features you will start using today! I will go through these features individually. Feeling excited!!!

  1. HTML5 (New Charting Engine) 
  2. SmartView (Best Office Integration)
  3. Treemap (New Graphics)
  4. Prompt before Opening Dashboard (Delay Execution)
  5. Save Column As (Saving Custom Column)
  6. Global Variable (Saving variables or custom formula)
  7. Subject Area Search (Searching in Subject Area)
  8. Custom Image Upload
OBIEE 11.1.1.9 New Visuals
OBIEE 11.1.1.9 New Visuals

Continue reading “OBIEE 11.1.1.9 Features that makes you upgrade today!”

Oracle Tech Article – Taking Your OBIEE to the Next Level with SmartView VBA 11.1.1.7.1

Taking Your OBIEE to the Next Level with SmartView VBA is meant to be for end users. Yes, it may sound techy, but with the help of macro recorders and Google it’s actually not that difficult after all. Thank you Oracle and OTN for publishing my article!!! And a special thank you to Bob Rhubart for making this happen!!!