Hyperion Url's

                                                          Hyperion Url's

Example URLs to Check
EXAMPLE ORACLE EPM 11 (11.1.2.1) ENVIRONMENT CHECKS AND MONITORING

Layer1 – Load Balancer URL Check:
https://LoadBalancerURL.local/hfm
https://LoadBalancerURL.local/aps/APS
https://LoadBalancerURL.local/calcmgr/index.htm
https://LoadBalancerURL.local/raframework/index.jsp
https://LoadBalancerURL.local/easconsole/console.html
https://LoadBalancerURL.local/awb/conf/AwbConfig.xml
https://LoadBalancerURL.local/hr/status.jsp
https://LoadBalancerURL.local/interop/index.jsp
https://LoadBalancerURL.local/hfmofficeprovider/HFMOfficeProvider.aspx
https://LoadBalancerURL.local/hfmlcmservice/LCMWS.asmx
https://LoadBalancerURL.local/workspace/status
https://LoadBalancerURL.local/HyperionFDM/AuthorizedPages/LogonPage.asp
https://LoadBalancerURL.local/hyperion-bpma-server/Applications.asmx
https://LoadBalancerURL.local/DataSync/

Layer2 – Oracle HTTP Server Redirection Check:
http://Foundation1.local:19000/hfm
http://Foundation1.local:19000/aps/APS
http://Foundation1.local:19000/calcmgr/index.htm
http://Foundation1.local:19000/raframework/index.jsp
http://Foundation1.local:19000/easconsole/console.html
http://Foundation1.local:19000/awb/conf/AwbConfig.xml
http://Foundation1.local:19000/hr/status.jsp
http://Foundation1.local:19000/interop/index.jsp
http://Foundation1.local:19000/hfmofficeprovider/HFMOfficeProvider.aspx
http://Foundation1.local:19000/hfmlcmservice/LCMWS.asmx
http://Foundation1.local:19000/workspace/status
http://Foundation1.local:19000/HyperionFDM/AuthorizedPages/LogonPage.asp
http://Foundation1.local:19000/hyperion-bpma-server/Applications.asmx
http://Foundation1.local:19000/DataSync/

Layer3 Individual Web Application Server Check:
FOUNDATION1.LOCAL Web/Web App
http://Foundation1.local:80/HyperionFDM/AuthorizedPages/LogonPage.asp
http://Foundation1.local:80/hfm
http://Foundation1.local:80/hfmapplicationservice/application.asmx
http://Foundation1.local:80/hfmlcmservice/LCMWS.asmx
http://Foundation1.local:80/hfmofficeprovider/HFMOfficeProvider.aspx
http://Foundation1.local:28080/interop/index.jsp
http://Foundation1.local:28080/workspace/status
http://Foundation1.local:45000/raframework/index.jsp
http://Foundation1.local:8200/hr
http://Foundation1.local:8500/calcmgr/index.htm

PLANNING1.LOCAL Planning
http://Planning1.local:8300/HyperionPlanning

EAS1.LOCAL Essbase Tools
http://EAS1.local:10080/eas
http://EAS1.local:13080/aps

EPMA1.LOCAL EPMA
http://EPMA1.local/hyperion-bpma-server/folders.asmx
http://EPMA1.local:19091/awb

Workspace:
Layer1 - LB Device
https://LoadBalancerURL.local/workspace/index.jsp

Layer2 – Oracle HTTP Server
http://Foundation1.local:19000/workspace/index.jsp

Layer3 – WebLogic Web
http://Foundation1.local:28080/workspace/index.jsp

FDM:
Layer1 – LB Device
https://LoadBalancerURL.local/HyperionFDM

Layer2 – Oracle HTTP Server
http://Foundation1.local:19000/HyperionFDM

Layer3 – IIS Web
http://Foundation1.local:80/HyperionFDM


HFM app creation:
http://10.177.17.195:19000/hfm/CreateApp/createapp.asp?iscontained=Yes

Source: http://www.openepm.com/epm-monitoring/example-urls-to-check

Thanks,
Mady

JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer in deployment JRFWSAsyncJmsModule in hyperion 11.1.2.x

It is possible that Hyperion / Weblogic does not start anymore and weblogic or service sysout log pointing to force shutdown

