Hyperion 11.1.2.4 finally released

Oracle finally released Hyperion 11.1.2.4 release on the OTN site.

http://www.oracle.com/technetwork/middleware/epm/downloads/index.html

After installing HFM 11.1.2.1.x Client, Manage Metadata doesn’t work

Issue:

Blank screen comes up when trying to access Manage Metadata after installing the HFM client.

Solution:

1. Go to command prompt

   Start > Run > Type cmd

2. Change directory to %Hyperion_Home%\product\FinancialManagement\Client\

   (Hyperion_Home = C:\Oracle\Middleware\EPMSystem11R1\)

3. Type “regsvr32.exe HsvDimensionEditorSnapin.dll” (exclude the quotes)
4. Check HFM Client again, it should be working now.

CONFIGURATION FOR ESSMSH AND ESSCMD CLIENT TO RUN FROM CMD PROMPT

By default, the Essbase Clients (MaxL and ESSCMD) will only work if a batch script is executed that will set the Environment Variables correctly. The installer no longer adds these Environment Variables to the System or User variables on the Windows workstation/server.

This was performed on all servers to allow the Essbase clients to be executed from any command prompt.

• Go to the Start Menu and navigate to the Maxl Client shortcut. Right-click and select ‘Edit’ to open the batch file.
  

• This file shows the Environment Variables that need to be set to allow the Essbase Client to function from any command prompt.
  

• Add ARBORPATH as a System Variable – the value is the same as the ESSBASEPATH value in the above script.
  

• Create ESSBASEPATH as a System Variable with the same value.
  

• There is not a screen shot for the next step.
  
  • Edit the existing PATH environment variable. Make the following changes:
    
    • Add to the front of the value (this MUST be the first path listed)
      
      • D:\Oracle\Middleware\EPMSystem11R1\bin;
        
    • Add to the end of the value
      
      • ;D:\Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0; D:\Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin
        

NOTE: Close the prior cmd prompt and start again to test if essmsh and esscmd works

Latest Patch for Oracle Hyperion EPM info

Latest information related to latest patches for Oracle Hyperion EPM products can be found in this KM article.

Available Patch Sets and Patch Set Updates for Oracle Hyperion Enterprise Performance Management Products [ID 1400559.1]

Performance Comparative between IE8 vs Firefox 16 in Hyperion Environment

Objective

To test the IE8 and Firefox 16 performance for Hyperion.

 

Env

Windows 2008 SP1 64bit server and windows 7 64bit, Tools for analysis: Fiddler

 

Process

4 samples were taken in both the browsers. Samples were identical; every time fresh session of browser was opened.

http://localhost:19000/workspace/index.jsp was called in the browser URL and login was made using admin username and password.

 

Scenario

1. First run sample was taken after clearing the web cache in the browser.
2. Second run sample already had web cache generated after first run.
3. GZIP encoding (compression) was applied in the third run in which web cache was already present.
4. GZIP encoding (compression) was applied after clearing the web cache.

 

Summary of Test Results

 

Firefox	IE8
1st Run with no compression and no web cache
3,443,686 bytes	3,474,993 bytes
2nd Run with no compression and web cache
373,172 bytes	3,470,427 bytes
3rd Run with compression and web cache
340,417 bytes	1,017,116 bytes
4th Run with compression and no web cache
1,020,786	1,021,594

 

Total duration of the time for one sample can be seen against “Sequence (clock) duration” parameter.

But I have not included as entering the login information was manual and it must be different in every run.

 

Firefox has better caching mechanism than IE, and it is faster than IE8

 

1^st run in Firefox

 

Request Count: 168

Bytes Sent: 143,650        (headers:140,112; body:3,538)

Bytes Received: 3,443,686        (headers:66,285; body:3,377,401)

 

ACTUAL PERFORMANCE

————–

Requests started at:        14:48:31.332

Responses completed at:    14:48:46.556

Sequence (clock) duration:    00:00:15.2240000

Aggregate Session duration:    00:00:05.710

 

