Oracle Hyperion Patching - lsinventory command

If you want to check whatever patches are there in you hyperion server, you can search with lsinventory command.

Go to cmd and route below the path. Then run lsinventory command with optach.bat as mentioned below, you can list of patches applied on that patch.

 "D:\oracle\Middleware\EPMSystem11R1\OPatch" or wherever you have opatch folder.

Run the following script:
opatch.bat lsinventory -oh D:\Oracle\Middleware\EPMSystem11R1 -jre D:\Oracle\Middleware\jdk160_21

 -oh = Oracle home location = Oracle_Home
-jre = Jre location

Thanks,
Mady

Oracle Hyperion 11.1.2.4.900 Updates

"EPM System Release 11.1.2.4.900 is intended for new deployments. If you are an existing customer with a deployed application, there is no need to upgrade to this release"

Note: This release is for installing new deployments only, it does not apply to existing deployments of EPM System. If you have an existing deployment of EPM System, then you should not use this release. You cannot upgrade to release 11.1.2.4.900 from a previous release.”

Only Financial Reporting in this version.

No Home Page in this version

One more update about Chrome Support:

27787630 -- Chrome is not supported in Release 11.1.2.4.900; however, if you do use Chrome as your browser, when you log on to EPM Workspace, you are not warned that Chrome is not supported.

27737106 -- If you log off from EPM Workspace by clicking the Log Off link or by selecting File, then Log Off, and then you log back on to EPM Workspace without closing the logon page, you will not see a Log Off link or a File > Log Off menu item.

As a workaround, exit EPM Workspace by selecting File, and then Exit, or close the browser window. When you do this, the next session will show the Log Off link and the File > Log Off menu item.

https://docs.oracle.com/cd/E57185_01/nav/deployandinstall.htm

https://docs.oracle.com/cd/E57185_01/DMOOO/epm_11124900_readme.html#epm_1112300_readme_template2_2

Thanks,
Mady

HFM Migration 11.1.2.4.200+ from Workspace

HFM migration in latest version we can do using LCM or using Import application also.

For LCM, check out below link from oracle to import artifacts.
https://docs.oracle.com/cd/E57185_01/EPMMG/epm_migrate_hfm_app.html

Utility will be in Workspace itself, we will get once we patch the system with 11.1.2.4.200+

Once we patch, we will get import application option in Consolidation Administration.

In Import application, we can give Source and Target details and start migration. Check out screen shot below:

We need to create Database links to create link between Test and Dev environment, like UDL file we create in previous versions.

Once we create Database links, we can see schema in Source HFM Database Name and in next tab we will get list HFM applications.

In next tabs, we will give destinations details like application, description, Cluster, User Management project etc. We have options here to select Import Audit Tables, Import Data Tables, Use Filter for Data.

If we planning to use filter to select particular data, we can select the above options.

once we are done with options selection, click on Import application on right top corner.

If you are not able to see import application tab or any other tabs, check out browser compatible with this version or not.

HFM Migration in upto 11.1.2.3.xxx
https://hyperion-mady.blogspot.com/2017/03/hfm-migration_30.html


How to create Database links to use importapplication for HFM

Link:

https://docs.oracle.com/cd/E12032_01/doc/epm.921/html_hfm_admin_webhelp/frameset.htm?/cd/E12032_01/doc/epm.921/html_hfm_admin_webhelp/AdminHelp-05-18.html

http://blog.checkpointllc.com/hfm-copy-application-utility-makes-a-big-return-in-11.1.2.4.2

Thanks,
Mady

Terms and Conditions

Terms and Conditions of https://hyperion-mady.blogspot.com/  Below are the Terms and Conditions for use of https://hyperion-mady.blogspot.com/. Please read these carefully. If you need to contact us regarding any aspect of the following terms of use of our website, please contact us on the following email address - madhu.hyp2011@gmail.com.  By accessing the content of https://hyperion-mady.blogspot.com/ ( hereafter referred to as website ) you agree to the terms and conditions set out herein and also accept our Privacy Policy. If you do not agree to any of the terms and conditions you should not continue to use the Website and leave immediately.  You agree that you shall not use the website for any illegal purposes, and that you will respect all applicable laws and regulations.  You agree not to use the website in a way that may impair the performance, corrupt or manipulate the content or information available on the website or reduce the overall functionality of the website.  You agree not to compromise the security of the website or attempt to gain access to secured areas of the website or attempt to access any sensitive information you may believe exist on the website or server where it is hosted.  You agree to be fully responsible for any claim, expense, losses, liability, costs including legal fees incurred by us arising from any infringement of the terms and conditions in this agreement and to which you will have agreed if you continue to use the website.  The reproduction, distribution in any method whether online or offline is strictly prohibited. The work on the website and the images, logos, text and other such information is the property of https://hyperion-mady.blogspot.com/ ( unless otherwise stated ).  Disclaimer  Though we strive to be completely accurate in the information that is presented on our site, and attempt to keep it as up to date as possible, in some cases, some of the information you find on the website may be slightly outdated.  https://hyperion-mady.blogspot.com/ reserves the right to make any modifications or corrections to the information you find on the website at any time without notice.  Change to the Terms and Conditions of Use  We reserve the right to make changes and to revise the above mentioned Terms and Conditions of use.  Last Revised: 01-02-2019

