Sunday, August 13, 2017

Enabling SSL with Oracle Data Relationship Management


Launch IIS on Windows server and and select “Server Certificates”

Select Create Certificate Request

Complete the certificate request with the requested information as indicated in the next two slides


Select appropriate provide from the drop down list

And click next. This will send SSL certificate request to network SSL administrator. Admin needs to create SSL certificate and import the server. 

Select “Default Web Site” and then click on Bindings

Select Site Binding Type and SSL certificate and click ok

After importing select highlighted SSL Settings

Check "Require SSL" and Ignore Client Certificates

Go back to Default Web Site and press Restart.  You are done !!  SSL configuration with DRM is complete. 




Five Easy Steps of Creating Custom Hyperion Stop/Start Script on Windows Server


Enterprise Performance Management (EPM) comes with default start and stop scripts. Stopping and starting services is easy task in single server installation. But this task can be tedious in multi node environment.  System admin needs to go to each server and start/stop services. This may lead a need of master start/stop script which can communicate across servers and start/stop services.
By following this blog you should be able to create your own custom EPM start and stop script. I will also demonstrate the use of variables in batch scripts. 

  Open a notepad (I personally prefer notepad ++ or Ultra edit) start typing

Section #1 (descriptive section):- You may write any instructions about the script. This section does not execute any command


  Section #2 (Variable Section):- This section is being used to define variables. I have defined few variables such as
§  ScriptLogDir=C:\Oracle\AutomationFolder\Logs
§  SET ScriptLogFile="%ScriptLogDir%\StartServices.log"
§  SET HypServer_01= Server 1 name
§  SET HypServer_02= Server 2 name
§  SET HypServer_03 = Server 2 name



 Section #3 (Custom Log Location):- I also like to see the logs of my custom script. This section is being used to defined custom log location and back up with data stamp




 Section #4 (Windows Service Name):- I am using windows sc \\servername start "HyS9CALC_epmsystem1" command execute the Hyperion related service. You may also use “net start <service_name>".  SC can remotely login to another Windows server and execute services



Section #4 The final should look like this


Related helpful Url





Required Setting for FDMEE to Work with SSL


  • Please note:- Following setting should be applied in OHS/Foundation Server
  • Please go to following location

o  E:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component
o   Make a back copy of ssl.conf file
o   Shut down OHS server using stopOHS.bat
o   Add following lines in ssl.conf file

include "conf/mod_wl_ohs.conf"
include "conf/epm_online_help.conf"
include "conf/epm_rewrite_rules.conf"
include "conf/epm.conf"

        your file should look like below given images


Wednesday, March 23, 2016

Importing SSL Certification on HFR (Hyperion Financial Report) Client




  • HFR client needs a separate  separate SSL certification to be installed on each client machine if SSL ULR is used.
  • Prerequisite:-Make sure HFR studio is installed in machine
Navigate to:-E:\DEVHYP\Oracle\Middleware\EPMSystem11R1\products\FinancialReportingStudio\common\JRE\Sun\bin
  • Run the following command:-

