Using HBase and Impala to Add Update and Delete Capability to Hive DW Tables, and Improve Query Response Times

One of our customers is looking to offload part of their data warehouse platform to Hadoop, extracting data out of a source system and loading it into Apache Hive tables for subsequent querying using OBIEE11g. One of the challenges that the project faces though is how to handle updates to dimensions (and in their case, fact table records) when HDFS and Hive are typically append-only filesystems; ideally writes to fact tables should only require (more...)

OBIEE 11.1.1.9 Now Enables HiveServer2 and Cloudera Impala Datasources

As you all probably know I’m a big fan of Oracle’s BI and Big Data products, but something I’ve been critical of is OBIEE11g’s lack of support for HiveServer2 connections to Hadoop clusters. OBIEE 11.1.1.7 supported Hive connections using the older HiveServer1 protocol, but recent versions of Cloudera CDH4 and CDH5 use the HiveServer2 protocol by default and OBIEE 11.1.1.7 wouldn’t connect to them; not unless you switched (more...)

What’s New in OBIEE 11.1.1.9 for Systems Administrators and Developers

After over two years since the last major release of OBIEE, Oracle released version 11.1.1.9 in May 2015. You can find the installers here and documentation here. 11.1.1.9 is termed the “terminal release” of the 11g line, and the 12c version is already out in closed-beta. We’d expect to see patchsets for 11g to continue for some time covering bugs and any security issues, but for new functionality in (more...)

New beginning

Happy New Year everyone. I wish you a prosperous 2015!

Time is passing by too fast. I had a dynamic 2014 with a couple of interesting projects. It’s not time to recap now but it is definitely time to refresh my blog.

For me with the new year comes the new beginning too. I switched from contracting to permanent job because I’ve always wanted to work for an Oracle partner in the UK with big (more...)

OBIEE automatic redirect to a Dashboard via mod_rewrite

Normally end users would like to have a simple URL access for Oracle Business Intelligence Enterprise Edition (OBIEE) 11g like http://webhost:7777 and than to be automatically redirected to their Dashboard, instead of typing endless complex URL's.

Assuming you have following standard implementation of an OBIEE environment which contains an Oracle HTTP Server (OHS) configured with mod_wl_ohs to be proxied to point to your WebLogic Server hosting OBIEE and an OBIEE Server, you can simply use (more...)

Purging corrupted OBIEE web catalog users

Sometimes it can happen that user profiles within a web catalog become corrupted for any number of reasons. In order for these user profiles to be correctly re-initialized, there's more to be done than just drop /users/JohnDoe from the web catalog.

All in all there are three distinct places which need to be cleaned:
  • /users/JohnDoe
  • /system/users/123456
  • /system/acocuntids/987654
This is really important since especially the third place contains the translation between the userid and the effective (more...)

Working around opatch – Prerequisite check "CheckSystemSpace" failed.

