tag:blogger.com,1999:blog-68735286347947843492024-03-13T07:11:58.199+02:00The Finnish Hyperion GuyAbout the technical side of the Oracle EPM productsHenri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.comBlogger74125tag:blogger.com,1999:blog-6873528634794784349.post-13168232027886562032018-06-20T21:53:00.000+03:002018-06-20T21:53:12.237+03:00Smart View 11.1.2.5.800<br />
<div class="MsoNormal">
<span lang="EN-US">Oracle has released a new version of the Smart
View Office add-in: 11.1.2.5.800. Most of the new features are meant to be used with Essbase:</span></div>
<div class="MsoNormal">
</div>
<ul>
<li>New Essbase Expense Type Option - inverts the sign for data in columns related to revenue, liability, and owner's equity accounts (for ASO databases)</li>
<li>New option called Enable Varying Attributes allows Essbase users to display #Invalid or #NumericZero for cells that are empty only because they are not associated with the context attribute or varying attribute in a query</li>
<li>You can now use an MDX-based calculation script to calculate an ASO database in Oracle Analytics Cloud</li>
<li>New View Properties button in the OBI EE ribbon</li>
<li>Enhanced Move Formatting options - since Move Formatting on Operations may affect performance on zoom operations, this Oracle Smart View for Office formatting option is now always disabled by default.</li>
</ul>
<br />
<div class="MsoNormal">
<span lang="EN-US">You can read more about these features in the <a href="https://docs.oracle.com/applications/smartview/800/SVREA/toc.htm" target="_blank">SV 11.1.2.5.800 readme file</a>.</span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<h3>
<span lang="EN-US"><b>Smart View Health Check</b></span></h3>
<div>
<span lang="EN-US"><b><br /></b></span></div>
<div class="MsoNormal">
<span lang="EN-US">Health Check is a handy new tool that has been added to the SV Help
menu.</span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk-Ru0yZ0ImW54I76OSR386SWMJS9fekb9xWewcCDl_5sFl_ng-ok05xbKKrZwh8iBVnl-aKyOPCtMo6tK06j5bQfwsmwCjncSTYyGuPIoiShHC7BsS2epIqQYt0g-Z7-iU0mdeWIrgVI2/s1600/smartview-healthcheck-menu.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="427" data-original-width="405" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk-Ru0yZ0ImW54I76OSR386SWMJS9fekb9xWewcCDl_5sFl_ng-ok05xbKKrZwh8iBVnl-aKyOPCtMo6tK06j5bQfwsmwCjncSTYyGuPIoiShHC7BsS2epIqQYt0g-Z7-iU0mdeWIrgVI2/s200/smartview-healthcheck-menu.png" width="189" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<div class="MsoNormal">
<span lang="EN-US">The tool displays version details for the operating system, Excel and </span>Smart View and also shows the most important settings affecting SV performance and
stability. There is a button you can click to set recommended settings on the user profile level. This is nice functionality for troubleshooting refresh issues that are often caused by timeout settings not being tuned properly in Windows registry.</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWimnwUU3ZIgT2VeWmE9CyvxjWTgCYR-f2HJWDYeiMq-tt-P8szHwyUZCzZ1s0vRXzEAPuf1uDWhNuO44V6KrIUtfLp5hv8cu1wz98RU_J3zCBAOoQ_k3qxLmsrAySVBHEQchd0LgqDL1F/s1600/smartview-healthcheck-panel.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="923" data-original-width="962" height="383" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWimnwUU3ZIgT2VeWmE9CyvxjWTgCYR-f2HJWDYeiMq-tt-P8szHwyUZCzZ1s0vRXzEAPuf1uDWhNuO44V6KrIUtfLp5hv8cu1wz98RU_J3zCBAOoQ_k3qxLmsrAySVBHEQchd0LgqDL1F/s400/smartview-healthcheck-panel.png" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<h3>
Firefox Extension</h3>
<div>
<br /></div>
<div>
<div class="MsoNormal">
<span lang="EN-US">Firefox ESR 60 and later require all add-ons to be created in the new WebExtension format (as mentioned in my <a href="http://hyperionfinn.blogspot.com/2017/11/firefox-update-breaks-smart-view-links.html" target="_blank">previous post</a>). Oracle has now updated the Firefox extension that
is used by the “Open in Smart View” links in EPM/Hyperion web forms (only Firefox needs this extension - Internet Explorer opens the links in a different way). It's worth noting that the extension is no more distributed with the Smart View package like it used to be and therefore all Firefox users need to install it separately from the Mozilla Add-ons website. It is also possible to automate the installation using <a href="https://developer.mozilla.org/en-US/Add-ons/WebExtensions/Alternative_distribution_options/Sideloading_add-ons" target="_blank">alternative distribution options</a>.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
</div>
<h3>
Links</h3>
<div>
<br /></div>
<div>
<ul>
<li>Download the latest version on the Smart View website: <a href="http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html">http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html</a></li>
<li><a href="https://docs.oracle.com/applications/smartview/800/SVREA/toc.htm" target="_blank">Readme file for Smart View 11.1.2.5.800</a></li>
<li><a href="https://addons.mozilla.org/en-US/firefox/addon/oracle-smart-view-for-office" target="_blank">Smart View add-on on the Mozilla Add-ons website</a></li>
</ul>
<div>
<br /></div>
</div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com0tag:blogger.com,1999:blog-6873528634794784349.post-74023521305250924212017-11-15T22:05:00.003+02:002017-11-15T22:09:17.168+02:00Firefox Update Breaks Smart View Links (On-Premise + Cloud)Mozilla has just released a new version of their browser: <a href="https://www.mozilla.org/en-US/firefox/57.0/releasenotes/" target="_blank">Firefox 57 “Quantum”</a>. The new release is <a href="https://blog.mozilla.org/firefox/quantum-performance-test/" target="_blank">promised to be even faster than before</a>, but there is one downside as well; it disables extensions that haven’t been implemented with the new WebExtensions technology. The extension installed by Oracle Smart View is among the "legacy" extensions that can't be used with the latest Firefox version.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjujjs0OtrWG9T7LlteWCncLLv5734htsin7p1wSdkghtl57MIxv0u8PT7yw_ZLHXeCPtni392cyAiqHBx7vTh1gOfbhKrhXnSjaul1sQvTPvW-nwLLGhHk9j0LwQOoOU-3DMc6R8AIfapa/s1600/firefox+57+and+sv+extension.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="220" data-original-width="961" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjujjs0OtrWG9T7LlteWCncLLv5734htsin7p1wSdkghtl57MIxv0u8PT7yw_ZLHXeCPtni392cyAiqHBx7vTh1gOfbhKrhXnSjaul1sQvTPvW-nwLLGhHk9j0LwQOoOU-3DMc6R8AIfapa/s400/firefox+57+and+sv+extension.png" width="400" /></a></div>
<br />
This means that the "Open in Smart View" links in HFM, Planning, PBCS and FCCS will cease to work in latest Firefox because they rely on the old extension.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWgh7iXttk8IWGOLF7wS9b2FgtbsP7zFuKkV8w9J_4lPMBYi8kVG7K0njPDDlevBdhv3PM3XEn8z5YpjLlnVJB4rt8y8GTaLPMP-YiBinoErA4TOsUuT41RyQgui9OOtndPrVCtE5zmbI3/s1600/firefox+57+open+in+sv.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="255" data-original-width="597" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWgh7iXttk8IWGOLF7wS9b2FgtbsP7zFuKkV8w9J_4lPMBYi8kVG7K0njPDDlevBdhv3PM3XEn8z5YpjLlnVJB4rt8y8GTaLPMP-YiBinoErA4TOsUuT41RyQgui9OOtndPrVCtE5zmbI3/s320/firefox+57+open+in+sv.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Open in Smart View (HFM)</span></td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG_jOjYU2VhAGwdz83SNjwJlrT7bxKvIMMlqYxq7LbdG4irX0e6Eca2HwhTUTNUkMAMebv8sjnF3swg6AfJcb6dk4gVXXvNCeqxOHbG9HHZpbNdMCY142LBbgHvYGp27tFZ4vLnzlfi888/s1600/firefox+57+open+in+sv+pbcs.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="437" data-original-width="490" height="285" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG_jOjYU2VhAGwdz83SNjwJlrT7bxKvIMMlqYxq7LbdG4irX0e6Eca2HwhTUTNUkMAMebv8sjnF3swg6AfJcb6dk4gVXXvNCeqxOHbG9HHZpbNdMCY142LBbgHvYGp27tFZ4vLnzlfi888/s320/firefox+57+open+in+sv+pbcs.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Open in Smart View (PBCS)</span></td></tr>
</tbody></table>
<br />
Oracle has published the following statement in the latest Smart View readme file and also in the monthly notes for the EPM Cloud Services.<br />
<br />
<blockquote>
<b>USING FIREFOX ESR 52.4.2 WITH SMART VIEW</b></blockquote>
<blockquote>
Future releases of Mozilla Firefox will be phasing out support for XUL-based add-ons such as Smart View. Starting in mid-November 2017, only add-ons and extensions built with new web extension technology will work in Firefox. Therefore, Smart View 11.1.2.5.710 only supports <u>Firefox versions up to ESR 52.4.1. If you want to continue using Firefox with Smart View 11.1.2.5.710, do not upgrade your Firefox browser.</u>
If your Firefox browser is set to automatically install updates, Oracle recommends changing the setting to “Check for updates, but let me choose whether to install them.” See the Firefox help for instructions on changing this setting.</blockquote>
<br />
I have not heard any official statements yet, but I hope that Oracle will update the Smart View extension to work with the latest version soon. Meanwhile your best option is to use the less frequently updated <a href="https://www.mozilla.org/en-US/firefox/organizations/" target="_blank">Firefox ESR version</a> as Oracle recommends.Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com3tag:blogger.com,1999:blog-6873528634794784349.post-71198404867419590212017-02-08T10:01:00.000+02:002017-02-08T10:08:58.015+02:00Financial Reporting Studio's Days Are NumberedThere has been a lot of activity going on around Hyperion Financial Reporting Studio in the past few months. In case you haven't heard, Oracle is planning to get rid of the old Windows-based report authoring tool and this change is going to be carried out quite soon. Here are the facts:<br />
<ul>
<li>Financial Reporting <b>Web Studio</b> was introduced in the March 2016 update for PBCS and released as Patch Set Update .701 for EPM 11.1.2.4 two months later. Web Studio lacked some functionality at the time of the release but has almost reached parity with the Windows based Studio after recent updates.</li>
</ul>
<ul>
<li>As announced in <a href="http://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/pbcs/1612-pbcs-wn.htm" target="_blank">the December 2016 update for PBCS</a>, the desktop client is going to be replaced by this web-based solution. The switch is tentatively planned to happen in <u>the May 2017 update of the cloud service</u>. The same schedule is also mentioned in the <a href="https://support.oracle.com/epmos/faces/DocContentDisplay?id=2228757.1" target="_blank">Statement of Direction document</a> recently released on My Oracle Support.</li>
</ul>
<ul>
<li>The <a href="https://updates.oracle.com/Orion/Services/download?type=readme&aru=20871527" target="_blank">readme file</a> for FR Patch Set Update 11.1.2.4.704 informs users that support for the Studio desktop client will be discontinued in an update preliminary scheduled for mid-2017.</li>
</ul>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXWyLwwerqronQP-mXOoLnFl7HzTxu9aRSAZBEgWhyphenhyphenRaV_Ibtqdz1PH9w5p5cWGmYZYHJ2wALqtB4upbFm1G_6uQgQcRTj_LIb_yl51I9flxFFrJm9D9ZEr5gI5p1K5WFmMR9Lms2Q2Cxg/s1600/fr+web+studio.png" imageanchor="1"><img border="0" height="167" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXWyLwwerqronQP-mXOoLnFl7HzTxu9aRSAZBEgWhyphenhyphenRaV_Ibtqdz1PH9w5p5cWGmYZYHJ2wALqtB4upbFm1G_6uQgQcRTj_LIb_yl51I9flxFFrJm9D9ZEr5gI5p1K5WFmMR9Lms2Q2Cxg/s320/fr+web+studio.png" width="320" /></a></div>
<div>
<br /></div>
<div>
How does this affect Hyperion administrators using FR Studio then? First of all, you can continue using the old client and Web Studio side by side until you feel comfortable moving to the new solution. But I recommend that all users of Oracle Cloud Services (PBCS or FCCS) and those running EPM 11.1.2.4 should start familiarizing themselves with Web Studio as soon as possible. Financial Reporting has always been very picky in the sense that the client and server components have to run identical versions and this means that an update to Cloud Services will render the desktop Studio useless immediately when Oracle stops releasing an updated client. The same version requirement also applies to on-premise installations but there you will have more control over when to apply the "Studio-killing" patch (supposedly to be released in mid-2017). You can choose not to install the patch right away but it's not likely that you can postpone it forever though.</div>
</div>
<div>
<br /></div>
<div>
I assume that customers using EPM version 11.1.2.3 or older will not be affected by these changes as older releases have already fallen outside Oracle's error correction policies. It's still worth keeping in mind that Web Studio will be the only option when you choose to upgrade to a later release.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Further reading:</div>
<div>
<ul>
<li><a href="https://docs.oracle.com/cd/E57185_01/HFWCG/toc.htm" target="_blank">Financial Reporting Web Studio User's Guide</a></li>
<li>My <a href="http://0.0.7.224/05/financial-reporting-web-studio-arrives.html" target="_blank">earlier post</a> about Web Studio </li>
<li><a href="https://updates.oracle.com/Orion/Services/download?type=readme&aru=20871527" target="_blank">Readme file</a> for the latest FR Patch Set Update (11.1.2.4.704)</li>
</ul>
</div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com1tag:blogger.com,1999:blog-6873528634794784349.post-11070715109514854852016-09-27T16:59:00.000+03:002016-09-27T16:59:45.752+03:00HFM Java API Part 1: Getting StartedOk, <a href="http://kscope16.com/" target="_blank">Kscope16</a> went by and the conference was awesome. My summer holiday is also far gone and it was nice even though the weather could have been better (but hey, I live in Finland, not in Spain or Florida so some fluctuations are expected). After getting back to work in August I have been very busy helping a couple of customers who have gone live with their new HFM 11.1.2.4 environments or are in the process of doing so. But now it's time to update the blog again!<br />
<br />
I did a presentation about the new HFM Java API in Kscope16 and was glad to hear that many developers are already using it to achieve some cool things - like Ricardo and Rodrigo of <a href="http://devepm.com/" target="_blank">DEVEPM.com</a> with their ODI KM (how's the paper doing guys? ;). I decided to release my short "Getting Started" document to public to make it slightly easier for to people to pick up JDeveloper and get their first project built using the Java API.<br />
<br />
Link: <a href="https://drive.google.com/open?id=0BwNL18vHhKknWUZwdzNRcVJYRHM" target="_blank">Set Up New HFM API Project In JDeveloper</a> (PDF document)<br />
<br />
After getting the <a href="https://en.wikipedia.org/wiki/Integrated_development_environment" target="_blank">IDE</a> ready you can start developing code for your Java program. In the next post I will concentrate on the coding part and show you examples of common tasks in HFM such as extracting data and running consolidations.Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com9tag:blogger.com,1999:blog-6873528634794784349.post-54150431060190708492016-05-05T00:52:00.000+03:002016-05-05T01:13:23.351+03:00Financial Reporting Web Studio Arrives To On-Premise EPMIf you have attended an Oracle EPM roadmap session lately you have most probably heard that unlike previous years a new EPM release is not scheduled for 2016. While waiting for the big 12c release to drop, new updates and features will be added to the current version in the form of Patch Set Updates. HFM PSU 11.1.2.4.200 was a prime example of this strategy and now Financial Reporting is the next product to get a feature-laden update.<br>
<br>
Financial Reporting PSU 11.1.2.4.701 was released today and it contains two big changes: FR Web Studio (a web-based report authoring tool) and an updated charting engine. I applied the PSU on my virtual machine running EPM 11.1.2.4 and took a peek at these new features.<br>
<br>
<a href="http://hyperionfinn.blogspot.com/2016/05/financial-reporting-web-studio-arrives.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com10tag:blogger.com,1999:blog-6873528634794784349.post-11863944477824050302016-03-31T11:19:00.000+03:002016-04-14T15:17:06.487+03:00Copy HFM Applications Using The Import Application Feature<div>
In this post I document the steps required to configure the Import Application feature introduced in HFM 11.1.2.4.200. I recommend reading <a href="http://hyperionfinn.blogspot.com/2016/03/quick-review-of-hfm-patch-set-update.html" target="_blank">my earlier post about the Patch Set Update</a> if you haven't done that already. Note that the configuration is database vendor specific and I used MS SQL Server – if you need guidance for setting things up with an Oracle database you can see <a href="http://blog.checkpointllc.com/the-hfm-copy-application-utility-makes-a-triumphant-return-in-11.1.2.4.200-sort-of" target="_blank">Larry Lapp's recent blog post about the same topic</a>.</div>
<div>
<br></div>
<h3>
<b>Prerequisites</b></h3>
<div>
<ul>
<li>HFM with Patch Set Update 11.1.2.4.200 (patch number 21225611) installed </li>
<li>Access to SQL Server Management Studio with sysadmin privileges</li>
<li>SYSADMIN role granted to the SQL login used by HFM (Yes – the almighty <i>sysadmin </i>role. This requirement is documented as known issue #21032270 in the PSU .200 readme)</li>
</ul>
<div>
</div></div><a href="http://hyperionfinn.blogspot.com/2016/03/copy-hfm-applications-using-import.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com10tag:blogger.com,1999:blog-6873528634794784349.post-59393718373392459412016-03-03T21:59:00.000+02:002016-03-15T15:54:27.920+02:00Quick Review Of HFM Patch Set Update 11.1.2.4.200Oracle has released another big PSU to HFM 11.1.2.4. This one has been in the works for a long time so I was eager to test the update ASAP even though I'm still jet-lagged after returning from a two-week vacation in the Far East.<br>
<br>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbzABtcdzE5gdASxkOwHNx-2Le6J527nRG9HfJlO96FISlKZeG5-B4OzL5hsHsx-CkGYc0SzMZ3akrBZJmmbZK-mwLChrpK6oCJE0swNgbFytxSVtNva9SPNO0bv6wCQdmCJ8F5X4Aeyiw/s1600/hfm_psu200-version-crop.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbzABtcdzE5gdASxkOwHNx-2Le6J527nRG9HfJlO96FISlKZeG5-B4OzL5hsHsx-CkGYc0SzMZ3akrBZJmmbZK-mwLChrpK6oCJE0swNgbFytxSVtNva9SPNO0bv6wCQdmCJ8F5X4Aeyiw/s400/hfm_psu200-version-crop.png" width="400"></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-size: xx-small;">Version number reads "Oracle Hyperion Financial Management, Fusion Edition - 11.1.2.4.200.5149"</span></td></tr>
</tbody></table>
<h3>
New Features</h3>
Let's start with the most interesting bits. The list of new features included in the readme file is long but slightly misleading... Most of the "new" functions have already been included in PSU .100 and just listed again as this is a cumulative patch. Read on to find out what actually is new in this Patch Set Update.<br>
<br>
<a href="http://hyperionfinn.blogspot.com/2016/03/quick-review-of-hfm-patch-set-update.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com17tag:blogger.com,1999:blog-6873528634794784349.post-5623461075298540562015-12-21T13:38:00.001+02:002015-12-21T13:50:09.739+02:00FDMEE Patch Set Update 11.1.2.4.100Here's a quick update for those who are running FDMEE version 11.1.2.4. The big Patch Set Update .100 has been released - just in time for Christmas! Because my friend Francisco is the real expert when it comes to the product in question, I'll let him explain you what's new in this update.<br />
<ul>
<li>Blog post: <a href="http://fishingwithfdmee.blogspot.fi/2015/12/fdmee-11124100-released-psu100-part-1.html" target="_blank">FDMEE 11.1.2.4.100 released (PSU100) - Part 1</a></li>
</ul>
<br />
Oracle resources (Oracle account required):<br />
<ul>
<li><a href="https://updates.oracle.com/Orion/Services/download?type=readme&aru=19686356" target="_blank">Readme file for FDMEE PSU 11.1.2.4.100</a> </li>
<li><a href="https://updates.oracle.com/Orion/Services/download/p20648390_111240_Generic.zip?aru=19686356&patch_file=p20648390_111240_Generic.zip" target="_blank">Download the PSU (patch 20648390)</a></li>
</ul>
<br />
<br />Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com2tag:blogger.com,1999:blog-6873528634794784349.post-68600719118833804912015-12-15T22:25:00.003+02:002015-12-15T22:26:12.246+02:00Kscope16 ConferenceThe <a href="http://www.kscope16.com/" target="_blank">Kscope16 conference</a> will take place in Chicago on June 26th - 30th, 2016. I am pleased to inform you that I will be there to present two sessions about my favorite Hyperion product:<br />
<ul>
<li>Unravel The Secrets of The New HFM API</li>
<li>Upgrading To The Latest HFM Version? Set Your Expectations Right!</li>
</ul>
<div>
The ODTUG content review teams have been working hard to get tons of of great sessions selected so book your place early!</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.kscope16.com/" target="_blank"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJib3a3vGRVMw5OrIGsH16AszwENfaK2xKix0PEjQOkFKrb0yyAtmW0dnTmlie2QG4uVGBKSB2yFX-Qtz0ysZaWKM__o4w5G3Jdn2tpbpF0aQYI7SkH-X4Fc2M71eIp91sM2bdf1eHS2Ge/s400/kscope16+banner.png" width="400" /></a></div>
<div>
<br /></div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com0tag:blogger.com,1999:blog-6873528634794784349.post-79380175832851716812015-10-30T23:21:00.000+02:002016-05-01T12:27:18.648+03:00Copy Application Utility For HFM 11.1.2.4 - Well, sort of...Oracle has just released a new patch for Financial Management 11.1.2.3. The patch delivers what many (if not all) customers who have adopted the latest HFM release have been asking for: a version of the Copy Application utility that works with HFM 11.1.2.4. The following actions are possible using the updated utility:<br>
<ul>
<li>Copy HFM applications between different 11.1.2.4 environments (both need to have minimum patch level of 11.1.2.4.100)</li>
<li>Copy HFM applications from older release (11.1.2.x) to 11.1.2.4. The Upgrade Applications taks <u>must</u> be performed in EPM System Configurator afterwards.</li>
</ul>
<br>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiams4KONk7q8zKYCiVQAQQQyCbft4DhZUyzQIR52npKj9FSoZAEWRRK2EbgIUKHuiU9wm5MhbzofJo6kVlFUjtlXlCXXbuLn5izmJWSBrM_Uj2se5V82B9aRWoed80CRyeKEQB2sxk8XPH/s1600/copyapp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiams4KONk7q8zKYCiVQAQQQyCbft4DhZUyzQIR52npKj9FSoZAEWRRK2EbgIUKHuiU9wm5MhbzofJo6kVlFUjtlXlCXXbuLn5izmJWSBrM_Uj2se5V82B9aRWoed80CRyeKEQB2sxk8XPH/s320/copyapp.png" width="320"></a></div>
<br>
<a href="http://hyperionfinn.blogspot.com/2015/10/copy-application-utility-for-hfm-11124.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com18tag:blogger.com,1999:blog-6873528634794784349.post-20681098618899190842015-08-18T14:20:00.000+03:002015-08-18T14:23:55.219+03:00Smart View 11.1.2.5.500 ReleasedOracle has released Smart View version 11.1.2.5.500 yesterday. I haven't had a chance to test the release yet but according to the documentation the biggest changes in this release are:<br />
<ul>
<li>Support for HFM journals: view journal properties, create, edit, submit, approve, post, unpost, and delete journals. HFM version 11.1.2.4.100 is required to use this new functionality.</li>
<li>Extended support for Oracle Business Intelligence Enterprise Edition (OBIEE): multiple connections now supported. OBIEE patch 11.1.1.7.140527 is required.</li>
</ul>
<div>
Read full details and download the patch from Oracle Support: <a href="https://support.oracle.com/rs?type=patch&id=21635725" target="_blank">Patch 21635725: Patch Set Update: 11.1.2.5.500 for Oracle Smart View for Office</a>. When upgrading from SV 11.1.2.x you can simply run the installer to upgrade the add-in (no need to uninstall the older version first). And as usual, please share your experiences if you try this version in your EPM environments!</div>
<div>
<br /></div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com10tag:blogger.com,1999:blog-6873528634794784349.post-52309927543276049312015-07-16T00:47:00.000+03:002015-07-16T00:54:40.623+03:00HFM 11.1.2.4 PSU 100 - Fixes And New FeaturesEPM version 11.1.2.4 was released in February and as you probably already know it brought a lot of changes to Hyperion Financial Management. Application performance is promised to be better and the new simplified HFM architecture has other benefits as well. Still it's common for many customers to be careful after major changes like this and to wait for at least one Patch Set Update to become available before picking up the new version. After a long wait, HFM PSU 11.1.2.4.100 was released on Friday last week. You can download <a href="https://support.oracle.com/rs?type=patch&id=20455650" target="_blank">PSU .100 (patch nr. 20455650) on Oracle Support</a>. Let's have a look at the list of changes in this update.<br>
<br>
<b><span style="font-size: large;">
New Features</span></b><br>
<br>
The following new features are introduced in the PSU.<br>
<br>
<a href="http://hyperionfinn.blogspot.com/2015/07/hfm-11124-psu-100-fixes-and-new-features.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com7tag:blogger.com,1999:blog-6873528634794784349.post-60843903514946632132015-07-01T21:52:00.002+03:002015-07-02T09:10:28.050+03:00Patch Set Update .700 - IE11 Support Comes To EPM 11.1.2.3Oracle seems to be in the process of releasing patches belonging to Patch Set Update 11.1.2.3.700. There is a handy list of all .700 patches in the readme file for the Financial Reporting patch that is already downloadable. Note that all of the packages mentioned in the list are not yet available as I'm writing this post and I'm also not sure whether or not PSUs will also be issued for Essbase.<br />
<br />
<i>Update on July 2nd: Added the patches for Shared Services and Workspace that were missing from the original list</i><br />
<div>
<br /></div>
<div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border: 1pt solid black;"><tbody>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: solid none none solid; border-top-color: black; border-top-width: 1pt; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<span class="Bold-Inline" style="font-weight: bold;">Product Name</span></div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: solid solid none none; border-top-color: black; border-top-width: 1pt; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<span class="Bold-Inline" style="font-weight: bold;">11.1.2.3.700 PSU Patch Number</span></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Data Relationship Management</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=21107706" target="_blank">21107706</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Financial Reporting</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20838970" target="_blank">20838970</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Calculation Manager</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=21292109" target="_blank">21292109</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Disclosure Management</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20619384" target="_blank">20619384</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Financial Close Management</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20768349" target="_blank">20768349</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Financial Data Quality Management Enterprise Edition</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20779592" target="_blank">20779592</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Financial Management</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20955781" target="_blank">20955781</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Performance Management Architect</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20929659" target="_blank">20929659</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Planning</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20643564" target="_blank">20643564</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Profitability and Cost Management</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20915688" target="_blank">20915688</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Reporting and Analysis Framework</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20768325" target="_blank">20768325</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Tax Provision</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=21219363" target="_blank">21219363</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Web Analysis</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20880421" target="_blank">20880421</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle Hyperion Shared Services</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20675028" target="_blank">20675028</a></div>
</td></tr>
<tr><td style="border-left-color: black; border-left-width: 1pt; border-style: none none none solid; padding: 0in 5.4pt; width: 277.85pt;" width="370"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
Oracle EPM Workspace</div>
</td><td style="border-right-color: black; border-right-width: 1pt; border-style: none solid none none; padding: 0in 5.4pt; width: 227.8pt;" width="304"><div class="MsoBodyText" style="font-family: Verdana, sans-serif; font-size: 10pt; margin: 0in 0in 12pt 0.25in;">
<a href="https://support.oracle.com/rs?type=patch&id=20612400" target="_blank">20612400</a></div>
</td></tr>
</tbody></table>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
The most important update in this PSU is native support for Internet Explorer 11:</div>
<blockquote class="tr_bq">
<i>"Apply this patch to use Internet Explorer release 11 in standards mode instead of in Enterprise Mode. After you apply this patch, you can no longer use Enterprise Mode. You must apply the 11.1.2.3.700 PSU for all EPM products in your deployment."</i></blockquote>
<div>
The <a href="http://www.oracle.com/technetwork/middleware/bi-foundation/oracle-hyperion-epm-system-certific-131801.xls" target="_blank">EPM System Certification Matrix document</a> will undoubtedly be updated to match this information soon. The .700 patches must be applied to all EPM products in each environment so you have to be patient and wait for all of them to become available. Have a look at the readme files for each individual patch as there are numerous fixes made to the products. Also note the prerequisites as some of the patches seem to rely on newly released ADF patches.</div>
<div>
<br /></div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com3tag:blogger.com,1999:blog-6873528634794784349.post-59128463511066279122015-06-10T14:45:00.000+03:002015-06-11T21:38:18.057+03:00No More Remote XUL Manager!This is a quick post to point out a cool feature in EPM 11.1.2.4 that I have somehow overlooked (thanks to Nicklas Englund for the tip!). In previous EPM versions you had to install an extension called <a href="https://addons.mozilla.org/en-us/firefox/addon/remote-xul-manager/" target="_blank">Remote XUL Manager</a> in order to use EPM web applications with the Firefox browser. The <a href="http://www.oracle.com/technetwork/middleware/bi-foundation/oracle-hyperion-epm-system-certific-131801.xls" target="_blank">EPM System certification matrix document</a> also included a note about this: <em>"Firefox 17+ ESR and 24+ ESR requires Remote XUL Manager 1.0.1 Add-on"</em>. In 11.1.2.4 this requirement has suddenly been removed without so much as a word in the readme file!<br>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_O8gbyqyhiTpHkFkAjYufOImg0u71CCDP6HMFdwB-AEGrxXUjm_ddq7iJhdlSaPOlMIP4wGBEj33JlytAlEKxvWGfR_plbzeIojKfzfXdtjKiqzYLF4KIeTpDCwI6s5mix5xdFAQvFpgB/s1600/epm11124_browser_certification.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="30" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_O8gbyqyhiTpHkFkAjYufOImg0u71CCDP6HMFdwB-AEGrxXUjm_ddq7iJhdlSaPOlMIP4wGBEj33JlytAlEKxvWGfR_plbzeIojKfzfXdtjKiqzYLF4KIeTpDCwI6s5mix5xdFAQvFpgB/s400/epm11124_browser_certification.png" width="400"></a></div>
<br>
<a href="http://hyperionfinn.blogspot.com/2015/06/no-more-remote-xul-manager.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com2tag:blogger.com,1999:blog-6873528634794784349.post-46211825039629379522015-05-26T23:39:00.002+03:002015-05-27T00:05:11.353+03:00The HFM Upgrade Diaries Part 1 - Known IssuesLately I have been busy installing HFM 11.1.2.4 environments for several local customers. In this series of blog posts I will share my experiences about these upgrades - hopefully making life a bit easier for other early adopters.<br>
<br>
<br>
<b><span style="font-size: x-large;">Known Issues In HFM 11.1.2.4</span></b><br>
<br>
In this first post I will list the most notable problems I (and my colleagues) have ran into so far.<br>
<div>
<br>
</div><a href="http://hyperionfinn.blogspot.com/2015/05/the-hfm-upgrade-diaries-part-1-known.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com8tag:blogger.com,1999:blog-6873528634794784349.post-21589873413898338862015-04-21T19:35:00.001+03:002015-04-21T19:35:18.149+03:00HFM 11.1.2.4 - Proven Performance?Since EPM 11.1.2.4 was released in February, we have been busy testing the new release on the Infratects lab servers. It seems that Oracle was not bluffing when they showed us some very promising performance figures in Kscope14... HFM 11.1.2.4 indeed seems to give a nice boost to most of the customer's applications we have tested so far. I did a 2 Minute Tech Tip session with <a href="https://twitter.com/brhubart" target="_blank">Bob Rhubart</a> of <a href="https://www.youtube.com/user/OTNArchBeat" target="_blank">OTN ArchBeat</a> in March in which I shared some of our initial findings. See the video below for this bite-size introduction into what makes the new HFM version so fast.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/E4rifmXkZZE/0.jpg" src="https://www.youtube.com/embed/E4rifmXkZZE?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br />
<br />
My colleague Kieron Cassidy from our Netherlands office has collected the consolidation test results into a nice white paper which you can download from the Infratects website: <a href="http://www.infratects.com/news-and-events/190-wp-hyperion-financial-management-performance-improvement" target="_blank">White Paper: Hyperion Financial Management 11.1.2.4 - Real Performance Improvements</a><br />
<br />
Personally I have installed two EPM 11.1.2.4 environments for different customers so far. These are Development/Test environments, with first Production ones scheduled to be implemented in May. There are plenty of upgrade projects in the pipeline and it's nice to see that customers are willing to give this version a try. Watch this space as I'm planning to post new stuff about the release soon!Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com3tag:blogger.com,1999:blog-6873528634794784349.post-74554562140899240142015-03-17T15:46:00.000+02:002015-05-05T15:39:20.195+03:00Steps To Completely Uninstall EPM 11.1.2.x + Greetings From Top Gun 2015<div class="separator" style="clear: both; text-align: center;">
<br /></div>
I returned from the Infratects Top Gun conference on Sunday. The event, this time held in London, was once again a great opportunity to get insights on the latest EPM release (straight from Oracle Product Development of course) and meet lots of like-minded people. The presentations (except the ones from Oracle devs, I assume) will be published on the event's web site soon. See <a href="http://www.infratects.com/topgun" target="_blank">http://www.infratects.com/topgun</a><br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvx5EaQ8XG28YRevU1AqcyQVtMGMTccxclGZ7AXzeNKLFRLw8e2koKPWxZWNKsFsObXYPE9StUaMNtHqP6fnzJgiIjFt6pmCtVfmUlEKPMAW_rto4K006x3rz0S7srz5KAY2XCFIc5_0N3/s1600/2015-03-13+10.03.47.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvx5EaQ8XG28YRevU1AqcyQVtMGMTccxclGZ7AXzeNKLFRLw8e2koKPWxZWNKsFsObXYPE9StUaMNtHqP6fnzJgiIjFt6pmCtVfmUlEKPMAW_rto4K006x3rz0S7srz5KAY2XCFIc5_0N3/s1600/2015-03-13+10.03.47.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Opening speech by Soner Bekir</td></tr>
</tbody></table>
<br />
<br />
To get back into blogging I thought I'd start with an easy post. Oracle has published an article yesterday that helps in case you need to get rid of all EPM products installed on a server. There are quite a few tasks to carry out so the list acts as a useful reminder even if you already know all the bits you need to clean up.<br />
<br />
<ul>
<li>Oracle Support: <a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=1140553.1" target="_blank">Perform a Clean Uninstall of EPM 11.1.2 on Microsoft Windows (Doc ID 1140553.1)</a></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGDYR19ZB_CeOOo_HBoDhUks1N6LtjUKlzdS4syKMWq3vCXvrbG4k3Jr7gDozqhSsD6SU0nvBXf09vEaq3pkZ69ZPpiW6l1I0oPkfNakyLoTQb48luCUH66Q3Ob2grWvqr7wCqiuMFyuvd/s1600/support-uninstall+epm.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGDYR19ZB_CeOOo_HBoDhUks1N6LtjUKlzdS4syKMWq3vCXvrbG4k3Jr7gDozqhSsD6SU0nvBXf09vEaq3pkZ69ZPpiW6l1I0oPkfNakyLoTQb48luCUH66Q3Ob2grWvqr7wCqiuMFyuvd/s1600/support-uninstall+epm.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
And a couple more photos from Top Gun to wrap things up properly:<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOrhuDH-PyQ4juPip3_v098OucDTphIEd9IrZYmYTTPdzeG-2d_L63IyM10lUHQpwSD70SKztAEvSmAPmGKbDFyFs5gjggNYYVaaxZv96YH6oAISTL78M22im9ru3HpZVu2T31pEKiumEC/s1600/2015-03-13+12.07.39+curro+presenting.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOrhuDH-PyQ4juPip3_v098OucDTphIEd9IrZYmYTTPdzeG-2d_L63IyM10lUHQpwSD70SKztAEvSmAPmGKbDFyFs5gjggNYYVaaxZv96YH6oAISTL78M22im9ru3HpZVu2T31pEKiumEC/s1600/2015-03-13+12.07.39+curro+presenting.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Francisco giving a presentation on FDMEE</td></tr>
</tbody></table>
<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnJK6Mw2h2dFolM_mSgIEV_lXCzgTrHYhzX_XFnkX44yaRh2_aiT2NjQfIZjncAwh7oLTCE1fZaa1jSAp3_2znm3A0ZU2wnZVGGJ2S84y6Di6iuEUOXjhds9_7H2eZUKuU8IZjRkvErLBo/s1600/2015-03-13+18.51.06+double+decker.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnJK6Mw2h2dFolM_mSgIEV_lXCzgTrHYhzX_XFnkX44yaRh2_aiT2NjQfIZjncAwh7oLTCE1fZaa1jSAp3_2znm3A0ZU2wnZVGGJ2S84y6Di6iuEUOXjhds9_7H2eZUKuU8IZjRkvErLBo/s1600/2015-03-13+18.51.06+double+decker.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Traditional transport to the social event</td></tr>
</tbody></table>
<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp6il57xyGLAt-CVHeaM2wHz8MVmCGYPJLQK1soZJboDoklrcUQp4KIWL3zWCKcFyAp6EWWdiFCPR-Iv_PymUrKOORoR_VWm1fKQf_U5LCcsXizUSADQC5TmrCEbIPzcTA3fpuxLtYNV5k/s1600/2015-03-13+20.24.28+dinner.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp6il57xyGLAt-CVHeaM2wHz8MVmCGYPJLQK1soZJboDoklrcUQp4KIWL3zWCKcFyAp6EWWdiFCPR-Iv_PymUrKOORoR_VWm1fKQf_U5LCcsXizUSADQC5TmrCEbIPzcTA3fpuxLtYNV5k/s1600/2015-03-13+20.24.28+dinner.jpg" width="240" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Dinner served high on the Tower Bridge walkway</td></tr>
</tbody></table>
<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsSlCtdDEYAa9uScWN5waM5hfw_Ix37irKru_3iNZ_q0b-MDqM3sOBfM00G-fI676QKHl-P7WeDKKhLCe8UQDqmtUsHfFS5BdqYMehvrOKxY1d-rktTHL3XtN-wCRWKU1-w9nFOL-a3g4o/s1600/2015-03-14+17.58.27.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto; text-align: center;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsSlCtdDEYAa9uScWN5waM5hfw_Ix37irKru_3iNZ_q0b-MDqM3sOBfM00G-fI676QKHl-P7WeDKKhLCe8UQDqmtUsHfFS5BdqYMehvrOKxY1d-rktTHL3XtN-wCRWKU1-w9nFOL-a3g4o/s1600/2015-03-14+17.58.27.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">The mandatory tourist photo</td></tr>
</tbody></table>
<div>
</div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com0tag:blogger.com,1999:blog-6873528634794784349.post-54860154372249838442015-02-05T12:54:00.001+02:002015-02-05T12:54:39.280+02:00HFM 11.1.2.4 Running On Commodity LinuxHFM 11.1.2.4 was released by Oracle last week. The talks about platform independency got many EPM professionals excited - and then disappointed when they learned that besides Windows Server you can only run HFM on Oracle Exalytics. But some Exalytics servers run on Oracle Linux, right? Could HFM be installed and configured to run on a commodity Linux box? Just for the fun of it I tried and managed to get it working!<div>
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKmjgNfscm2CZO8CbVx-v1Yl_PtjK78ax65QwMBDN5PWtIl5CrK1CnXS7xSGFe6Hko36xJT4lGF2VWmbUmIco0U8BGENvNGqb5QEdzWZHCEr9M2D3aEJ1VWvfJ85s23kxm1x7rVlRoDTur/s1600/hfmlinux02-UI+and+uname.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKmjgNfscm2CZO8CbVx-v1Yl_PtjK78ax65QwMBDN5PWtIl5CrK1CnXS7xSGFe6Hko36xJT4lGF2VWmbUmIco0U8BGENvNGqb5QEdzWZHCEr9M2D3aEJ1VWvfJ85s23kxm1x7rVlRoDTur/s1600/hfmlinux02-UI+and+uname.png" height="181" width="320"></a></div>
<div>
</div><a href="http://hyperionfinn.blogspot.com/2015/02/hfm-11124-running-on-commodity-linux.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com17tag:blogger.com,1999:blog-6873528634794784349.post-24176824982563162042015-01-30T22:01:00.002+02:002015-04-22T11:26:55.727+03:00Say Hello To HFM 11.1.2.4As many of you may already have heard, the Oracle EPM release 11.1.2.4 was made available <a href="http://www.oracle.com/technetwork/middleware/epm/downloads/index.html" target="_blank">on Oracle Technology Network</a> earlier this week. Social media has been abuzz with activity since and many bloggers have already written posts about all the new features. Instead of making another set of installation screenshots I wanted to take a closer look at Hyperion Financial Management as HFM is the product that has gone through most changes in this version.<br>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxPArzjNfHo6YnnLoCqhjoVDJYMXN6z6FU-xYwbuF7b71ak5qlfRyXCvsh6XBCp3E7tjupu4gHIjIKqyXVDsux_yHJ9GcQFDJsnhxVnAADiVkwaCvjCnnSWHYi5EFhNqrj3V_8xd_2MC8x/s1600/image33crop.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxPArzjNfHo6YnnLoCqhjoVDJYMXN6z6FU-xYwbuF7b71ak5qlfRyXCvsh6XBCp3E7tjupu4gHIjIKqyXVDsux_yHJ9GcQFDJsnhxVnAADiVkwaCvjCnnSWHYi5EFhNqrj3V_8xd_2MC8x/s1600/image33crop.png" height="51" width="320"></a></div>
<br>
<a href="http://hyperionfinn.blogspot.com/2015/01/say-hello-to-hfm-11124.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com14tag:blogger.com,1999:blog-6873528634794784349.post-30023125534729585812015-01-13T16:43:00.003+02:002015-11-17T14:49:42.505+02:00Oracle EPM, IE11 and Enterprise Mode ExplainedThe following message and the Bindows information page are familiar to those who have attempted to use current Oracle EPM versions with Internet Explorer 11. In August last year Oracle published an article stating that use of Internet Explorer 11 is now supported with EPM versions 11.1.2.2 and 11.1.2.3 as long as you use Enterprise Mode in the browser. In this post I will explain what Enterprise Mode is and how you can enable it for your EPM environment.<br>
<br>
Note that later EPM releases 11.1.2.3.700 and 11.1.2.4 are tested and certified with IE11 and they do not require Enterprise Mode to be configured in the browser.<br>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaG_x1jjirFd1nDB_4_9SsTQq33n00YrLlFbo-cvpGBXmccOSN4OxBaZJPcF4TbIOhs_zft029128BXQXpN4P-8rliitETvUfZrg-Woj3eInFvIo-PpCRSoaWNIplo7MU6nuplXNj2I5Lw/s1600/ie11-unsupported.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaG_x1jjirFd1nDB_4_9SsTQq33n00YrLlFbo-cvpGBXmccOSN4OxBaZJPcF4TbIOhs_zft029128BXQXpN4P-8rliitETvUfZrg-Woj3eInFvIo-PpCRSoaWNIplo7MU6nuplXNj2I5Lw/s1600/ie11-unsupported.png" width="320"></a></div>
<br>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvDW0oC4_BwS2baYFnVxPkXES98gBWSvvoUTL8GosB4uUICD6vn_BieoGQ7Ln23GPk5bcdswqY366_zrV4iGZFOWnTmqL1ZhHjZIIdkzXIduggLDYvv5OBhtk6XTiLuircX8feCX9U3I4Z/s1600/ie11-bindows.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="202" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvDW0oC4_BwS2baYFnVxPkXES98gBWSvvoUTL8GosB4uUICD6vn_BieoGQ7Ln23GPk5bcdswqY366_zrV4iGZFOWnTmqL1ZhHjZIIdkzXIduggLDYvv5OBhtk6XTiLuircX8feCX9U3I4Z/s1600/ie11-bindows.png" width="320"></a></div>
<br>
<a href="http://hyperionfinn.blogspot.com/2015/01/ie11-and-enterprise-mode-explained.html#more">Read more »</a>Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com17tag:blogger.com,1999:blog-6873528634794784349.post-28678147073374353882015-01-08T15:33:00.000+02:002015-01-08T16:04:13.942+02:00HFM Base Level Data Extracts Via LCMStarting with EPM 11.1.2.3 it is now possible to extract base level data from HFM applications using LCM. This is a handy way to back up your level 0 data without using third-party tools.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYijYLZk1oKpdGk-v3-38Gi5_BXcftIIgXhCzdCZaKBNbPjZXCZaKSUMwNbNn9SE7To6wQk9j9D8JJK6klDTbBVdpq-hbl55MHCRbtk07KsLoUmvSxazMIVoUWd97wJAajs90hPSd4TDTf/s1600/lcm-hfm+base+level+data+extract.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYijYLZk1oKpdGk-v3-38Gi5_BXcftIIgXhCzdCZaKBNbPjZXCZaKSUMwNbNn9SE7To6wQk9j9D8JJK6klDTbBVdpq-hbl55MHCRbtk07KsLoUmvSxazMIVoUWd97wJAajs90hPSd4TDTf/s1600/lcm-hfm+base+level+data+extract.png" height="195" title="Base Level Data extract" width="320" /></a></div>
<br />
There is one requirement for this functionality that is easy to overlook in distributed environments though. <i>(excerpt from the <a href="http://docs.oracle.com/cd/E40248_01/epm.1112/epm_lcm_user/launch.html" target="_blank">EPM System Lifecycle Management Guide</a>)</i><br />
<blockquote class="tr_bq">
<i>In order to export or import Financial Management Data artifacts in a distributed EPM installation, Lifecycle Management must have a shared file system path. The domain account that has access to this shared/disk folder should be used to start services. Configure hfmLcmServiceAppPool(IIS) with this domain account.</i></blockquote>
<br />
If you have a two-server setup with web components installed on machine called "WebServer" and HFM application server components on "AppServer" you will need to make a small change to the default Foundation Services configuration.<br />
<br />
<ul>
<li>Share the default import_export folder (usually looks like D:\Oracle\Middleware\user_projects\epmsystem1\import_export) so that the share is writable by local Administrators <u>and</u> by the HFM DCOM account (also verify the file system permissions)</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidKEK8nV6mVgpbVO58jfdtLMKhILHm42vqMj3z0Zak5RCNHmb5q_dPqAF_M430uQoFVaoX33yEXZHBCUX017F3TyCEUuOcOEZFvhB8C4dFYc-oRuMZsKyuObdj8o-RbMq1z3zvuSVtk1oY/s1600/lcm-import_export+share.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidKEK8nV6mVgpbVO58jfdtLMKhILHm42vqMj3z0Zak5RCNHmb5q_dPqAF_M430uQoFVaoX33yEXZHBCUX017F3TyCEUuOcOEZFvhB8C4dFYc-oRuMZsKyuObdj8o-RbMq1z3zvuSVtk1oY/s1600/lcm-import_export+share.png" height="226" width="320" /></a></div>
<br />
<ul>
<li>Stop all EPM services</li>
<li>Use EPM System Configurator to modify the LCM import/export path to point to the shared folder (in my example \\webserver\import_export). After finishing the task in Config Utility you can verify the change by running EPM System Registry Editor from the Start menu and by searching for "filesystem.artifact.path". Note that in case the share is created locally you shouldn't need to change the login user for the Windows service that starts Foundation Services.</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdo_ajtunnCXfypG8ltI9EIIVlWH56w8EbEoTRh2BVynj7lC87IE3XgCwM43uAPf3L5W2jAIGx4ZeXqGGm05fRo1QN2TbrJTq9Hz44-ZA8s8uRKGOKv5pFQ2SPhl2qywHZm8xYrU-nlVPY/s1600/lcm-change+path1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdo_ajtunnCXfypG8ltI9EIIVlWH56w8EbEoTRh2BVynj7lC87IE3XgCwM43uAPf3L5W2jAIGx4ZeXqGGm05fRo1QN2TbrJTq9Hz44-ZA8s8uRKGOKv5pFQ2SPhl2qywHZm8xYrU-nlVPY/s1600/lcm-change+path1.png" height="136" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgmFKRRfR7-eVVlr_sUZrx8HbfsANG0SWyeysjZ7CGE0UwrSk4fW2rPHTSBmsP2UTVY2Dy7doq_O6UttxKh-0yrYUtunPFaB0DqF3ic9lSyLIwQpy4VOQYhDybgOgmfDfvblPWC0H16Mxf/s1600/lcm-change+path2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgmFKRRfR7-eVVlr_sUZrx8HbfsANG0SWyeysjZ7CGE0UwrSk4fW2rPHTSBmsP2UTVY2Dy7doq_O6UttxKh-0yrYUtunPFaB0DqF3ic9lSyLIwQpy4VOQYhDybgOgmfDfvblPWC0H16Mxf/s1600/lcm-change+path2.png" height="180" width="320" /></a></div>
<br />
<ul>
<li>Start up EPM services and test that LCM is still able to read and write to the import/export folder.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ9Uz_6bsS7J042lTwgb6w10D3lRdK0-k7ImAi3qJZK64oMlFqB3wiMIM3SuhTmTWZ2gzjhQNztgNDBYrEhBBUUtNzT73Y5spvlv_21Rarv_17BaPWMdN_CzwOlWDSkMhNHP5VGkTLSFix/s1600/lcm-change+path3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ9Uz_6bsS7J042lTwgb6w10D3lRdK0-k7ImAi3qJZK64oMlFqB3wiMIM3SuhTmTWZ2gzjhQNztgNDBYrEhBBUUtNzT73Y5spvlv_21Rarv_17BaPWMdN_CzwOlWDSkMhNHP5VGkTLSFix/s1600/lcm-change+path3.png" height="87" width="320" /></a></div>
<div>
<br /></div>
<div>
<ul>
<li>Finally start a base level data extract from HFM to verify that the configuration is working. The data extract should appear as a gzip file in \\webserver\import_export\HFM data extract\HFM-APPNAME\resource\Application Base Level Data. You can open the file using a third-party tool such as <a href="http://www.7-zip.org/" target="_blank">7-zip</a>.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyhiU65Njasx-x5UXQKcnYtAXt6pp_sUiVikeoBoafHC_YBGf-Rq_lYCgcO-6Wu8zAEritnAmqnymfB8c0Qp-Th2z1bAPlXUtx856QZChY2A6n6ed3JVO2KUX-1U3WcAhT8TQ3uTm_jxi2/s1600/lcm-change+path4a.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyhiU65Njasx-x5UXQKcnYtAXt6pp_sUiVikeoBoafHC_YBGf-Rq_lYCgcO-6Wu8zAEritnAmqnymfB8c0Qp-Th2z1bAPlXUtx856QZChY2A6n6ed3JVO2KUX-1U3WcAhT8TQ3uTm_jxi2/s1600/lcm-change+path4a.png" height="137" width="320" /></a></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9K_UqkqsXXwaTJh8lC2FZU2Hm0Ig4RFtVdW6NEY3804mxYU9yjpe-4AYsr1_x1ogVdOBCweeeMiAJsro4DChPciPOPNAVzImCljvKZsBXD7uvDcirbbqwMl1uLu0loeuV9MmhB4T8vtq8/s1600/lcm-change+path4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9K_UqkqsXXwaTJh8lC2FZU2Hm0Ig4RFtVdW6NEY3804mxYU9yjpe-4AYsr1_x1ogVdOBCweeeMiAJsro4DChPciPOPNAVzImCljvKZsBXD7uvDcirbbqwMl1uLu0loeuV9MmhB4T8vtq8/s1600/lcm-change+path4.png" height="105" width="320" /></a></div>
</div>
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhADx3ZWH32w_vucZxjwk5KiQ8iv6Ww_SxK7evfPQcNe73aDNG1XVMkqnu175YotWpWyKfk0G3xi3zCihL6RByBatUJQKJ-HjT68GG3wBfgRWhY3aXTMA7mVCVN-FK7v0WNt14jcZysWQMZ/s1600/lcm-change+path5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhADx3ZWH32w_vucZxjwk5KiQ8iv6Ww_SxK7evfPQcNe73aDNG1XVMkqnu175YotWpWyKfk0G3xi3zCihL6RByBatUJQKJ-HjT68GG3wBfgRWhY3aXTMA7mVCVN-FK7v0WNt14jcZysWQMZ/s1600/lcm-change+path5.png" height="81" width="320" /></a></div>
<br />
<br />
Some notes about the way the extract process works (may be useful for troubleshooting):<br />
<ul>
<li>Data is initially extracted to the HFM working folder on the application server (for example D:\Oracle\Middleware\user_projects\epmsystem2\products\FinancialManagement\Server Working Folder\AppServerName_WorkingData_APPNAME) - this is done by the hsvdatasource.exe process</li>
<li>Hsvdatasource.exe copies the produced data file from the working folder directly to the LCM import/export folder defined in HSS Registry. This is why the modification described above is needed.</li>
<li>Some of the metadata files used in the process are transferred via the HFM FileTransfer folder (e.g. D:\Oracle\Middleware\user_projects\epmsystem1\products\FinancialManagement\Web\FileTransferData on the web server). Make sure the IIS application pools have write access to this directory.</li>
<li>The following error appears in HsvEventLog.log on the application server if the import/export folder is not properly configured as a share: "An unknown error occurred - Param: D:/Oracle/Middleware/user_projects/epmsystem1/import_export/MyExportFolderName/HFM-APPNAME/resource/Application Base Level Data/Data.gz."</li>
<li>The following error is produced in Foundation Services log file SharedServices_LCM.log if the import/export folder is not properly configured as a share: "[FoundationServices0] [ERROR] [EPMLCM-30034] [oracle.EPMLCM] [tid: 176] [userId: <anonymous>] [ecid: 00iQfXqUa0zFw00Fzzw0w00001ZS000ZAL,0:1:4:3:4:3:4:3:1:1:1:1] [APP: SHAREDSERVICES#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.lcm.product.manager.WebServiceProductManager] [SRC_METHOD: exportArtifacts:717] Failed in communicating to Hyperion Financial Management remote service at URL "http://webserver:80/hfmlcmservice/LCMWS.asmx" during "export" operation for application name "APPNAME" and cluster name "HFMCLUSTR". Nested exception is [[ org.apache.axis2.AxisFault: javax.xml.stream.XMLStreamException: Premature end of file encountered"</li>
</ul>
<div>
<br /></div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com3tag:blogger.com,1999:blog-6873528634794784349.post-67002845694812446812014-11-25T21:05:00.000+02:002014-11-25T21:10:20.611+02:00Essbase Analytics Link Gets UpdatedOracle Essbase Analytics Link for Hyperion Financial Management (let's just say "EAL") is a very handy product if you want to take data out of HFM and create reports out of it in Essbase (or using OBIEE for example). The product is not quite integrated with the rest of the Oracle EPM product suite though and it also hasn't received too many updates lately. Now it looks like EAL has awakened from its slumber as Oracle has produced Patch Set Update 11.1.2.2.400 for the product. The most important change is that EAL finally has official support for the EPM 11.1.2.3 release:<br />
<blockquote class="tr_bq">
<i>Analytic Links 11.1.2.2.400 can be used with the Oracle Enterprise Performance Management System 11.1.2.2.xxx and 11.1.2.3.xxx EPM System releases only. Pre-11.1.2.2.xxx EPM System releases are not supported.</i></blockquote>
Another new feature is that migration of HFM security to Essbase has been improved for more fine grained control when using Shared Services groups with HFM security classes. And as usual, lots of bugs have been squashed. See the Patch Details page on Oracle Support for full description of the update: <a href="https://support.oracle.com/rs?type=patch&id=17395188" target="_blank">Oracle Essbase Analytics Link for Hyperion Financial Management Patch Set Update (PSU): 11.1.2.2.400</a><br />
<br />
Note that this update requires a full installation of EAL (uninstall previous version, install updated one, configure the updated version).Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com0tag:blogger.com,1999:blog-6873528634794784349.post-64349420419340330372014-09-07T21:01:00.001+03:002014-09-30T16:07:40.139+03:00Smart View Version 11.1.2.5.215 AvailableOracle has released an updated version of their Swiss army knife add-in for MS Office. The installer for Oracle Smart View 11.1.2.5.215 is currently only available in form of a patch on Oracle Support (<a href="https://support.oracle.com/rs?type=patch&id=18977986">Patch 18977986: Patch Set Update: 11.1.2.5.215 for Oracle Smart View for Office</a>) but I expect the <a href="http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html">Smart View page on OTN</a> also to be updated soon.<br />
<br />
As of this version Smart View is certified with <b>Windows 8.1</b>. Most of the other changes are bug fixes to make the add-in work more smoothly with Oracle BI products but a handful of other issues have been addressed as well. As always, have a look at the <a href="https://updates.oracle.com/Orion/Services/download?type=readme&aru=17999277">readme file on Oracle Support</a> to get the full details. Also note that two server-side patches are required in order to get full benefits of the fixes related to OBIEE.<br />
<br />
<b>Update: </b>Oracle has now released a knowledge base document on My Oracle Support to clarify supported OS and Office versions and interoperability between Smart View and other Oracle products:<br />
<ul>
<li><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=1923582.1" target="_blank">Smart View Support Matrix and Compatibility FAQ (Doc ID 1923582.1)</a></li>
</ul>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com3tag:blogger.com,1999:blog-6873528634794784349.post-79395211135787742014-08-18T17:48:00.003+03:002014-08-22T10:20:47.532+03:00EPM Product Versions Supported By Smart ViewThe Oracle EPM System Supported Platforms document, often also called the <a href="http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html" target="_blank">Certification Matrix</a>, includes a compatibility chart that can be used to determine interoperability between EPM versions and other Oracle software (such as the versions of ODI you can use with Essbase 11.1.2.3). When Smart View started living a life of its own after the 11.1.2.5 release, the product was removed from the common EPM certification matrix. This change has made it harder to figure out what exact EPM versions you can use with the latest Smart View release; even the readme files included with the SV installer do not mention this information anymore. It seems that the following Support articles are the only place for finding this knowledge at the moment:<br />
<ul>
<li><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; mso-ansi-language: FI; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: FI; mso-fareast-theme-font: minor-latin;"><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=1321453.1" target="_blank"><span style="font-family: "Times New Roman","serif";">Available Patch Sets and Patch Set Updates for Oracle Hyperion Financial Management (HFM)</span></a></span></li>
<li><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; mso-ansi-language: FI; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: FI; mso-fareast-theme-font: minor-latin;"><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=1395593.1" target="_blank"><span style="font-family: "Times New Roman","serif";">Available Patch Sets and Patch Set Updates for Oracle Hyperion Planning</span></a></span></li>
<li><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=1396084.1" style="font-family: 'Times New Roman', serif; font-size: 12pt;" target="_blank">Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase</a></li>
</ul>
<br />
To make life easier for EPM admins I decided to collect the Smart View specific information from the articles in the table below (status for Smart View 11.1.2.5.210 as of August 18th 2014). Please use the links above to double check the latest Smart View version in case you are reading this post later.<br />
<br />
<b>EPM System product versions supported by Smart View 11.1.2.5.210:</b><br />
<b><br /></b>
<br />
<table style="border: 1px solid rgb(204, 204, 204); font-family: Arial, Helvetica, sans-serif; font-size: 10pt; text-align: left;">
<tbody>
<tr style="background-color: #104e8b; color: white;"><th style="border: 1px solid #CCC;">Essbase*</th><th style="border: 1px solid #CCC;">HFM</th><th style="border: 1px solid #CCC;">Planning</th></tr>
<tr><td style="border: 1px solid #CCC;">11.1.1.3.500</td><td style="border: 1px solid #CCC;">11.1.1.3</td><td style="border: 1px solid #CCC;">11.1.1.3</td></tr>
<tr><td style="border: 1px solid #CCC;">11.1.1.4</td><td style="border: 1px solid #CCC;">11.1.1.4</td><td style="border: 1px solid #CCC;">11.1.1.4</td></tr>
<tr><td style="border: 1px solid #CCC;">11.1.2.x</td><td style="border: 1px solid #CCC;">11.1.2.x</td><td style="border: 1px solid #CCC;">11.1.2.x</td></tr>
</tbody></table>
<div style="text-align: center;">
<div style="text-align: left;">
<br />
<br /></div>
<div style="text-align: left;">
*) Note: Some Essbase specific features introduced in Smart View client version 11.1.2.1.102 are only available when you use Essbase server 11.1.2.1.102 or later release.</div>
<div style="text-align: left;">
<br /></div>
</div>
Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com0tag:blogger.com,1999:blog-6873528634794784349.post-18590616198006276152014-07-19T23:11:00.001+03:002014-07-19T23:14:52.058+03:00PSU 11.1.2.2.500 And Other New PatchesI'm still enjoying my summer holiday but wanted to briefly switch into working mode just to point out that the long-awaited Patch Set Update 11.1.2.2.500 has now been released. The Oracle Business Analytics Proactive Support blog sums the patch up nicely in their post <a href="https://blogs.oracle.com/proactivesupportEPM/entry/psu_epm_11122_500" target="_blank">Patch Release: EPM 11.1.2.2.500</a>. I find it quite odd that the readme file for 11.1.2.2.500 does not specifically mention added support for Internet Explorer 10 even though this is considered the most important change in this patch bundle. The <a href="http://www.oracle.com/technetwork/middleware/bi-foundation/oracle-hyperion-epm-system-certific-131801.xls" target="_blank">EPM Certification Matrix document</a> has been updated to include new browser specific information for 11.1.2.2 though.<br />
<blockquote class="tr_bq">
"Internet Explorer 10.x is supported only in 11.1.2.2.500, and only with Windows 7 and Windows 8."</blockquote>
<br />
Several EPM products have recently received new updates in the 11.1.2.3 code branch as well. See the following blog post for more details: <a href="https://blogs.oracle.com/proactivesupportEPM/entry/epm_psu_201406" target="_blank">EPM Patch Set Updates - June 2014</a>. Note that the HFM PSU .501 (patch nr. 18792393) is also available although it's not included in the list.<br />
<br />Henri Vilminkohttp://www.blogger.com/profile/16367799771321317998noreply@blogger.com0