Customizing your DOS prompt

Posted by on December 6, 2012 at 4:30 am

Being back on a windows shop I find the DOS prompt sort of gets in my way, I have customized it so that it will display my current path and then let met type on a new line with this command: PROMPT Ignacio’s rocking at $P$G$_ The different formatting options for the command are: $A […]

Configuring the windows host file to correctly use the loopback adapter for Oracle product installations

Posted by on November 11, 2012 at 1:30 am

This procedure is required when installing Oracle products such at the Oracle Database or Oracle Business Intelligence Enterprise Edition on a host machine that uses DHCP.  Follow the steps to configure a loopback adapterand then: Open the host file under c:\windows\system32\drivers\etc using notepad Identify your computer’s host name by right clicking on My Computer, selecting […]

Verifying the pre-requisites for an Oracle Database Install on SUSE Linux

Posted by on August 10, 2012 at 5:30 am

This is a list of the parameters and configuration settings you should first check when installing the oracle database into a personal/sandbox environments, I made a note of them to allow me to verify them quickly without going through all the documentation for every install. This assumes you will not use ASM on your new […]

Configuring a new loopback adapter in windows

Posted by on May 13, 2012 at 3:30 am

Start > Control Pannel> Add  Hardware Click next on the Welcome screen  When ask if you have connected your hardware, specify yes  In the next dialog select Add new hardware device  On the following screen select Network Adapters  Select Microsoft > Microsoft Loopback Adapter from the list  Select next in the following screen to install […]

How to launch OBIEE Catalog Manager in 11g

Posted by on March 15, 2012 at 3:30 am

In secondary cluster node systems and versions before a shortcut to the OBIEE Catalog Manager was not created by the install utility, when running on a Windows Box you can easily solve this by running the runcat.cmd file on the Catalog Manager Path: <Middleware Home>\instances\instance<Instance Number>\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager An example of the this path on a […]

Issue: WordPress sticky posts always on top instead of being incorporated in the default descending date sort for blog home

Posted by on January 19, 2012 at 6:30 am

I am using WordPress 3.1, I was able to solve this issue by customizing the call to the query_posts() function in my theme’s home.php file. The only customization necessary was adding the ignore_sticky_posts variable at the end of the query string as illustrated below. Current code in my theme: query_posts($category."&paged=$paged&showposts=$number_posts"); Tweaked code: query_posts($category."&paged=$paged&showposts=$number_posts&ignore_sticky_posts=1");

11g Bug: Issue with equality operator on content filters

Posted by on November 21, 2011 at 12:02 pm

I ran into an weird issue yesterday trying to troubleshoot data security for my current gig. What it came down to is the fact that for some reason the equality operator in the expression below wasn’t being resolved correctly by OBI: LOWER( TRIM(“Data Warehouse”.””.”SCHEMA_NAME”.”ALS_BI_SEC_USER_DEPT”.”EMAIL_ADDRESS”)) = ( LOWER( TRIM( VALUEOF(NQ_SESSION.”USER”)))) Even after toying with :USER, applying […]

List of Bug Fixes Included In Oracle BI Publisher

Posted by on October 31, 2011 at 4:14 pm

List of Bug Fixes Included In Oracle BI Publisher following is a list of all bug fixes included in Oracle BI Publisher, grouped by type: Administration (ADMIN) * Bug 9381019 XMLP ROLES NOT HONORED WITH SSO ENABLED FOR AD SYNCHED USERS. * Bug 9934771 UNABLE TO LOGON TO PUBLISHER USING SECURITY MODEL EBS: […]

Linux Environment variables to simplify your life – OBIEE 11g System Administrator Edition

Posted by on April 19, 2011 at 7:18 pm

As I spend a lot of time switching between a very well defined set of directories in the Oracle Middleware home for OBIEE 11g I have been developing a list of variables that I like to use in my scripts and configure in the servers that I most commonly work with. They have proven to […]

OBIEE Repository Reporting

Posted by on December 25, 2010 at 6:00 pm

Extracting lists of OBI repository objects

OBIEE Logical Table vs Logical Table Sources – Best Practice

Posted by on December 15, 2010 at 6:00 pm

The difference between Logical Tables, Logical Table Sources (LTS) and the physical tables that compose a Logical Table Source, here are some basic guidelines that have helped me get this concept to seat more clearly in my mind.

OBIEE 10g Administration – useful linux environment variables

Posted by on November 14, 2010 at 6:00 pm

Create some basic variables in your OBIEEE Linux server

Tip: Getting Unix command output and status in your email

Posted by on October 15, 2010 at 6:00 pm

I have a scheduled script that refreshes some of my materialized views but sometimes these operations could fail if the database backup takes too long or an unexpected condition presents. This led me to think of sending the output of my refresh procedures to my email or my team’s listserv, here are sample versions of my scripts:

Drop [oracle] database (and clean after yourself)

Posted by on June 30, 2010 at 6:00 pm

Clean database and control files after dropping database

Google Webmaster Tools

Posted by on April 12, 2010 at 10:00 am

If you feel like tracking how the rest of the world sees your blog (and I guess we can assume the rest of the world uses Google of course), adding Google Webmaster Tools is a very good idea

Leverage PeopleSoft EPM Data Lineage Spreadsheets

Posted by on February 28, 2010 at 6:00 pm

Not having to do all the leg work necessary to arrive at table-level data lineage in the PeopleSoft EPM Warehouse is a great testimony to good documentation and a great culture back there at big PS….