Technical

11g Bug: Issue with equality operator on content filters

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

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 11.1.1.5.0

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

List of Bug Fixes Included In Oracle BI Publisher 11.1.1.5.0The following is a list of all bug fixes included in Oracle BI Publisher 11.1.1.5.0, 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: […]

Troubleshoting Error: unable to get file lock, will retry …

Posted by on July 21, 2011 at 4:00 am
Share

Troubleshooting error BEA-141281 unable to get file lock, will retry …

Fixing device references after importing a Linux guest in Oracle Virtual Box

Posted by on June 9, 2011 at 2:00 pm
Share

After reading this post you should be better prepared to smoothly export and import Linux virtual machines from your Oracle Virtual Box servers by being ready to correct any disk device reference issues in fstab and grub.conf

Default Web Catalog Path in OBIEE 11g

Posted by on June 2, 2011 at 2:01 pm
Share

This post should guide users new to Oracle Business Intelligence Enterprise Edition version 11g familiarize themselves with changes in directory structure and to be able to locate the OBIEE 11g web catalog directory…

Installing the Oracle Business Intelligence 11g (11.1.1.5) Client Tools

Posted by on May 30, 2011 at 8:00 am
Share

Overview This is a brief installation guide for those currently working on their 11.1.1.5 OBIEE installation. Please post commnents if you have any questions or run into issues installing OBIEE 11g, we will try to fix them and can document their resolution for future reference. Pre-requisites Download the installer from OTN to your windows machine […]

Configuring WebLogic Automated Startup Credentials

Posted by on May 26, 2011 at 2:00 pm
Share

After reading this post you should be able to configure the boot.properties file to provide the WebLogic server with startup credentials, a necessary step when configuring the server for automated startup …The WebLogic server does not start automatically, it is prompting for a user name and password    WebLogic not reading boot.properties file

Commentary: Oracle releases OBIEE 11.1.1.5

Posted by on May 10, 2011 at 7:10 pm
Share

Oracle releases native SAP BW BAPI adapter and iPad/iPhone support in release 11.1.1.5 of OBIEE

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

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

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 […]

Materialized View Maintenance – Part I: Guidelines

Posted by on January 15, 2011 at 6:00 pm
Share

I have been working with a lot of materialized views in our PeopleSoft Campus Solutions Warehouse lately and let me tell you, they can be a pain some times. Before I go into technical details here are some best practices that we have developed in our environment for data that is loaded once nightly.

OBIEE Repository Reporting

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

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
Share

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
Share

Create some basic variables in your OBIEEE Linux server

Install a local Subversion server on your windows machine

Posted by on November 7, 2010 at 6:00 pm
Share

I need to test some of Subversion’s functionality without our server admins hating me at work so I decided to build me a local server, I installed the server with the Apache 2.o bindings from SVN’s website and the TortoiseSVN client.

Issues with DB Connection when creating the Informatica Power Center Repository

Posted by on October 22, 2010 at 5:30 pm
Share

“An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”

Tip: Getting Unix command output and status in your email

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

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:

Configure your database to host your Informatica Repository (Oracle 11g)

Posted by on September 16, 2010 at 6:00 pm
Share

The Informatica repository is designed to reside in a database system, for my local test environment I will be hosting it in an Oracle 11g database. Here are two design principles that need to be taken into consideration when setting up the database that will host your repository: Creating a dedicated tablespace for your repository […]

Subversion & TortouseSVN reference found online

Posted by on September 4, 2010 at 6:00 pm
Share

A list of useful reference I’ve found online while trying to setup our DataStage ETL & OBIEE version control environment…

bounce_like_a_tiger.sh

Posted by on August 24, 2010 at 6:00 pm
Share

Since the rest of the team found the name of the script I created to bounce our OBIEE server very comic I decided to share bounce_like_a_tiger.sh with you:

Uninstall Oracle Application Server

Posted by on August 18, 2010 at 6:00 pm
Share

Here’s my latest run on uninstalling Oracle Application Server 10.1.3.0 from a SuSE 10 Enterprise box: Important: Be sure to backup your OAS instance and the OAS repository database before you proceed with these instructions. Run oracle universal installer from the OAS home directory: $ORACLE_HOME/oui/bin/runInstaller Click on “Deinstall products…” and select the oracle home where […]