OBIEE Installing Windows Services

Preliminaries When installed out-of-the-box, OBIEE must be started manually each time the server starts, via a shortcut in the Oracle BI program menu group. The instructions in this document will set up windows services that will start automatically when the server starts. Two of these services are already installed out-of-the-box and we will be creating…

Read More

Running batch files from the Oracle EPM Workspace

Have you ever had the need to run a batch process to update EPM applications but can’t get access to the server?  Now you can set up a process to call a batch file to run from the EPM Workspace.  This post walks through a simple example. Create a batch file that calls another batch…

Read More

OBIEE 11g SQL Server Invalid Syntax

OBIEE 11g Invalid Syntax Error When Connecting to SQL Server I recently ran across this issue when I was connecting an OBIEE connection pool to a MS SQL database. I was receiving the following errors when I ran reports. Additionally when trying to update row count in the OBIEE Admin tool, an error dialog appears…

Read More

OBIEE 11G: Managing Presentation Cache Settings

When users run analyses, Presentation Services can cache the results of those analyses. Presentation Services determines if subsequent analyses can use cached results. If the cache can be shared, then subsequent analyses are not stored. These cache files are store in the following directory: ORACLE_INSTANCE\tmp\OracleBIPresentationServices\coreapplication_obipsn\obis_temp. After a clean restart of the presentation services these temporary…

Read More

OBIEE 11g Backup and Recovery

Here are some ideas on how to create an OBIEE 11g backup environment, in case of a disaster. Full Server Backup One option is to backup the entire server. For instance, you can perform:  a complete backup in a quiet period of activity (normally Sunday) and a incremental backup for the rest of the week…

Read More