I have been blogging about the integration between Oracle eBS and Oracle BI EE. Apart from the integration, there are are few assumptions: Oracle eBS is installed Oracle BI is installed Oracle eBS and Oracle BI are compatible with each other (http vs. https) All necessary Oracle eBS patches are installed R11 check R12 included […]
I’m honoured to have been accepted to speak at this year’s Rittman Mead BI Forum, the sixth year of this expert-level conference that draws some of the best Oracle BI/DW minds together from around the world. It’s running May 8th-9th in Brighton, and May 15-16th in Atlanta, with an optional masterclass from Cloudera’s Lars George the day before the conference itself at each venue.
My first visit to the BI Forum was in 2009 (more...)
Assuming you have set up obi-metrics-agent and collectl as described in my previous post, you have a wealth of data at your disposal for graphing and exploring in Graphite, including:
- OS (CPU, disk, network, memory)
- OBIEE’s metrics
- Metrics about DMS itself
- Carbon (Graphite’s data collector agent) metrics
In this post I’ll show you some of the techniques we can use to put together a simple dashboard.
First off, let’s see how Graphite (more...)
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:
This is really important since especially the third place contains the translation between the userid and the effective (more...)
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 184.108.40.206.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...)
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?".
Who's up for game two
What to do
My wallet's gettin thin
And I just lost my watch last night
Well I gotta problem
Just one answer
Gotta throw it all down
And kiss it goodbye
That was a crazy game of poker
(That was a crazy game (more...)
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...)
Not too long ago Oracle released Oracle Business Intelligence Enterprise Edition (OBIEE – 220.127.116.11.0) and Oracle Business Intelligence Applications (OBIA – 18.104.22.168.1) on version 11g. As you might know, OBIA is basicly an addition to the OBIEE where you get
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]
(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
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...)
I was working on my OBIEE Test Lab
today. Having network issues, because I'm prone to those. I decided to look up The Fat Bloke
as he seems to be the resident expert on all things VirtualBox
. As to my network issues, The Fat Bloke had this great post back in June, which helped me understand how VirtualBox network interfaces work
So, as I said, I was looking for some new articles. I ran across this one, What's New in Oracle VM VirtualBox 4.2?
. There was this section on Groups. I tried it out on mine...it didn't work. (more...)
Since a few months, a new book has appeared in the Oracle Business Intelligence landscape. This is good news for the Oracle BI community because it gives us a new middle of communication and discovery. The book provides a more comprehensive approach that articles or blogs and gives a privileged and direct access with the [...]
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.
Lines work better than any other means to make (more...)