keytool.exe -import -alias myroothypcert -keystore  "E:\DEVHYP\Oracle\Middleware\EPMSystem11R1\products\FinancialReportingStudio\common\JRE\Sun\lib\security\cacerts" -trustcacerts -file c:\ssl\OHScert.cer -storepass changeit
C:\ssl\OHScert.cer :- make sure you select the location of SSL certification




  • Please follow Oracle KM:-Financial Reporting Error: "You Are Not Authorized To Use This Functionality" When Logging into Studio With SSL Port (Doc ID 1419129.1

Friday, July 24, 2015

How to Publish User Productivity Kit (UPK) Contents via IIS

Author:-Sanjay Purohit
Objective
The purpose of this article is to demonstrate how to publish recorded using Player Package publishing format via IIS

how To                                              
Steps to publish UPK recorded contents:-
·         Select the recorded Module/Selection/Topic.
·         Go to File->Publish
·         Provide the location where you want to store the recording.
·         Select the option whether you want to publish entire outline or selection only.
·         Select appropriate option from publish content wizard.
·         The publishing in progress and you should see the progress.
·         Open IIS
·         Right click on the web site being used (Default Web Site) and select Add Virtual Directory
·         Under Alias, give the virtual directory a name (preferably one word only) and for the Physical Path, navigate to the location of your Player Package folder which you moved to the server
·         Test its access by right-clicking the virtual directory you created and selecting the bottom most option (Switch to Content View)
·         Right click on the Index.html file and select browse


Select the recorded Module/Selection/Topic. 


  Provide the location where you want to store the recording.

 Select the option whether you want to publish entire outline or selection only. 

 Select appropriate option from publish content wizard.

  Publishing progress can be seen here

Go to IIS and right click on the web site being used (Default Web Site) and select Add Virtual Directory

  Under Alias, give the virtual directory a name (preferably one word only) and for the Physical
Path, navigate to the location of your Player Package folder which you moved to the server 
Test its access by right-clicking the virtual directory you created and selecting the bottom most option (Switch to Content View)
 Right click on the Index.html file and select browse



  URL is ready to view online. :- http://samplerecording.com/BudgetUsers/index.html

Important Notes to consider:-Make sure ASP.NET, Basic Authentication  and Windows Authentication are installed in your server. Also ensure the player package folder has the following security
USERS group
NETWORK_SERVICES group
·         I had some issue with security therefore I had to share the folder with everybody


Related URL




UPK: How To Access UPK Published Content from the Intranet? (Doc ID 1904674.1)



Setting up Oracle User Productivity Kit (UPK) Client in Users Machine

Oracle User Productivity Kit (UPK) is a comprehensive content development and maintenance tools. With Oracle UPK, project teams can mitigate risk through all phases of any project lifecycle, dramatically reduce the time to deployment, and ensure end user adoption. Rapidly producing materials tailored for all phases of the software lifecycle - from test scripts, system process documents, and interactive simulations, to job aids, instructor manuals, presentations, and in-application performance support, Oracle User Productivity Kit can reduce overall software implementation and maintenance costs” S- (Oracle)

Objective
The purpose of this article is to demonstrate how to setup the UPK client in local machine before recording

how To                                              

Start UPK client by clicking “UPK Developer Client” and you will be redirected to below given screen and will be asked to setup a profile.

The next screen will be require you to enter the Library Location. Please make sure you are connecting with server installation. UPK requires IIS to be deployed in order to communicate with client machine. The URL should looks like

Click Next (please make sure you are connect to network or using VPN).  The client will try to connect to UPK server via IIS
After connecting to server you will be asked to enter the connection details. Please ask your UPK admin to provide you the login details and enter the login name/password
 After entering the server details you will be asked to select profile name. I am selecting default profile name


That’s all. The UPK is set and you are good to go… Start Recording…………………….

  

Related blogs and URLs

UPK Single user installation.
 https://www.youtube.com/watch?v=qKmZi_7bFHM


Additional Oracle KM
UPK: "The server was unable to process the request due to an internal error" and 'ORA-28001: the password has expired' When Creating a Profile in UPK 12.1 (Doc ID 2008691.1)

UPK: UPK Client Error "Server Unable to Process Request Internal Error" (Doc ID 1967207.


Setting up Oracle User Productivity Kit (UPK) Client in Users Machine

Oracle User Productivity Kit (UPK) is a comprehensive content development and maintenance tools. With Oracle UPK, project teams can mitigate risk through all phases of any project lifecycle, dramatically reduce the time to deployment, and ensure end user adoption. Rapidly producing materials tailored for all phases of the software lifecycle - from test scripts, system process documents, and interactive simulations, to job aids, instructor manuals, presentations, and in-application performance support, Oracle User Productivity Kit can reduce overall software implementation and maintenance costs” S- (Oracle)

Objective
The purpose of this article is to demonstrate how to setup the UPK client in local machine before recording

how To                                              

Start UPK client by clicking “UPK Developer Client” and you will be redirected to below given screen and will be asked to setup a profile.

The next screen will be require you to enter the Library Location. Please make sure you are connecting with server installation. UPK requires IIS to be deployed in order to communicate with client machine. The URL should looks like

Click Next (please make sure you are connect to network or using VPN).  The client will try to connect to UPK server via IIS
After connecting to server you will be asked to enter the connection details. Please ask your UPK admin to provide you the login details and enter the login name/password
 After entering the server details you will be asked to select profile name. I am selecting default profile name


That’s all. The UPK is set and you are good to go… Start Recording…………………….

  

Related blogs and URLs

UPK Single user installation.
 https://www.youtube.com/watch?v=qKmZi_7bFHM


Additional Oracle KM
UPK: "The server was unable to process the request due to an internal error" and 'ORA-28001: the password has expired' When Creating a Profile in UPK 12.1 (Doc ID 2008691.1)

UPK: UPK Client Error "Server Unable to Process Request Internal Error" (Doc ID 1967207.


Tuesday, May 26, 2015

Deleting a dimension from Hyperion Planning application (11.1.2.3)


I have seen few posting online regarding how to delete a dimension from classic planning application. Most of them were tested in system 9. The table structure has changed from 9 to 11 so I tried in 11.1.2.3.500 with “Decision Package Enabled Public Sector Planning and Budgeting Application”. Most of old steps hold true in 11.1.2.3 also. Here are the steps to delete dimension from Planning Application. This steps also applies to pre-build module like Public Sector Planning and Financial Planning application.


1.      Delete all members of the dimension you want to remove (if there are any) 
2.      If security is enabled at dimension level, uncheck that option in the dimension properties 
3.      Refresh the Planning application to Essbase 
4.      Stop the Planning web services.
5.      Edit the relational database for the Planning application concerned 
6.      Find dimension to be removed in the HSP_OBJECT table by running a SQL query: 
SELECT * FROM HSP_OBJECT WHERE (OBJECT_NAME = 'NameOf TheDimension'); 

Write down the OBJECT_ID number of the dimension. Once you find the object make the note of object it. You will need this ID to find in other tables.  (Do not delete the record in the HSP_OBJECT table at this time)
7.      Delete the record with the dimension’s OBJECT_ID in the HSP_UNIQUE_NAMES table 
Make sure this record has been removed from the table. 

Then delete the row matching the dimension’s OBJECT_ID in the following tables, if it is present: 

HSP_MEMBER (MEMBER_ID and DIM_ID should both match the OJBECT_ID) 

HSP_MRU_MEMBERS (DIM_ID should match; this table is present in System 9 only) 

HSP_DIMENSION (DIM_ID should match) 

HSP_OBJECT (delete the row you retrieved earlier when checking the OBJECT_ID) 

HSP_PENDING_XACTS (usually empty, but should be checked) 
8.      Restart Planning service 
9.      Do a Refresh of the Planning application to Essbase 
10.  Clear the browser cookies and log into planning application. The dimension should disappeared.. 
11.  Do another refresh of the Planning application to confirm no errors occur 




Additional reading
How Can We Delete Dimensions In Planning Once The Application Has Been Deployed From EPMA? [ID 1055007.1]


How to delete dimension from Planning Application

Delete Dimension from Planning Application


Note:- Please make sure you have backup  of your environment before to perform above mentioned steps. These steps can be used as a guideline. Author does not hold any responsibility for any damage.