DRM Web services API setup in Hyperion 11.1.2.1 version

1. Using right version of RCU, create MDS schema. for Moto use 11.1.1.4

2. Using weblogic Extend option, select Oracle Enterprise Manager -11.1.1.0 [oracle_common],
Oracle WSM Policy Manager – 11.1.1.0 [oracle_common], and Oracle JRF – 11.1.1.0 [oracle_common].

3. Add OID to myrealm in weblogic(optional)

4. Configuring the API Adapter Host (Add host name in DRM console)

5. Deploy Oracle-drm-web-services in weblogic from C:\Oracle\Middleware\EPMSystem11R1\products\DataRelationshipManagement\api directory
and select oracle-epm-drm-webservices.ear file

6. Check for wsm-pm is active or not.

7. if wsm-pm fails, check out oracle-webskin, oracle-web composer,emac, emai, emcore, and EM are active or not.
if you are not able to see them in the deployments list, we need to deploy them.
Once EM is up(active), you can login EM and deploy wsm-pm from EM.

8. Login to EM, select EPM system and right click and click on metadata repositories. click next. in next tab, in 2 sections, selct 2nd option in first section and browse the wsm-pm.ear and click next. in next tab, click on edit and select metadata repository and give any name and give password of mds schema password. click next and validate and finsh. now we can see wsm-pm is active in weblogic.

9. Once you are done with all these changes check out oracle-drm-web-services-api. Try to start or bounce services.

10. Test Web service in EM

Thanks,
Mady

In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar

                In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar

Steps to resolve this issue:

1. Stop FoundationServices and RA Framework webapps, and RA Agent services.

2. Execute the following query against the Shared Services registry database:

select application_id from css_provisioning_info where lower(application_id) like 'hava%'; 

note this application id, e.g. HAVA:0000012b3072bf63-0000-6717-0acc1bac

3. Using the epmsys_registry tool, execute:

epmsys_registry updateproperty RA_FRAMEWORK/@applicationId <the application Id returned from the query above> 

Example using ID above:

epmsys_registry updateproperty RA_FRAMEWORK/@applicationId HAVA:0000012b3072bf63-0000-6717-0acc1bac

4. Restart the services.

Reference: 

In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar (Doc ID 1325933.1)

Thanks, 

Mady

How to change admin password in Hyperion Shared services

                                 Admin password change in Hyperion Shared services


Situation and Goal:
we have installed and configured Hyperion worksapce, shared services and other components in cloud servers. Then we have started migration from client LCM dump, first we did HSS migration. In this case, the admin password (which has given at the time of configuration time) is overwritten.

So, we need to reset password to some known with encrypted with in the CSS users table.

Steps:
1. Login to Shared Services Schema ( The user you used during the shares services configuration) with SQL developer or any other tools and look for “CSS_USERS” table.

2. Run the below command:

update CSS_USERS
set PASSWORD= '{SSH2}mpQoG4jU00otFocLZM6CWWUzpk9ZmSY5In3l3ZzFCH5byRhkG6ow7z4KxXmXWXSo'
where name='admin';

This will setup the admin users password to ‘password'

OR

Run the below command:

update CSS_USERS
set PASSWORD= ‘{SSH2}FvSZVSvSmzvjT/02Nn1TrJyQk8SqNus4Fw4m2cNxa3zkSLe8HFiJy7cT8zUDGiWi’
where name='admin';

Commit the changes

Note: Take backup of CCS_USERS table before do any changes.

Reference:
http://epmcult.blogspot.in/2014/06/resetting-hyperion-workspace-admin.html

Thanks,
Mady

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