How to start OHS in Hyperion/EPM 11.2.x Version

 However, when we try to start Oracle HTTP Server service up to 11.1.2.4 version, we can just go to services and start service. Just right click and start.

But 11.2.x, version is different in starting OHS http server, first we have to Oracle Weblogic http Server in server, then go to below path and execute command using command below:

Path: EPM_ORACLE_INSTANCE\httpConfig\ohs\bin

StartComponent ohs_component

Thanks,

Mady

EPM Integration Agent

 

EPM Agent Installation Steps:

1.       Download EPM Agent from below location:

Go to Navigate -> Application -> Data Exchange

Go to Actions -> Download Agent

Once EPM Agent downloaded, Extract the same in to EPMAgent folder

Once Extract done, go to EPMAgent\bin folder

Open Cmd and Execute below command to create Application Folders

You will get prompt as Create application folders script completed.

2.       Download JDK and install Java.

3.       Setup EPM Integration Agent, follow below steps

Browse to location C:\EPMAgentData\config, Edit agentparams.bat file

Then execute below command to start EPM Integration Agent as shown below

 

Note: To Encrypt password, we can use encrypt utility

Thanks,

Mady

How to start OHS in Hyperion/EPM 11.2.x Version

                 However, when we try to start Oracle HTTP Server service up to 11.1.2.4 version, We can just go to services and start service. Just right click and start.

But 11.2.x, version is different in starting OHS http server, first we have to Oracle Weblogic http Server in server, then go to below path and execute command using command below:

Path : EPM_ORACLE_INSTANCE\httpConfig\ohs\bin

StartComponent ohs_component

Thanks,

Mady

Privacy Policy

 

Website Privacy Policy

Cookies and Web Beacons:

We do use cookies to store information, such as your personal preferences when you visit our site. This could include only showing you a popup once in your visit, or the ability to login to some of our features, such as forums.

We also use third party advertisements on www.telugulolyrics.com to support our site. Some of these advertisers may use technology such as cookies and web beacons when they advertise on our site, which will also send these advertisers (such as Google through the Google AdSense program) information including your IP address, your ISP, the browser you used to visit our site, and in some cases, whether you have Flash installed. This is generally used for geo targeting purposes (showing New York real estate ads to someone in New York, for example) or showing certain ads based on specific sites visited (such as showing cooking ads to someone who frequents cooking sites). 

You can chose to disable or selectively turn off our cookies or third-party cookies in your browser settings, or by managing preferences in programs such as Norton Internet Security. However, this can affect how you are able to interact with our site as well as other websites. This could include the inability to login to services or programs, such as logging into forums or accounts.

Hyperion Planning Migration but Target app name wants different?

     Some times we will get request to migrate Hyperion planning application but wants to import it with new name. We can do that with below steps. This is not oracle recommended method, but we can do this for testing apps.

    Change application name in below files

1. Update application name and data source name in Application definition in below path.

resource/Configuration/Properties/Application Defination.xpad

2. Update application name in import.xml files. change in all import.xml files.

Then zip the folders again and upload to shared services.

While importing, in the popup it should show new application name. We must create data source for new application.

Thanks,

Mady

How to change Planning Application Owner in 11.1.2.4

 Only one user can be the owner of a Planning application. That user has all the ordinary rights of an administrator user, plus the additional rights to delete the application.

The user who created the application originally (or deployed it from EPMA originally) is the initial owner. Only that user can hand over ownership to another administrator user. To hand over the ownership (assuming you know who the owner is):

1. Log into the Planning application with the application owner
2. Administration > Application > Settings
3. At the bottom of this page is a menu that allows the owner to hand over the ownership to any other provisioned administrator for this application. Only the owner can see this menu.

If you do not know who the owner is, the easiest way to determine this is by looking in the Planning application database schema. You can also change ownership directly in the tables, although we recommend that it is changed via the user interface, as above.

1. Before making any manual changes to the relational repository please ensure that you have a working backup of the database.
2. Look at the contents of the HSP_USERS table. The owner has a ROLE value of 3. Ordinary administrators have a ROLE of 0.
3. Make a note of the USER_ID of the user with a ROLE of 3.
4. Look in the HSP_OBJECT table for a record with an OBJECT_ID that matches the USER_ID recorded in the previous step.
5. This record's OBJECT_NAME is the user name of your application owner.

If you want to reset ownership you can change the ROLE of an existing administrator to 3, and set the current owner's role to 0. As above, you will need to look at the HSP_OBJECT table to work out which user corresponds to which USER_ID.

Restart the Planning service after modifying the database in order for the changes to take effect

Reference: How to View or Change a Hyperion Planning Application Owner (Doc ID 1327618.1)

Thanks,

Mady

How to edit or remove SmartView URLs in Excel SmartView

We do have to connect with multiple environments or clients as part of our daily job. 

We may add URLs also in SmartView to connect. But how to remove those URLs if you are overloaded in that place. 

 Follow the below steps to remove list of those URLs. 

 In the below Path, check Properties.xml file. 

C:\Users\\AppData\Roaming\Oracle\SmartView 

Note: Appdata will be hidden folder in every user profile. If you check show hidden files, you can see that folder. Or you can directly above Url with replacing with your username in the Url. 

Open Properties.xml file Two sections will be there. 

One is OverrideWorkspaceURL tab, another one is PreviousUrlList  tag. Override Workspace URL is about URL which will be highlighting in dropdown box, I mean we can see immediately when we open. 

Previous Url List is about Previously used URLs. 

You can remove Previous used URLs in that file and save it. 

Thanks, 

Mady