This can have several causes 
• There is a deploy of web server made through the Configuration Tool (extra deployment)
• There is an extra tool installed in the weblogic server

ERROR::

<Critical> <WebLogicServer> <BEA-000362> <Server failed. Reason:
There are 1 nested errors:
Caweblogic.management.ManagementException: [Management:141266]Parsing Failure in config.xml: The following failures occurred:
-- [JMSExceptions:045047]The SubDeploymentMBean JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer in deployment JRFWSAsyncJmsModule
can only be targeted to one JMSServerMBean because an entity that can only be targeted to a single JMS server (for example a queue,
topic or quota) has a sub-deployment-name element with value JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer
at weblogic.management.provider.internal.RuntimeAccessImpl.<init>(RuntimeAccessImpl.java:127)
at weblogic.management.provider.internal.RuntimeAccessService.start(RuntimeAccessService.java:41)
at weblogic.t3.srvr.ServerServicesManager.startService(ServerServicesManager.java:461)
at weblogic.t3.srvr.ServerServicesManager.startInStandbyState(ServerServicesManager.java:166)

Sollution:

Locate the config.xml file in the directory:
D:\Oracle\Middleware\user_projects\domains\EPMSystem\config
(at the Weblogic server (HSS server)) Edit this file and look for the following:

<sub-deployment>
<name>JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer</name>
<target>FMWebServices</target>
</sub-deployment>

Replace it with the following (only the word ‘FMWebServices’ to ‘JRFWSAsyncJmsServer’)

<sub-deployment>
<name>JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer</name>
<target>JRFWSAsyncJmsServer</target>
</sub-deployment>

Try again to start Hyperion.


Thanks,
Mady

Deleting a dimension from Hyperion Planning application 11.x

                     Deleting a dimension from Hyperion Planning application 11.x

To delete dimension from Hyperion Planning application, we can follow the below steps:

John goodwin suggested in OTN like below, one of the simplest way to delete dimension::

You are really not meant to delete a dimension, if possible recreate the application without the dimension.
If you want to take the risk and delete the dimension using SQL then do a search on this forum and you will find some possible solutions.

My Team lead and friend Rahul Sharma suggested, using SQL we can delete dimension using below steps:
This procedure should only be performed by your SQL or Oracle DBA.

BE SURE YOU HAVE A BACKUP OF YOUR APPLICATION BEFORE ATTEMPTING THIS PROCEDURE.

You will need to delete all the children first, then the dimension.

If you have the dimension in forms, you may also need to(after step 5) go into the hsp_form obj_def_mbr table and delete all references of that object ID. Then delete the dim id in the hsp_form_layout table. Recycle services of Planning.

Procedure:
If you create a custom dimension in planning and wish to delete it,here is how you might remove it from SQL manually. We recommend that only someone familiar with relational databases attempt this.

The following assumptions are being made about the dimension:

* No forms have any references to the dimension.
* Any and all attribute dimensions have been removed from the dimension.
* Any and all members have been removed from the dimension.
* All security access has been removed from dimension.
* Any Alias associated with the dimension has been removed.

In this example we have created a dimension called DummyDimension.

1. Open the Enterprise Manager for SQLserver
2. Open the database that has your planning application
3. Open the table HSP_OBJECT
4. You need to find the row that has the dimension name you want to delete:
5. Take note of the OBJECT_ID in my example it is 50051, don't delete it yet.
6. Open the table HSP_MEMBER
7. Find and delete any rows that have a MEMBER_ID equal to the OBJECT_ID from step 5.
8. Close the Table HSP_MEMBER
9. Open the table HSP_MRU_MEMBERS.
10. Find and delete any rows that have a DIM_ID equal to the OBJECT_ID from step 5.
11. Close the table HSP_MRU_MEMBERS.
12. Open the table HSP_DIMENSION
13. Find and delete any rows that have a DIM_ID equal to the OBJECT_ID from step 5.
14. Close the table HSP_DIMENSION
15. Also delete it's reference from the HSP_UNIQUE_NAMES table.
16. Delete the row in the HSP_OBJECT table that you found in step 4.
17. Close the HSP_OBJECT table.
18. Open Essbase Application Manager for the application and remove the dimension from the necessary Essbase outlines. 
19. Restart the application server.

