Oracle issued their quarterly Critical Patch Update yesterday, and with it notice of several security issues of note:
- The most serious for OBIEE (CVE-2013-2186) rates 7.5 (out of 10) on the CVSS scale, affecting the OBIEE Security Platform on both 188.8.131.52 and 184.108.40.206. The access vector is by the network, there’s no authentication required, and it can partially affect confidentiality, integrity, and availability.
A few days ago Oracle released the latest version of the Virtual Machine for OBIEE SampleApp. The current version has a number of new features and new product versions (see below).
To get this latest version go to the following link to download the VM files and to install. As always this is a beast of a VM and you should only consider the install and setup if you have the space and in particular (more...)
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...)
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...)
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 220.127.116.11.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?".
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 – 18.104.22.168.0) and Oracle Business Intelligence Applications (OBIA – 22.214.171.124.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...)
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 [...]
If you are not going to use RTD (Real Time Decisions) uncheck the box during installation:
This avoids extremely difficult discussions with Oracle over the license fee.
Till Next Time
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”
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:
(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)
6. make the default database repositories:
7. Set (more...)
If you have missed it:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html ==> 126.96.36.199.0 is out
See the nice new features:
Till Next Time
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
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
Seems that Oracle is using there own standard for the Date Time format in the BIP quartz scheduler. They are not using standard ticks (starting on 1-jan-0001) but a milliseconds count starting on 1-jan-1970. So 1-Jan-2012 = 1325376000000. IE: a whole day is 86400000 ticks.
Till Next Time
A client asked me if I could create an auto suggest prompt for him. (ie: Google Style Prompt). Basically he wanted an edit box prompt which would fill an suggestion box which he could tab trough to make the right selection.
1. Download the jQuery UI package here. Install it in your b_mozilla directory’s (or other webserver dirs you use).
2. Download (more...)