Using Hyperion LCM 11.1.2.3

If you have been considering upgrading your Hyperion environment to 11.1.2.3, here is another example of improved functionality that may help in making that decision. For those of you that rely on Lifecycle Management for promoting changes to production or just backing up your Oracle Hyperion Applications, Oracle EPMA 11.1.2.3 has additional functionality that makes…

Read More

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, OBIEE 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…

Read More