Wednesday, August 1, 2012

Perform 1st-time configuration of Shared Service selection disabled.

If when you run "Oracle EPM System - Foundation Services - EPM System Configurator" for the first time, and you can't select "Perform 1st-time configuration of Shared Service Database", you may see the following solution.

Description:
The selection is defaulted to Connect to previously configured shared service database.  Server is Windows 2008R2 64bit.  Hyperion installed is v.11.1.2.2 64bit.  When you try to log in, the returned message says that the database you connect to isn't preconfigured with shared service.

Solution:
Try running "configtool.bat -forceRegistry".  It should do the trick.  The location of configtool.bat can be found by right clicking on "Oracle EPM System - Foundation Services - EPM System Configurator" from the start menu, and select properties.  The location of configtool.bat is stated on the "Target" field of the properties window.

Monday, June 25, 2012

Quickly Duplicate an Existing Table [SQL Server]


This is a tip for quickly duplicating an existing table.
Select * Into new_table_name From existing_table_name
While this is another tip for quickly creating a table with the same column name of an existing table.
Select * Into new_table_name From existing_table_name Where 1 = 2
Notice the where condition.  You could actually change it to any condition that returned false (e.g 1=0).  The select statement will select nothing.