Thanks to John goodwin and Rahul Sharma...!!

For EPMA deployed application:
How Can We Delete Dimensions In Planning Once The application has been deployed From EPMA? [ID 1055007.1]


Thanks,
Mady

How to reset drm admin password??

                                            How to reset drm admin password??

Login as the drm schema/database user

Step 1 Make back up of current table data:

for oracle database execute the following:

         create table rm_user_bak as
         select * from rm_user;


for sql server execute the following:
Make sure that the drm database is being used 
         USE { database }
         SELECT * INTO dbo.rm_user_bak
         FROM dbo.rm_user;

---------------------------------------------------------------------------------

Step 2: Rest password to default::

for oracle execute the following:

update rm_user
set c_password ='S5ZY+Gwo/mR0xJVvh/bgB4e+eioS3lG7JVoO2PtuemrNAXcXc3qivFQAA62kKbUuZF8VceuEiUxgq8pznMUrTg=='

where c_user_name ='ADMIN';
Commit;

for sql server execute:

update dbo.rm_user
set c_password ='S5ZY+Gwo/mR0xJVvh/bgB4e+eioS3lG7JVoO2PtuemrNAXcXc3qivFQAA62kKbUuZF8VceuEiUxgq8pznMUrTg=='
where c_user_name ='ADMIN'

Commit

Step 3: test the changes
 The password has been reset to the default.
 Try logging into the application using user ADMIN and the password Welcome!


Warning: Do NOT update any other user with this password it will NOT work.

if there are any issues restore the the original password from the created back up table 

Could not connect to repository - IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 - ODI

IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 - ODI

Description::

This error we will get when there is multiple entries in SNP_LOC_REP table.

Solution: Delete latest entry and make sure only one entry will be there in the same table.

Error msg looks like below::

In my case there 2 entries in SNP_LOC_REP table, deleted entry from the same.

                                   After deleting one entry from the SNP_LOC_REP table

                                                    Now ODI logged in successfully.


Thanks,
Mady

FDM - HFM adapter

                                                         Register HFM adapter

1. First extract hfm adapter to the following location::

D:\Hyperion\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

 

2. Open FDM application then first import adapter. Browse the FM11X-G5-E file from shared Components.

3. Once import done, the Register adapter with fdmFM11XG5E.dll from the Shared Components\AdapterComponents\fdmFM11xG5E

4.  Then create Machine profile with source and Target Server details

5.  After creating application if FDM application giving issue to integrate with HFM application, then we need to enable same number of custom dimensions on FDM application. Then we can see Target Period, Year etc from FDM.

Thanks,

Mady

FDM application 11.1.2+

                             How to create FDM application in 11.1.2.1+

1.       FDM works on 32-bit mode only even if you have installed on 64-bit machine.

2.       Create schema on oracle database with below::

Privileges::

CREATE SESSION,CREATE VIEW,CREATE TYPE,CREATE TABLE,CREATE CLUSTER,CREATE TRIGGER,CREATE SEQUENCE,CREATE INDEXTYPE,CREATE PROCEDURE,CREATE ANY SYNONYM,DROP ANY SYNONYM,UNLIMITED TABLESPACE

Roles: Connect, Resource and DBA.

3. We can check connect of FDM schema connectivity using udl32 file.

• Create a text file and save as with udl32 extension.
• Launch a command prompt.
• Execute the following command like below::

C:\WINDOWS\SysWOW64\Rundll32.exe "c:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile c:\testconn.udl32

4. Udl32 file will open now. You can check connectivity.

5. Create FDM application with same schema details.

6. Check the upsLBMgr.exe process in Task Manager which shows the application creation progress

7. If you get “Object variable or with block variable not set”

• Check FDM service account has permissions.
• If you are giving UNC path (if it is load balance), check folder permissions and try / and \
• If you are UNC Path, try with drive name while creating application later you can change to UNC path.
• If FDM version 11.1.2.1, we need to apply patch. Patch number—12795642
• If FDM 11.1.1.4 version, we need to apply patch. Patch number--13336220 (PSU 102)

Thanks,

Mady