Thursday Jun 13, 2013

Advisor Webcast: Preparing EPM in an Linux VirtualBox Environment

Proactive Support will be presenting a one-hour session for those technical and functional EPM users out there who are unfamiliar with Unix/Linux installations and want to know more.

This is being hosted:

  • June 26, 2013 at 10 am ET, 9 am CT, 8 am MT, 7 am PT, 3:00 pm, GMT Summer Time (London, GMT+01:00),
  • June 27, 2013 at 12:00 am, Australia Eastern Standard Time (Sydney, GMT+10:00)

For registration details visit  Doc ID 1553385.1

The session will cover topics that include:

  • Installation and setup of Virtual Box (Oracle virtual machine software)
  • Installation and configuration of Oracle Linux in Virtual Box (setting up 'yum' for library updates)
  • Installation and configuration of Oracle database 12.0.1 on Linux
  • Installation and run of RDA hcve pre-install check (with updates as appropriate)
  • Installation and Configuration of EPM
  • Validation of EPM
To view all scheduled Enterprise Performance Management (EPM) Advisor Webcasts and archived recordings of previously hosted sessions be sure to visit:

Wednesday Jun 05, 2013

How to read product versions: " .x" versus " +"

(in via Lia)

You may have come across the different ways that Development uses to indicate more than one version of a Product,

namely " .x" vs " +".

While working through our certification documentation some people came across this and had a little chat with Development about it. Here is the simple yet easy to understand response that they got:

" .x"
in, the "x" indicates to include:,,

" +"
in, the "+" indicates any higher version of the same codeline e.g.,,

but not 11.1.2... nor 12...

One minimal yet important difference is, that the "+" usually is NOT separated by a dot, while the x is. So the versions referenced by the "+" are one level up from those referenced by the ".x"

We hope that this settles the question once and for all. So the next time you need to check a product compatibility via the product matrices or the certification tab, you will no longer have to worry about the question if JRE 1.6_34+ includes JRE 1.7_15 or not - you now know that it does not.

Tuesday Jun 04, 2013

Oracle Business Analytics Support News - volume 8 released

(in via Paul)

Thanks to the hard work of Paul who is collecting all the incoming changes and updates, the latest volume of the Oracle Business Analytics Support News has just been published.

You can find this edition in  KM Doc Id 1347131.1

This quarters BA Support News features information about:

  • the release of EPM
  • the release of OBIEE
  • the release of OBIA
  • features of Oracle Diagnostic logging (ODL)
  • Certification
  • Community changes
  • the EPM System Cumulative Feature Overview Tool
  • latest patch set updates
  • product retirements
  • upgrade advisors
  • Information centers
  • and lots more....
It even lets you know how to subscribe to the BA Support News, so you do not miss the next edition.

If you are working within the EPM environment, I would recommend having a look - you will hardly find a more complete overview of what is going on in EPM/BA, so at least bookmark this KM Doc and check regularly what's new.

Friday May 24, 2013

Oracle EPM supported platforms (refresher)

We have mentioned this before in a number of blogposts. But as the functionality is on the rather new side and as people tend not to read old blogposts, I have decided to give you another round of "How to use the certification tab in on "My Oracle Support"".

Step 1)
You may or may not have noticed the tab "Certification" on MOS. Chances are, you never clicked on it, as you were too busy logging a new Service Request for your current issue.
Let us discover what this can do for you in four easy screenshots.

(click to enlarge in new window)

Step 2)
Clicking on this tab will not only take you to the certification search part, but also sports a number of links on the left. These include information about the state of the certification tool, the Oracle lifetime policy and a link to the video outlining the use of this tool.

(click to enlarge in new window)

Step 3)
In this case we are looking for information on Essbase v on Windows 2008 R2 (64-bit) - let us see what we can get back from the certification tool

(click to enlarge in new window)

Step 4)
Not only can we instantly see that this version of Essbase is compatible with Win2K8R2x64 but we also see a list of Supported Databases and the versions supported, the OS itself and the JDK that can be used.

(click to enlarge in new window)

With a search that goes for the entire EPM System, we get the following result - note the additional information you find at the bottom that can take you to a more specific product related view.

(click to enlarge in new window)

I have had a look at earlier blogposts here and found a few related to certification / supported platforms - so in case your product is not yet covered by the MOS tab, you may want to give these a visit to find the information you are looking for:

Thursday May 23, 2013

OBIA - revised installation guide has been published

(in via Lia)

We just had word from Development, that a new and updated installation guide for Oracle Business Intelligence Applications (OBIA) has been published.

Anyone planning to install version of OBIA is advised to use this installation guide. You can find it here:

Tuesday May 21, 2013

Advisor Webcast: Financial Reporting Reports troubleshooting

there will be an Advisor Webcast tomorrow (22nd of May 2013) about

Troubleshooting Financial Reporting Reports.

Kathleen will present us with a number of common errors and mistakes that can lead to non-working reports and she will teach basic troubleshooting skills for Financial Reporting. This may include:

  • How to determine if the issue is report design related.
  • How to triage which components are to be investigated.
  • How to create a small test report.

Find more information on the session on  KM Doc ID 1543237.1

To register for this session, simply go to:

Remember that Advisor Webcasts are free of charge and open to anyone interested in the content.

You can find all our currently scheduled Advisor Webcasts via the KM Doc ID 740966.1

Friday May 03, 2013

OBIEE Bundle Patch released

(in via Lia) bundle patch is now available for download from My Oracle Support for all platforms.

