Articles by Tom Cockerline

• Planning

  • Create Sample Vision App in Planning

  This article shows how to create the database repository, data source, and Planning application needed for the sample Vision application that ships with Oracle Hyperion Planning.

  • Fixing Planning Forms with Null Formulas After LCM Export

  ** Under Construction ** This article shows how to fix Planning forms that have been corrupted during LCM migration with formula rows getting the literal “null”.

• Essbase

  • Getting Started with the Essbase Java API

  ** Under Construction ** This article shows how to get started using the Essbase Java API.

  • Using MaxL Password Encryption

  ** Under Construction ** This article shows how to use MaxL password encryption.

• Smart View

  • Clean Up URLs in Smart View Options

  This article shows how to eliminate unneeded URLs from the “Shared Connections URL” dropdown box in Smart View options.

• Data Integration

• Oracle RDBMS

  • Create a Planning Application Repository with Oracle DB

  This article shows how to use scripts that can be run from the command line in SQL Developer or SQL *Plus to create a repository in an Oracle database for an Oracle Hyperion Planning application.

  • Check Oracle Tablespace Free Space

  This article shows how to view space utilization statistics for the Oracle tablespaces on your system. Using a command line script you can see how much space has been allocated, how much has been used, and how much is free.

  • Reduce Oracle Datafile Size

  This article shows how to view space utilization statistics for an Oracle tablespace and reduce the size of its datafile if it has a lot of unneeded free space.

• SQL Server

  • Install SQL Server for Use With Hyperion EPM

  ** Under Construction ** This article shows how to install Microsoft SQL Server and choose the install options that work best with Oracle Hyperion EPM.

  • Create a Planning Application Repository with SQL Server

  This article shows how to use scripts that can be run from the command line in SQL Server Management Studio to create a relational repository in a SQL Server database for an Oracle Hyperion Planning application.

  • Create the EPM Repositories for a Sandbox with SQL Server

  This article shows how to create the repositories needed for an Oracle Hyperion EPM sandbox for Planning, using scripts that can be run from the command line in SQL Server Management Studio.

  • Check SQL Server Database Free Space

  This article shows how to view space utilization statistics for the SQL Server databases on your system. Using a command line script you can see how much space has been allocated and how much is free.

  • Reduce SQL Server Database Size

  This article shows how to view space utilization statistics for a SQL Server database and reduce the size of its data file and log file to reclaim unused space if it has been over-allocated.

• Windows

  • Show Hidden Files, Folders, and Drives

  This article shows how to work with hidden folders in Windows by making them unhidden or simply by manually typing them into the Windows Explorer address bar.