Tuesday Apr 30, 2013

BI Apps with OBIEE - Installation Issue

If you are trying to install BI Apps on OBIEE, you will encounter an issue.

 Please be advised that BI Apps 7964 (which was released on OBIEE BP1) requires BI EE

You will therefore need to install BI EE and then patch to or higher. Then run the BI Apps installer. Once BI Applications has been installed, you can then upgrade BI EE to, if required.

Please note that “Certified” doesn’t automatically mean you can Install apps into the .7 environment. You must first install into what was originally certified and then upgrade the techstack.

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.

Friday Apr 26, 2013

Locating Certification Information for OBIEE

We've just uploaded a new 4 minute video showing how to quickly find OBIEE certification information in MOS.

There's been  a lot of progress in the way certification information can be found, if you have the time please take a look.

(edit - the video had to be removed from YouTube due to legal reasons - you can now find it in  KM Doc EPM Support Matrix - Product Compatibility Information [ID 1507504.1]  )

And then there were 2 less – Community merge complete.

(via Mel)

As you read earlier on our blog  (from Apr 15, 2013) the Hyperion Shared Services Community and the Hyperion Enterprise & Hyperion Enterprise Reporting Community were merging with the Hyperion Other Products Community.

 We are pleased to announce that the house move was successful and all boxes with information have been unpacked.

We are hoping that you help them settle in quickly with posting to their new Community.

Thursday Apr 25, 2013 List of Bugs Fixed

Apologies for the delay in publishing however for those of you who are interested, at last we can release the OBIEE bugs fixed list.

OBIEE 11g: Bugs Fixed in [ID 1546028.1]

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.


Wednesday Apr 10, 2013

How to track MDX queries against Essbase

(in via Nancy)

Nancy pointed me at a newly created KM Doc that talks about MDX tracking unsurprisingly called:  Tracking MDX Queries Against an Essbase Database [ID 1543793.1].

This CFG setting is not yet fully documented, but may make it into the next documentation update.

MDX queries run against an Essbase application can be tracked by adding a line in the Essbase configuration file,

TRACE_MDX appname dbname 2

The appname and dbname refer to the specific application and database that you want to track.
Both are optional. Omit them if you want all applications tracked.

The MDX queries are dumped to a file named mdxtrace.log in ARBORPATH/appname/dbname folder,
i.e. /Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/app/Sample/Basic

The log contains:

  • The time stamp at the time of completion of the query.
  • The elapsed time for the query
  • it does NOT contain the user who issued this statement - for that you would need to cross check in the Application log file

So for example, executing an MDX query against the Sample/Basic database, the mdxtrace.log contains:

Following MDX query executed at Mon Apr 08 08:56:13 2013
{[100-10], [100-20]} ON COLUMNS,
{[Qtr1], [Qtr2], [Qtr3], [Qtr4]} ON ROWS
FROM Sample.Basic

=== MDX Query Elapsed Time : [0.009] seconds ===================

Please Note:

Only queries that were executed successfully are printed to file. Queries that end in error are not printed.

We hope that this can assist you in tuning your Database/MDX queries.

Monday Apr 08, 2013

FDM & ERPI to be combined into FDMEE starting with

(in via Lia)

Starting with release,

Oracle Financial Data Quality Management (FDM)
Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications (ERPI)

are being combined into a single product named

Oracle Financial Data Quality Management, Enterprise Edition (FDMEE)

built on the Oracle Fusion Middleware platform.
Pricing and related adapters remain unchanged, and there is no fee for existing FDM customers to migrate to FDMEE.

Existing customers may:

  • upgrade to FDM version,
  • migrate to FDMEE,
  • or run both in parallel.

New customers may license FDMEE only.

Please note that starting with EPM, existing FDM customers will be required to migrate to FDMEE if they chose to upgrade other EPM products to release (Release is the last release of FDM as it is currently offered.)

Please note that enhancements will not be provided for the current FDM and ERPI products after the release.
Customers who wish to take advantage of enhanced features and functionality should plan to migrate to FDMEE.

Support for these products follows the published  Oracle Lifetime Support Policy Guidelines.

Any questions related to this announcement should be directed to your Oracle account manager.

This information was also announced in the Oracle Knowledgebase
under  KM Doc ID 1542470.1

Friday Apr 05, 2013

OBIEE ia available on eDelivery

(in via Lia)

In case you missed the news - OBIEE has been released and is ready for download from the  Oracle Software Delivery Cloud.
You need to select "Oracle Business Intelligence" and your Operating System to find this release.

What’s New

