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.
The selection is defaulted to Connect to previously configured shared service database. Server is Windows 2008R2 64bit. Hyperion installed is v.126.96.36.199 64bit. When you try to log in, the returned message says that the database you connect to isn't preconfigured with shared service.
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.
Wednesday, August 1, 2012
Monday, June 25, 2012
This is a tip for quickly duplicating an existing table.
While this is another tip for quickly creating a table with the same column name of an existing table.
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.