Bundled Patch Details:

  • Patch (1 of 7) Oracle Business Intelligence Installer (BIINST):
    Patch 16504136
  • Patch (2 of 7) Oracle Real Time Decisions (RTD):
    Patch 16504143
  • Patch (3 of 7) Oracle Business Intelligence Publisher (BIP):
    Patch 16504148
  • Patch (4 of 7) Oracle Business Intelligence ADF Components (BIADFCOMPS):
    Patch 16504154
  • Patch (5 of 7) Enterprise Performance Management Components Installed from BI Installer (BIFNDNEPM):
    Patch 16504156
  • Patch (6 of 7) Oracle Business Intelligence: (OBIEE):
    Patch 16427939
  • Patch (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer:
    Patch 16504161

Please refer to the readme file on the Installer download for important installation instructions.

Thursday May 02, 2013

EPM - new Log Analysis tool

(in via Maurice)

Log Analysis is a new and versatile troubleshooting tool which has been bundled with Enterprise Performance Management
Documentation for the tool is available on the command line when running the batch without parameters.

To kick it off, simply run:

/Oracle/Middleware/user_projects/epmsystem1/bin/ or

Log Analysis can scan all the EPM logs in-situ or in an offline hierarchy of log directories pointed to by a path

  • (-d <Offline log files directory> )

Restrictions may include:

  • time in minutes (-tmin 45 )
  • a string (-s "  " )
  • a message series across servers (-ecid "0000JpPDIjn9h^FpN0S4ye1HFRt100000J" )
  • output limited to size in megabytes (-maxsize 5 )
  • optional HTML output name (-o "    " )

You can selectively limit the output to return only those messages with an identifier in a Message_ID filter file.

Output is placed in


and may be reviewed in a browser.

This will then look similar to:

(click to view full size)

Tuesday Apr 30, 2013

EPM - Documentation is online

(in via Mel)

Additional to the EPM Software, the Documentation has also been updated.

You can find it under:

EPM - Essbase - Runtime Substitution Variables

With being out, I would like to point out the biggest change that we got in Hyperion Essbase:

Runtime Subsitution Variables.

They have been documented in the new features guide.

In short - you can now define Substitution Variables on the fly in a Calc Script or MaxL script.
Nice eh?
How do you do it?

The MaxL syntax looks like this:

execute calculation "myscript" on <App>.<DB> with runtimesubvars 'Currmonth = "Jan";';

(make sure that if you have a list of RTSubVars, that you end EACH ONE with a semicolon

execute calculation "myscript" on Sample.Basic with runtimesubvars 'Currmonth=Jan;CurrProd=Cola;';

there is a slight glitch in the documentation about this - we will get that fixed soon)

In a calc script you can simply use

Currmonth = "Jun";

again - multiple need to end on semicolon each:

SET Runtimesubvar {
Currmonth = "Jun";
Currlocation = "Florida";

We were also told that a new function is included in the API to prompt a user for a variable but so far this has not been implemented in any product (MaxL, SmartView, CalcManager, EAS - none of them yet). Products based on the API (e.g. Calc Manager) may in the future make use of that though - so stay tuned.

Along with a few changes to the performance of XREF (should be a lot faster now) and some added calculation functions this is the main change in Essbase.

Monday Apr 29, 2013

EPM is available on eDelivery

(in via Greg)

Word just came in that


is available for download from  eDelivery.

We checked and it really is there (or - in the process of being uploaded ;) )

Plans are, to share some of the new functionality on this blog as we find it in the readme files and docs in the coming few days - so - stay tuned.

Monday Apr 22, 2013

new Oracle BI Apps (OBIA) performance recommendations released

(in via Lia)

We just got note that Development has released a new version of the OBIA 7.9.6.x performance recommendations document.

You can find this in the  KM note Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations [870314.1]

Some of the key points (and really just some in this 134 page long guide):

  • Storage Considerations for Oracle Business Analytics Warehouse
  • Source Environments Recommendations for Better Performance
  • Oracle Warehouse Recommendations for Better Performance
  • Oracle BI Applications Best Practices for Oracle Exadata
  • OBIEE Queries Performance Recommendations
  • Oracle BI Applications High Availability

A word to the wise:
It is intended for Oracle BI Administrators, DBAs and Applications implementers.
Customers are encouraged to engage  Oracle Expert Services to review their configurations prior to implementing the recommendations to their BI Application environments.

You have been warned ;)

So - although it is available for anyone to read, we strongly advise that you only tweak your live system with this guide if you really, really know what you are doing - There is no magic button labelled "Click here for faster system" but a lot of things make sense and can assist in speeding up your OBIA system.

Thursday Apr 18, 2013

Automation Error in FDM – what can you do?

(in via Mel)

Have you ever seen an Automation Error in FDM not knowing why this happened?
Do you need to log a Service Request to get this resolved?

No, there should be no need to log a Service Request.

With the help of  KM Doc ID 1441863.1 -TROUBLESHOOTING Financial Data Quality Management Error "Automation Error" you will be able to see the main identified causes for this error and with the provided solution you may be able to fix this by yourself.

Should this not help, why not post in the Hyperion FDM Community? We are happy to assist with any issue in here and will make sure that new causes and solutions get added to KM Doc 1441863.1 as they come in.

Monday Apr 15, 2013

3,2,1.......Community Merge!

(in via Mel)

Our Hyperion Shared Services Community and the Hyperion Enterprise & Hyperion Enterprise Reporting Community are joining the Hyperion Other Products Community.

We are hoping that you knock on the door and say "Hello" to our newcomers to make them feel welcome in their new home.

With such a large family, it would help if you could add a abbreviation at the beginning of your subject when posting. 

  • "Ent": Error:"Cannot open HPAPP.DAT"
  • "HSS": Cannot log into Shared Services
  • "CB" (Crystal Ball): How to activate a license
  • "DRM": How to create ......

Is your question related to Certification? Then the  Hyperion Certification for EPM Community is your best friend.

As with all of our Communities your contributions are important to the success of these Communities.



This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.



« April 2014