The new release of Oracle Business Intelligence 11g, Release, features more than two hundred enhancements, designed to add new functionality, improve performance, and deliver an enhanced end-user experience. Some of the major new features and enhancements are:

  • New visualizations and user-interactions, including Performance Tile, Waterfall, and 100 percent stacked bar graphs. Breadcrumbs provide contextual awareness and navigation. Users can now anchor the header for tables or pivot views using the “Freeze Header” feature, which is also available on the BI Mobile app via the scroll gesture.
  • New Visualization Suggestion Engine helps business users select the chart type best suited for the display of current data and the analysis task they wish to perform— “Comparing Values”, “Analyzing Trends”, “Comparing Percentages”, etc.  An algorithmic engine evaluates data types and the cardinality of the result set to recommend the most optimal visualization.
  • New Oracle Hyperion Smart View for Office Integration. The Smart View Add-in replaces the Oracle BI Office Add-in as the primary Office application for Oracle BI Foundation. Both are still available with OBI  Users now can access the Oracle BI Foundation Catalog in Smart View, add dashboards and analyses, create new analyses from scratch, in Excel, and save them as either Excel worksheets or back in the Oracle BI Foundation Catalog.
  • BI Mobile Enhancements. All new visualizations are touch enabled and support gestural interactions. Double-tap on a view renders it in full-screen mode. Enhancements to email settings now allow users to email attachments in the PDF format also.
  • Tighter OBI-BI Publisher Integration. Translate OBI Dashboards to BI Publisher layouts automatically. Use multiple templates to  allow pixel-perfect printing of dashboards.  BI Publisher can now directly access subject areas in the Oracle BI Foundation Catalog, removing the need to create separate BIP data models.
  • BI Publisher Enhancements. Report Wizard enhancements, Layout Editor Extensions for Interactive Viewer, improved Data Model Editor usability, and private JDBC connections are now supported. XML and CSV formats can now be configured as “local sources”.  Integration with enterprise applications has been enhanced with the ability to convert an E-Business Suite catalog to BI Publisher. E-Business Suite Flex Fields are now supported as BI Publisher Report parameters.
  • Advanced and Predictive Analytics. OBI Dashboards and prompts can run Oracle R for Enterprise (ORE) scripts that perform complicated statistical analyses, and Oracle Data Mining algorithms and cluster analysis, and visualize the data set as interactive images embedded in Dashboards.
  • Big Data integration to Apache Hadoop as a data source. The BI Server is now able to generate Hive query language commands to query federated Hadoop data sources.

no Exalytics support yet

  • Oracle BI is not certified for Oracle Exalytics In-Memory Machine.

    OBI certification for Exalytics is planned for a later release.

The Documentation of this release can be found here.

Thursday Apr 04, 2013

EPM / OBIEE on Exalytics patching Advisor Webcast

One of the frequently requested topics for Advisor Webcast sessions is "patching and maintenance of EPM".

As one of the EPM hosts, I am therefore particularly happy to announce a session that covers patching on Exalytics based on examples of OBIEE, Essbase and Times Ten.

ADVISOR WEBCAST: Exalytics Patching
April 23, 2013

17:00, Europe Time (Berlin, GMT+01:00)

16:00, GMT Time (London, GMT)

11:00, Eastern Daylight Time (New York, GMT-04:00)

09:00, Mountain Daylight Time (Denver, GMT-06:00)

Saresh has signed up to guide you to this Advisor Webcast.

As this was classified as a Webcast for "Oracle Engineered Systems" it does NOT show up in the usual "Oracle Business Analytics" Section of the  "Advisor Webcasts: Current Schedule and Archived recordings" KM Doc 740966.1.
Instead you find this under - you have guessed it "Oracle Engineered Systems".

You can directly jump to KM Doc 1533869.1 for more information, or even register from here without the use of KM via this link:  https://oracleaw.webex.com/oracleaw/onstage/g.php?d=595289751&t=a

So - do not miss out on this valuable session for a direct contact with our Engineers. There will be a Question & Answer Session at the end for all the unanswered things that are hard to find in the documentation.
But even if you do miss it: As with every Advisor Webcasts - the session will be recorded and you can find the content on the same KM Doc 740966.1 as the registration. We also usually create accompanying threads in the Oracle Communities that are then monitored by the presenter for later questions. So even if you can not attend the live session, your questions may be answered if you just view the recording.

Tuesday Apr 02, 2013

Top Gun Presentations are online

You may have heard of the legendary Top Gun meetings of the Hyperion sphere...  A lot of people who already worked with the EPM products when they were still "Hyperion" (and some other interested Top Gunners) gathered together in one conference? No?

Well - never mind - now that you know, you might be interested in what magical potions are exchanged and what secret knowledge is shared between those druids.  

The Infratects Clan hosted the gathering at their stone circle in Barcelona, and we have just had words from our spy-fly that the magic spellbooks can be found online at  infratects. You will find them when navigating to their site, turn the "news & events" magic knob and look for a link to the "Top Gun 2013 Presentation Downloads" under "latest news".

Especially the "Installation" and "Troubleshooting" docs should come in handy when brewing your own magic EPM potion.
For the later you can also take a look through your crystal ball (not to be confused with the actual product) as we just had a few recorded webcasts that contain similar content.

You can find THAT via the  "Advisor Webcast Schedule and Archive" KM Doc (then -> Oracle Business Analytics -> Archive 2013)

Oh - and of course - keep that infratects site bookmarked - to sign up in time for next years Top Gun Meeting.

(a few edits were done as of input from the wise Clans(wo)men - thanks for the corrections)


This blog talks about the latest news and upcoming events regarding Oracle EPM and BI.
Tanya Heise


« April 2013 »