RESPONSE CODES

————–

HTTP/200:     159

HTTP/404:     9

 

RESPONSE BYTES (by Content-Type)

————–

application/x-javascript:    2,576,538

text/css:    289,141

text/xml:    256,825

image/gif:    104,025

text/x-json:    76,981

~headers~:    66,285

application/x-json:    41,463

text/html:    12,377

image/png:    9,075

text/javascript:    6,826

image/x-icon:    4,150

 

 

 

 

2^nd run in Firefox

 

 

Request Count: 21

Bytes Sent: 20,058        (headers:16,528; body:3,530)

Bytes Received: 373,172        (headers:9,771; body:363,401)

 

ACTUAL PERFORMANCE

————–

Requests started at:        14:52:38.367

Responses completed at:    14:52:45.684

Sequence (clock) duration:    00:00:07.3170000

Aggregate Session duration:    00:00:02.256

 

RESPONSE CODES

————–

HTTP/200:     12

HTTP/404:     9

 

RESPONSE BYTES (by Content-Type)

————–

text/xml:    225,754

text/x-json:    76,981

application/x-json:    41,463

text/html:    12,377

~headers~:    9,771

text/javascript:    6,826

 

 

 

3rd run in Firefox with GZIP encoding (compression)

 

 

Request Count: 22

Bytes Sent: 20,670        (headers:17,204; body:3,466)

Bytes Received: 340,417        (headers:10,472; body:329,945)

 

ACTUAL PERFORMANCE

————–

Requests started at:        14:54:19.793

Responses completed at:    14:54:29.999

Sequence (clock) duration:    00:00:10.2060000

Aggregate Session duration:    00:00:02.136

 

RESPONSE CODES

————–

HTTP/200:     13

HTTP/404:     9

 

RESPONSE BYTES (by Content-Type)

————–

text/xml:    205,492

text/x-json:    76,981

application/x-json:    41,463

~headers~:    10,472

text/html:    4,777

text/javascript:    647

image/gif:    585

 

 

 

 

4^th run in Firefox with GZIP encoding (compression) after clearing the browser cache

 

Request Count: 168

Bytes Sent: 143,454        (headers:139,916; body:3,538)

Bytes Received: 1,020,786        (headers:67,436; body:953,350)

 

ACTUAL PERFORMANCE

————–

Requests started at:        14:57:12.580

Responses completed at:    14:57:26.024

Sequence (clock) duration:    00:00:13.4445000

Aggregate Session duration:    00:00:04.394

 

RESPONSE CODES

————–

HTTP/200:     158

HTTP/404:     9

HTTP/302:     1

 

RESPONSE BYTES (by Content-Type)

————–

application/x-javascript:    474,963

text/xml:    209,143

image/gif:    104,045

text/x-json:    76,941

~headers~:    67,436

application/x-json:    41,445

text/css:    31,020

image/png:    6,219

text/html:    4,777

image/x-icon:    4,150

text/javascript:    647

 

 

 

 

1^st run in IE 8

 

 

Request Count: 165

Bytes Sent: 150,281        (headers:146,743; body:3,538)

Bytes Received: 3,474,993        (headers:65,112; body:3,409,881)

 

ACTUAL PERFORMANCE

————–

Requests started at:        15:00:22.001

Responses completed at:    15:00:34.078

Sequence (clock) duration:    00:00:12.0770000

Aggregate Session duration:    00:00:05.262

TCP/IP Connect duration:    2ms

 

RESPONSE CODES

————–

HTTP/200:     156

HTTP/404:     9

 

RESPONSE BYTES (by Content-Type)

————–

application/x-javascript:    2,619,205

text/css:    289,141

text/xml:    256,834

image/gif:    103,869

text/x-json:    76,936

~headers~:    65,112

application/x-json:    34,324

text/html:    12,377

text/javascript:    6,826

image/png:    6,219

image/x-icon:    4,150

 

 

 

2^nd run in IE 8

 

 

Request Count: 164