I recently ran into the situation where the primary mount for a Linux tech account running an OBI install was just way too small to get OBIEE 11.1.1.7.140114 through.
Prerequisite check "CheckSystemSpace" failed.
The details are:
Required amount of space(17499.766MB) is not available.
So with a bit of hacking I got around it by displacing the ./patch_storage directory and forcing opatch to stop doing a file system check (basically no (more...)

How-To: File hunt for OBIEE GUI changes

Among the questions I receive and that frequently come up on OTN, treated in blog posts etc. are questions pertaining to: How do I change a part of the GUI of OBIEE? Now in this post you'll find the answer to that specific question, but the point here today isn't simply to say "do X in Y", but rather "how do you get to know that you need to change X in Y?".

Excel VS BI in Financial Analysis: why the fight was over before it started

by Victor Fagundo

The argument over why Businesses should abandon Excel in favor of more structured tools has been raging for as long as I have had more than a casual exposure to Oracle products. From the standpoint of an IT user Excel appears to be a simplistic, flat-file-based, error-prone (more...)

Conditional Formatting of Calculated Items in OBIEE 11g

By Victor Fagundo

Calculated items in OBIEE Pivot tables can be very useful in certain reporting circumstances, either for ease of development, or to meet specific report requirements. While calculated items in OBIEE are easy, and flexible, they do have one important drawback: they take on the data and display (more...)

Business Intelligence Enterprise Edition & Applications

Not too long ago Oracle released Oracle Business Intelligence Enterprise Edition (OBIEE – 11.1.1.7.0) and Oracle Business Intelligence Applications (OBIA – 11.1.1.7.1) on version 11g. As you might know, OBIA is basicly an addition to the OBIEE where you get

Continue reading

How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment

This MOS Note will help consultants to find the exact Version and Patch level for installed components. This is very useful when you are logging an Oracle Service Request.  

 

OBIA: How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment? [ID 1519745.1]


Fun with Date Math

Uncategorized
| Feb 10, 2013
(First off, sorry Mike, I'm hoping this will break my writer's block...)

On Friday I was asked to look at a report that wasn't returning all of the data. Sample:
Year/Month  Total Sales Total Sales (YAGO)
------------------------------------------
01/31/2013 $1,000,000 $900,000
03/31/2013 $950,000
For reference, YAGO is "Year Ago."

Notice anything funny there?

Yeah, February is missing. The (OBIEE) report has a filter on Jan, Feb and Mar of 2013. But it wasn't showing up. I confirmed via manual SQL (hah!) that there was (YAGO) data in there for February. Any ideas?

I immediately suspected one of two (more...)

A chart is worth a thousand words – only when it’s used appropriately (Part 2)

Charts are informative and widely adopted in Business Intelligence. However, sometime they are misused and generates no business insights but confusion. In my last post, we've discussed about Line Chart and Pie Chart. Today let's continue the same topic by examining map, gauge and Trellis.

Map Chart

Maps have been used to visualize information since the early phase of human civilization. Now in the recent years, thanks to the digitalization of maps more and more quantitative analysis of location related information can be performed on top of map. Furthermore, with powerful spatial systems such as Oracle Spatial, the business (more...)

A chart is worth a thousand words – only when it’s used appropriately (Part 1)

People love charts and graphs. They are intuitive, less intimidating (compare with big fat spreadsheet) and more informative. However, every now and then, I've seen people force data into unsuitable charts, not for revealing business insight purpose but for just having some color and graph on their BI reports. In those cases charts provide no value add but duplication or confusion, in terms of analysis. In this post, I will examine a few OBIEE chart types which I believe are important but sometime not used in the most appropriate way by end users.

Line Chart

Lines work better than any other means to make (more...)

OBIEE install avoid RTD license problems

If you are not going to use RTD (Real Time Decisions) uncheck the box during installation:

image

This avoids extremely difficult discussions with Oracle over the license fee.

Till Next Time

OBIEE 11116 repository on MS-SQL I

We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.

1. Create a repository database:

We called ours “Repositories” Winking smile

image

2. Enable case-sensitive collation

ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS

3. Enable Row versioning

ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON

 

4. Allow TCP/IP access to the database:

image

(Bounce the service if you changed it!)

4b. If you have a firewall running check if the ms-sql port is open (1433 for a default instance)

5. Create a user (fi: REP_OWN)

image

6. make  the default database repositories:

image

7. Set (more...)

OBIEE 11.1.1.6 is out!

If you have missed it:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html ==> 11.1.1.6.0 is out
See the nice new features:
http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/whatsnew.htm#CJAEEGJH

Till Next Time

OBIEE in hebrew

Boris has set up an OBIEE blog in hebrew: http://obiee.co.il/.
Translatesd : http://translate.google.com/translate?sl=iw&tl=en&js=n&prev=_t&hl=en&ie=UTF-8&layout=2&eotf=1&u=http://iloug.org.il/BI/ 

For those of you who also have a non english OBIEE blog feel free to sent me a link and I will gladly advertise it here.

Till Next Time

OBIEE11g FireFox 10 problems

For those of you having problems with the new FireFox 10 client. Michal Novy posted a solution on Christians Blog:

Hi, I found the way how to do a workaround:
1. type "about:config" into an address bar
2. right click anywhere and choose New / String
3. name it "general.useragent.override"
4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0"
5. refresh OBIEE login screen
Then it works without any problems!

Seems that Oracle is already working on some patches: see patch # 13564003 released by Oracle Support which repairs this limitation.

Till Next Time