Hyperionized: November 2014

Wednesday, November 26, 2014

Changing Hyperion Planning Default RMI Port 11333

Author: Sanjay Purohit
Audience: Hyperion Solution Architects and Hyperion Planning Database Administrator

Hyperion web services have default port no and listing ports rang. I try to use default port in my installation whenever possible. The default ports are always easy to remember. But In some cases you have to change the default port no.

Goal

Changing the default RMI port no from 11333 to any other port. There are many articles on meta-link (Oracle support) but most of them are old and poorly written. None of Oracle knowledge document worked for me when I had to change the port no. Changing default RMI port requires following steps.

· HyperionRMI_Port.properties:- Change the value to new desired port. The default location of this file is EPMSystem11R1/common/RMI/11.1.2.0/HyperionRMI_Port.properties

· COMMON_RMI_PORT:- You will need to add new Planning system property on workspace by going Administration>Application>Property. This property should update the HSPSYS_PROPERTIES database.

· The third step is to modify the RMI.properties so start scripts can pick up right port :- The default location of this file is user_projects/epmsystem1/config/starter/RMI.properties

· The last step is to modify the RMI.properties :- The default location of this file is

Middleware/user_projects/epmsystem1/RMI/HyperionRMIRegistry

· Restart Planning, RMI, EAS and Calc Manager to run RMI on new port no.

Related Oracle Knowledge Article.

· How to Change Hyperion RMI default port [11333] in Linux (Doc ID 1276021.1)

· How to reconfigure or change the default planning ports in EPM 11.1.1.x (Doc ID 873963.1)

Please note:- This was tested with EPM - 11.1.2.3

Wednesday, November 12, 2014

Deleting Smartlist Entry from Hyperion Planning

Author: Sanjay Purohit

Audience: Hyperion Solution Architects and Hyperion Planning Database Administrator

In the tradition Planning world dimension/member intersection are used to store the data and most of us know that Hyperion Planning also provides a drop down feature called Smartlist to capture the data. But this feature comes with few limitations such as:-

Security Assignment: - The security cannot be assigned to Smartlists.

Data Export: - The Smartlists are saved on Hyperion Planning sachem and numeric values are pushed to Essbase. Users can get only numerical values in Essbase if data is exported from Essbase.

Goal

Creating and loading Smartlists is an easy task but deleting them requires lots of manual efforts. Let’s assume a case where you load 1000 entries to a Smartlist but later we decide to use only 400 and we need to delete 600 of them. You are only left with two choices either delete them manually one by one or delete the Smartlist itself. Let’s how we can delete Smartlist entries.

We have created a csv file and will load the Smartlist from workspace:-

· The Smartlist load is hidden under the New Dimension. Select New Dimension and then Dimension Type Smart List.

· The smart list is loaded after running the file.

· Now we will load the below given file to delete the Smartlist entries.

· After loading this file. All the entries are removed from Smartlist except one.