Over the past couple of months I worked with a few clients in order to conduct an assessment on dashboard and analysis design. In most cases I was noticing that the dashboards were overflowing with content to the point that there was really no discernible “story” or “flow” to the information. Most of the dashboards were an overwhelming hub of large tables, excess dashboard prompts, and complicated charts and graphs. Many times the client complaints (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.
If you pay any attention to the Oracle enterprise applications space, you’re likely aware of the fuss being raised over the impending demise of Oracle Discoverer. Discoverer is a pretty nifty ad hoc reporting tool used for both enterprise (more...)
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 (more...)
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...)