Technology Blueprints & Strategy with Gary Crisci

Ran into this issue a little while back and with HFM 11.1.2.4 it was a little tricky to figure out, so I thought it was worth posting. Problem Smartview users get a pop-up when connecting to HFM provider that there is a newer version of Smartview and for them to upgrade. Many of our customers have stated they do not want users upgrading Smartview versions with each update and do not want Smartview to prompt them to do so. Solution The solution to this can be found in Oracle Knowledge Document  1993603.1 Please make sure you have a backup of your system before making any changes . As these options are now removed from the EPM configurator, the following steps can be followed to turn off the warning messages.  1. Log On to the shared services console.  2. Expand Application Groups>Foundation>Deployment Metadata  3. Financial Management> LWA-hfmadf  4. Select> Properties > right click 5. Export export to some local drive and ...

When troubleshooting an EPM issue, reviewing log files is an important step.  The following explains how to find EPM log files on the Exalytics T5 (Solaris) Step-by-step guide Connect to the host using a supported tool such as WinSCP, Filezilla, PuTTy, vSSH, etc. cd to the following directories Essbase server - cd  /u01/Oracle/Middleware/user_projects/{host}/diagnostics/logs/essbase/essbase Essbase application - cd /u01/Oracle/Middleware/user_projects/{host}/diagnostics/logs/essbase/essbase/app/{app} Essbase Studio - cd /u01/Oracle/Middleware/user_projects/{host}/diagnostics/logs/EssbaseStudio HFM - cd /u01/Oracle/Middleware/user_projects/{host}/diagnostics/logs/hfm Planning - cd /u01/Oracle/Middleware/user_projects/{host}/diagnostics/logs/planning Weblogic - cd  /u01/Oracle/Middleware/user_projects/domains/EPMSystem/servers/{JVM_name}/logs Install - cd  /u01/Oracle/Middleware/EPMSystem11R1/diagnostics/logs Opatch / Confi...

As more people continue to move away from IE and adopt Firefox as the default Oracle EPM browser, some run into an annoying little issue. When performing a right click in Workspace, using Firefox browser, the Firefox shortcut menu overlays the Oracle Workspace menu making it difficult to access the Oracle menu items. A quick way to get to the Oracle menu is to press the escape key, but having to do that all the time can be annoying. There is a setting in Firefox that drives this behavior.   The solution to this is to change the Context Menu option in Firefox to True.  Basic solution 1) Open Firefox and type 'about:config' in the search bar 2) Search for ' dom.event.contextmenu.enabled and change value to 'true' You can now go into Workspace and the right click menu will work as expected. Advanced solution We actually had an interesting time with this for a while.  Once we figured out how to correct the issue we were ge...

Introduction Back when Essbase version 7 came out and we were introduced to ASO, Hyperion also introduced us to MDX.  It was added as the calculation language for member formulas in ASO cubes but we also were able to use it as a query language against the database.  As a bonus we were not limited to just ASO we could write queries against BSO databases too.  Having a powerful query language similar to SQL had tremendous potential for Essbase.  We could write complex scripts to pull very specific data from our cubes and even had the ability to create custom members and sets in the queries alleviating the need to modify the actual outline just to get a calculated result. Overtime the MDX query language has been improved and Oracle has done some very cool things with it behind the scenes to drive things like OBIEE.  For the average power user though, MDX for Essbase had one major limitation; there was no good way to get the results of the query in a useable for...