Privacy policy

Privacy Policy for https://hyperion-mady.blogspot.com/ 

If you require any more information or have any questions about our privacy policy, please feel free to contact us by email at madhu.hyp2011@gmail.com. 

At https://hyperion-mady.blogspot.com/, the privacy of our visitors is of extreme importance to us. This privacy policy document outlines the types of personal information is received and collected by https://hyperion-mady.blogspot.com/ and how it is used. 

Log Files
Like many other Web sites, https://hyperion-mady.blogspot.com/ makes use of log files. The information inside the log files includes internet protocol ( IP ) addresses, type of browser, Internet Service Provider ( ISP ), date/time stamp, referring/exit pages, and number of clicks to analyze trends, administer the site, track user’s movement around the site, and gather demographic information. IP addresses, and other such information are not linked to any information that is personally identifiable. 

Cookies and Web Beacons 
https://hyperion-mady.blogspot.com/ does use cookies to store information about visitors preferences, record user-specific information on which pages the user access or visit, customize Web page content based on visitors browser type or other information that the visitor sends via their browser. 

DoubleClick DART Cookie 
.:: Google, as a third party vendor, uses cookies to serve ads on https://hyperion-mady.blogspot.com/.
.:: Google's use of the DART cookie enables it to serve ads to users based on their visit to https://hyperion-mady.blogspot.com/ and other sites on the Internet. 
.:: Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy at the following URL - http://www.google.com/privacy_ads.html 

Some of our advertising partners may use cookies and web beacons on our site. Our advertising partners include ....
Google Adsense


These third-party ad servers or ad networks use technology to the advertisements and links that appear on https://hyperion-mady.blogspot.com/ send directly to your browsers. They automatically receive your IP address when this occurs. Other technologies ( such as cookies, JavaScript, or Web Beacons ) may also be used by the third-party ad networks to measure the effectiveness of their advertisements and / or to personalize the advertising content that you see. 

https://hyperion-mady.blogspot.com/ has no access to or control over these cookies that are used by third-party advertisers. 

You should consult the respective privacy policies of these third-party ad servers for more detailed information on their practices as well as for instructions about how to opt-out of certain practices. https://hyperion-mady.blogspot.com/'s privacy policy does not apply to, and we cannot control the activities of, such other advertisers or web sites. 

If you wish to disable cookies, you may do so through your individual browser options. More detailed information about cookie management with specific web browsers can be found at the browsers' respective websites. 

Hyperion Planning: Failed to create security filters for the following Users: xxxxxx

We have faced one issue with one of our customer. Issue is Client side Administrator removed MSAD user which has access Hyperion Planning application. But after deleting that user, Planning Security filters give below error.

When refreshing, this issue we are facing. W

Solution:

We have verified HSP tables for this user like hsp_object, hsp_mru_members, hsp_user_prefs, hsp_pm_out_of_office, hsp_users, hsp_adhoc_opts etc. We may have references in other tables also. But in our case we didn't find any.


Delete from hsp_mru_members where object_id = '123456'
Delete from hsp_user_prefs where object_id = '123456'
Delete from hsp_pm_out_of_office where object_id = '123456'
Delete from hsp_users where object_id = '123456'
Delete from hsp_object where object_name='abdcef'
Delete from hsp_adhoc_opts where object_id = '123456'

Once done, check out you are refresh or not from Planning application.

Note: while deleting entries from these tables, take backup of schema and also check out any primary key, secondary key references are there.

Reference:

Hyperion Planning Unable To Refresh Security Filter Failing on one Specific LDAP User Error:"Failed to create security filter for user " (Doc ID 1961167.1)

Thanks,

Mady

Hyperion Planning: Enabling Access to Planning Artifacts On Mobile Devices

To work with artifacts such as forms, task lists, and business rules on mobile devices using the simplified interface, administrators must enable access to those artifacts for users.

To enable access to Planning artifacts on mobile devices:

1. Login to Workspace, then go to particular Planning application, then Select Administration, then Manage, and then Tablet Access.
2. In Tablet Access Setup, select the Forms, Tasks, and Rules tabs to view and select the artifacts that you want to enable.
3. You can use Hyperion Planning Url to access simplified interface:
   http://<servername>:<port>/HyperionPlanning

You can check here what ever you have access in Hyperion Planning application. for example: Forms, Tasks, Rules, Reports(whatever connected with this application)

Thanks,

Mady