Bytes Sent: 149,650        (headers:146,136; body:3,514)

Bytes Received: 3,470,427        (headers:64,713; body:3,405,714)

 

ACTUAL PERFORMANCE

————–

Requests started at:        15:02:24.960

Responses completed at:    15:02:33.773

Sequence (clock) duration:    00:00:08.8130000

Aggregate Session duration:    00:00:04.953

 

RESPONSE CODES

————–

HTTP/200:     155

HTTP/404:     9

 

RESPONSE BYTES (by Content-Type)

————–

application/x-javascript:    2,619,205

text/css:    289,141

text/xml:    256,810

image/gif:    103,869

text/x-json:    76,945

~headers~:    64,713

application/x-json:    34,322

text/html:    12,377

text/javascript:    6,826

image/png:    6,219

 

 

 

 

3^rd run in IE 8 with GZIP compression

 

 

Request Count: 165

Bytes Sent: 150,436        (headers:146,914; body:3,522)

Bytes Received: 1,017,116        (headers:66,503; body:950,613)

 

ACTUAL PERFORMANCE

————–

Requests started at:        15:05:06.431

Responses completed at:    15:05:17.446

Sequence (clock) duration:    00:00:11.0155000

Aggregate Session duration:    00:00:06.328

TCP/IP Connect duration:    1ms

 

RESPONSE CODES

————–

HTTP/200:     156

HTTP/404:     9

 

RESPONSE BYTES (by Content-Type)

————–

application/x-javascript:    483,530

text/xml:    209,163

image/gif:    103,957

text/x-json:    76,981

~headers~:    66,503

application/x-json:    34,319

text/css:    31,020

image/png:    6,219

text/html:    4,777

text/javascript:    647

 

 

 

4^th run in IE8 with GZIP encoding (compression) after clearing the browser cache

 

Request Count: 166

Bytes Sent: 151,013        (headers:147,467; body:3,546)

Bytes Received: 1,021,594        (headers:66,902; body:954,692)

 

ACTUAL PERFORMANCE

————–

Requests started at:        15:07:59.416

Responses completed at:    15:08:09.840

Sequence (clock) duration:    00:00:10.4245000

Aggregate Session duration:    00:00:05.517

 

RESPONSE CODES

————–

HTTP/200:     157

HTTP/404:     9

 

RESPONSE BYTES (by Content-Type)

————–

application/x-javascript:    483,530

text/xml:    209,155

image/gif:    103,937

text/x-json:    76,929

~headers~:    66,902

application/x-json:    34,328

text/css:    31,020

image/png:    6,219

text/html:    4,777

image/x-icon:    4,150

text/javascript:    647

 

 

Steps to increase number of Financial Report print server

1. Stop FR Print Services
2. Go to Control Panel\Hardware\Devices and Printers
3. Check HRPrinter1 property

 

1. Check the location of the port

 

1. Match location of the port with the parameter in the HRCreatePrinters.ini file.

 

 

 

1. Change StopNum = 20 in the HRCreatePrinters.ini file
2. Open cmd prompt

Goto following location and run HRCreatePrinters.exe

D:\Oracle\FinancialReportingStudio\products\financialreporting\bin>HRCreatePrinters.exe

 

Restart the FR PrintService service.

Opening Hyperion Workspace link in Firefox

Env: Windows 7, Firefox 15.0.1

When I was trying to open workspace in the Firefox the other day, there was a blank screen like below. It needs one-time setup which takes about 5 mins.

 

Step 1: Open Firefox and go to https://addons.mozilla.org/en-US/firefox/addon/remote-xul-manager/

 

 

 

Step 2: Click on + Add to Firefox

 

After installation it prompts for browser restart.

 

 

 

 

 

 

 

 

 

 

 

Reference: Using Hyperion Workspace with Recent Firefox Versions [ID 1447453.1]

Enterprise Manager for EPM 11.1.2.0-1 environment

Env: Windows 2008 R2 Server, EPM 11.1.2.1

