Got2Be-Hyperion: februari 2013

zaterdag 16 februari 2013

Error connecting to database connection : Class not registered

Ever wondered why you get a ‘Class not registered’ when you are adding a database connection within workspace in release 11.1.2.2?

Well here is the deal: In 11.1.2.2 the HFM client is altered, and you cannot configure the DCOM user. So instead of configuring it within the client you now have to do it in the Oracle EPM itself.
• First: stop all Oracle EPM processes (stop the complete EPM suite)
• Second: install the ‘HFM Adm Driver’ if you didn’t already.
• Third: configure the DCOM in the ‘EPM Sytem Configurator’.
• Fourth: Start Oracle EPM again.

Now you could go to the workspace and add a database connection to the Financial Management.

zaterdag 9 februari 2013

Change the default Oracle HTTP server page

When you are installing Oracle EPM with an Oracle HTTP server you will see the next page.

This is the default page of the Oracle HTTP server (OHS). Several of our customers do not want to see this and asking me to change this to the default login page.

Below are the steps to change this:

1.      Login the foundation server (web server).
2.      Create a backup of the file:
$EPM_ORACLE_HOME\EPMsystem1\httpConfig\ohs\config\OHS\ohs_component\htdocs\welcome-index.html.
3.      Edit the file and remove everything that is inside the file and replace it with:

<html><head>
   <title>Oracle EPM 11.1.2.x</title>
         <meta http-equiv="refresh" content="0; url=http://the.url.to.your.epm.server:19000/workspace/index.jsp">
   </head>
     <body>
         <p>
         Click to goto the Oracle EPM workspace: <a href=" http://the.url.to.your.epm.server:19000/workspace/index.jsp"> http://the.url.to.your.epm.server:19000/workspace/index.jsp</a>
         </p>
     </body></html>

4.      Save the file and go to the page in your web browser. If it doesn’t work please force a refresh and/or clean your temp internet files and try it again