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