It’s the Saturday after Oracle Openworld 2014, and I’m now home from San Francisco and back in the UK. It’s been a great week as usual, with lots of product announcements and updates to the BI, DW and Big Data products we use on current projects. Here’s my take on what was announced this last week.
New Products Announced
From a BI and DW perspective, the most significant product announcements were around Hadoop and (more...)
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...)
1 : the act of converging and especially moving toward union or uniformity; especially : coordinated movement of the two eyes so that the image of a single point is formed on corresponding retinal areas
2 : the state or property of being convergent
3 : independent development of similar characters (as of bodily structure of unrelated organisms or cultural traits) often (more...)
All in all there are three distinct places which need to be cleaned:
Prerequisite check "CheckSystemSpace" failed.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...)
The details are:
Required amount of space(17499.766MB) is not available.
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...)
I have finally finished writing my book on Oracle APEX reporting. The book
|Although the book primarily projects Oracle APEX as a reporting solution, it also speaks about the integration of APEX with a number of other technologies such as Apache (more...)|
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.
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)For reference, YAGO is "Year Ago."
01/31/2013 $1,000,000 $900,000
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...)
Line ChartLines work better than any other means to make (more...)
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...)
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html ==> 220.127.116.11.0 is out
See the nice new features:
Till Next Time