Enterprise Manager is not deployed in 11.1.2.0 and 11.1.2.1 by default, but it is in 11.1.2.2.

 

Enterprise Manager has not been deployed if you can access

“http://localhost:7001/console” but not http://localhost:7001/em.

 

So if http://<servername>:7001/em is launched, you’ll get 404 error

 

Steps to Deploy EM in the 11.1.2.0 – 1.

 

• Check Weblogic AdminServer if it is running. There are few ways to check if Admin Server is running.
  • Open http://<servername>:7001/console/ ; if you get the login prompt that means the weblogic is running.
  • Run netstat –nab | find “7001”

 

• Stop Weblogic Admin Server:
  • Click on D:\ORCL\MW\user_projects\domains\epmdomain\bin\stopWebLogic.cmd

  

    

Once Weblogic is stopped, launch the config.cmd to install and deploy EM.

• Go to D:\ORCL\MW\wlserver_10.3\common\bin and run config.cmd

 

 

• Select “Extend an existing Weblogic domain”

 

 

• Select the WebLogic domain directory: Oracle > Middleware > user_projects > domains > EPMSystem

 

• Select the “Oracle Enterprise Manager – 11.1.1.0(oracle_common)”

 

• The default values are normally right for ‘Domain location’ and ‘Application location’, so simply click the ‘Next’ button

 

• You might need to replace the Host Name with a fully qualified domain name on the Configure JDBC Data Sources window and then click the ‘Next’ button.

 

 

 

– There should be no need to ‘Select Optional Configurations’ for Enterprise Manager (just click ‘Next’).

• On the ‘Configuration Summary’ page you can confirm the changed configuration settings before they are incorporated into the deployment. Then click the ‘Extend’ button.

 

 

• When the ‘Progress’ bar has reached 100% and the ‘Done’ button is clickable, click ‘Done’. Then start the WebLogic AdminServer via /Oracle/Middleware/user_projects/domains/EPMSystem/bin/startWebLogic.cmd

 

 

 

• Launch Enterprise Manager by http://localhost:7001/em

 

 

Ensure EPM is up:

/Oracle/Middleware/user_projects/epmsystem1/bin/start. bat

 

Changing the Planning application owner in the backend

Issue: Unable to register as admin didn’t existed for the application or it wasn’t the owner of the application.

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

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):

Log into the Planning application with the application owner
Administration > Application Settings
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.

Look at the contents of the HSP_USERS table. The owner has a ROLE value of 3. Ordinary administrators have a ROLE of 0.
Make a note of the USER_ID of the user with a ROLE of 3
Look in the HSP_OBJECT table for a record with an OBJECT_ID that matches the USER_ID recorded in the previous step
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.

Note: Before making any manual changes to the relational repository please ensure that

SELECT
A.OBJECT_NAME AS APPLICATION_OWNER
FROM HSP_OBJECT A, HSP_USERS B
WHERE
A.OBJECT_ID = B.USER_ID AND B.ROLE = 3;

Go to the HSP_USERS Table and look for USER_ID = 50001 with Role = 3

Changing the Owner

Change the SID to “native://DN=cn=911,ou=People,dc=css,dc=hyperion,dc=com?USER” for native “admin” user or “ldap://CN=mnath?USER”
for ldap user.

and then go to HSP_OBJECT Table change the OBJECT_NAME with OBJECT_ID = 50001

NOTE: Commit the changes

Restart Planning

Migrating Planning application from One ENV to Other using schema

ENV: 2008 R2 server, Oracle 10g, EPM 11.1.2.1

 

Few days ago I ran into an issue where I can’t use LCM to migrate the planning application in from DEV to TEST. So I migrated the application the old fashioned way, which is by migrating the application schema.

 

Below are the steps:

 

1. Backup the schema in Source/Destination Env
2. Stop planning services Destination Env
3. Drop/recreate the schema in Destination Env
4. Import the schema from the Source Env
5. Start back planning services Destination Env
6. Ask Application owner to login in workspace and refresh the database.