Thursday Jun 26, 2014

Ask Maurice

This opportunity is no longer available. We want to thank Maurice for all his wonderful work over the past 15 years in SQRiBE, Brio, Hyperion, and Oracle.

Post update: 10th September 2014

Maurice, our Hyperion instrumentation and diagnostic expert in Proactive Support will be retiring in September.

Some of you may have met him during several OUG events in EMEA and the UK. He's been an integral and enthusiastic part of the Proactive team for 3 years and we'll miss him heaps.

But the reason for this post is to give you guys the opportunity to Ask Maurice any questions you have on Hyperion Diagnostics. You have a 2 month opportunity to ask anything you want, after which he'll be off traveling around the world enjoying life.

To ask Maurice a question go to:

Friday Jun 20, 2014

Oracle BI Mobile App Designer v2 is Now Available

( in via Paul R. )

The News:
Oracle BI Mobile App Designer (BIMAD) v2 is a major release that incorporates significant new capabilities, including:

  • New map visualization
  • Better navigation and contextual awareness
  • App level filters and calculated field support
  • Completely re-designed calculated field editor UI
  • An improved property pane, plug-in SDK, and playground
  • New app theme that matches the modern iOS 8 look and feel

What’s New

  • Exploration Template
    Including, drag & drop for drop down list and range filter, breadcrumbs for currently selected values, filter with dropdown and range slider, single and multi-value select support.
  • Sidebar
    New way to quickly drill down to show detail data of your interest. Including drag & drop for creating vertical table, 'Group By' support, standard filter, sorting and calculated field support.
  • New Map Visualization
    It is designed from the ground up for business users to easily visualize their data with Map and to interact on mobile devices to zoom, filter, and drill down.
  • New Custom Map
    On top of the pre-seeded map types for US states, US counties, etc, it allows customers to add their own regions and maps by simply uploading their own geoJSON files for polygon boundaries. Flexible custom keyword matching is also included as well as support for native interaction and filtering.
  • Completely Redesigned Authoring UI
    Redesigned, modern and easy to use property pane, simplified toolbar, consistency across various components and support for multiple component selection to set and update configuration all at once.
  • New Set of Functions with Redesigned Calculated Field
    Calculated Field Editor (previously,'Formula Editor') has been re-designed from the ground up to make the creation of custom calculated fields a lot more intuitive and simple yet flexible with a set of newly introduced functions.
  • Application Level Calculated Fields and Filters
    Filters and Calculated Fields can now be created and managed centrally at App level. Users can drag and drop to assign Calculated Fields to any component and assign Filers from the newly re-designed Property.
  • Plugin SDK and Gallery
    Download SDK with sample data, enjoy offline development, a plugin 'playground' with dynamic refresh, remote publish and a standard set of APIs to leverage BIMAD interactive filtering. A new plugin gallery is also included to make existing plugins easy to browse, find and download/upload.
  • And much more, including
    o    Type search in BI Mobile Apps Library
    o    Upload with drag and drop to refresh Excel data files and upload / replace images
    o    Share via QR code, link to copy and embed within web pages, blog posts and applications

Where can I find more information?

(layout and post: Torben, authorized: Lia)

Wednesday Jun 18, 2014

Recording of Advisor Webcast: Monitoring the Planning JVM in EPM system

After the large attendance for the Advisor Webcast

"Monitoring the Planning JVM in EPM System"

we've been asked many times for the location of the recording.

You can find recordings of all the previous webcasts via the central KM Doc:

 Advisor Webcasts: Current Schedule and Archived Recordings ( Doc ID 740966.1 )

All EPM and BI recordings are under the umbrella of Business Analytics

Alternatively navigate directly to the Business Analytics (Hyperion/EPM) KM Doc :

Oracle Business Analytics Advisor Webcast Schedule and Archive Recordings
( Doc ID 1456233.1 )
(Select the "Archived2014" Tab on this one)

As usual we do have an active Thread in the MOS Community for this Advisor Webcast:

(layout: Torben, post and authorized: Lia)

Tuesday Jun 17, 2014

RDA 8.04 has been Released

The RDA developers have done it again! They have released a new version of the product (8.04) on schedule (Tuesday 10 June 2014).

The new bundled (RDA, DA, OCM) downloads are available in the KM article:
 "Remote Diagnostic Agent (RDA) - Getting Started" (Doc ID 314422.1)".
To learn more about Diagnostic Assistant, you may refer to
"Diagnostic Assistant: General Information" (Doc ID 201804.1)

If the RDA install on your system came with the default files (and you have not manually installed RDA), you can run an opatch updater instead:
"Resolve Problems Faster! Use Remote Diagnostic Agent ( RDA ) - Fusion Middleware and WebLogic Server" (Doc ID 1498376.1)
in the
"Quick Guide" tab [ OPatch bundle 18904462].

The  Bill of Materials for this version indicates that there were no new Hyperion modules released with version 8.04, but existing modules were improved. All RDA Hyperion profiles (which begin with the string, "Hyperion1112_" with the exception of Crystal Ball) now detect and suggest a default value for MIDDLEWARE_HOME. Additional improvements have been made to the Hyperion1112_HIR, Hyperion1112_HFM, and Hyperion1112_HSS profiles.

Several Diagnostic Assistant improvements (i.e., to collect and process certain parameters, and especially to simplify JDBC URL selection) missed the release deadline, so it would be best to run the following profiles from the RDA command line instead of via DA: 

  • Hyperion1112_EPMA
  • Hyperion1112_ESS
  • Hyperion1112_FCM
  • Hyperion1112_HFM and
  • Hyperion1112_HIR

Sample command lines could be:

when using perl:
perl -vnSCRPp Hyperion1112_EPMA

On Unix/Linux Systems: -vnSCRPp Hyperion1112_ESS

On Windows:
rda.cmd -vnSCRPp Hyperion1112_FCM

-v = verbose (show output on screen)
-n = new collection (forget about the last one)
-S = Setup
-C = Collect (actually run this whole thing)
-R = Report (format the output in HTML)
-P = Package (zip the collection)
-p = run a Profile (as opposed to a module like OS, or DB)

To revert to a 'clean slate' before each run of Diagnostic Assistant use the -n option.

Alternatively, use the manual ways:

  1. Delete the DA_OUTPUT directory's config file, daenv.cmd|.sh, before each run.
  2. Set a different DA_OUTPUT path before each run, ie.
    set DA_OUTPUT=C:\tmp\da_output1
    da.cmd menu

(layout and post: Torben, authorized: Lia)

Friday Jun 13, 2014

OBIEE Sample App V406 is available via OTN

(in via Ian )

OBIEE SampleApp V406 virtual box appliance
is now available for public download from  OTN.

( VirtualBox Image (includes OEL6.5, Mobile App Designer v2 & Oracle Database 12c and more) )

OBIEE Sample Application V406 combines a

  • BI-platform
  • ad-hoc queries
  • Dashboards
  • Enterprise Reporting
  • Mobile Analytics
  • Scorecards
  • Multidimensional OLAP
  • and more

in a standalone virtual box image, creating a comprehensive OOB collection of examples and integrations designed to demonstrate Oracle BI capabilities, product integrations, and design best practices.

The OTN Public V406 image appliance is a collection of OBIEE examples demonstrating capabilities of OBIEE stack, as well as some design best practices.

V406 image is an enhanced version of the earlier Internal V403 version. V406 includes latest code patches, several bug fixes, new ODM content examples, new workshops and new datasets.

It does ">not include Cloudera installation.


  • Latest GA Software & Patches
    Oracle Db 12c PDB, OBIEE (two instances), EID 3.1, BI MAD V2, TT, Oracle Loader for Hadoop, Oracle SQL Connector for HDFS
  • Mapviewer html5 JS integration, Integrated ADF visualizations
  • New BIMAD V2 examples and BIMAD plugins
  • Enhanced OAA integration : ODM Workflows, new ORE scripts
  • EPM and BIApps Companion plug-ins to V406, EID Demos, Domain Demos, Workshops, MVDemo
  • Custom Interactions & Configurations Examples

Find the release documentation (zipped) here.


Download all zip files into a single directory (approx 28.5 GB).
Optionally verify integrity of zip files using checksums.
Open a zip file manager such as 7zip and select the first zip file (001) and extract.
This will extract a compressed VMDK file, and .ovf file into Sampleappv406appliance folder.
Open VBox Manager, select Import, navigate to the directory, select the .ovf file and click import.
After import the initial image size is about 67 GB.

The SampleApp contents and its code are distributed free for demonstrative purposes only.
It is neither maintained nor supported by Oracle as a licensed product

The last previous release was also blogged here:

We recommend to use the videos on the Youtube Channel "Oracle BI Techdemo" to get started with the OBIEE Sample Apps.

Update: 23 September 2014: Sample App FAQ:

    (layout and post: Torben, authorized: Lia)

    Use Enterprise Manager Cloud Control to monitor OBIEE Dashboards

    (in via Senthil

    If your OBIEE is set up in the following way:

    1. The OBIEE repository is an Oracle Database and is set up as a data warehouse
    2. Usage tracking is enabled in OBIEE.
      ( For information on how to enable usage tracking in OBIEE, refer to the following link: Setting Up Usage Tracking in Oracle BI 11g )
    3. The OBIEE instance is discovered in EM Cloud Control.
      ( For information on how to discover an OBIEE instance in Cloud Control, refer to the following link: Discovering Oracle Business Intelligence Instance and Oracle Essbase Targets )
    4. The OBIEE repository is discovered in EM Cloud Control.
      ( For information on how to discover an Oracle database, refer to the following link: Discovering, Promoting, and Adding Database Targets )

    then we've got news for you:

    KM Article:  OBIEE 11g: How To Diagnose Slowly Performing Dashboards using Enterprise Manager Cloud Control (Doc ID 1668236.1)

    takes you step by step through monitoring the SQL query performance behind your OBIEE dashboard.

    This Diagnostic approach ...

    • .. will help you piece together information on BI dashboard performance, e.g. processing time from the different layers of the BI system including the repository.
    • .. should enable you to get to the bottom of slow dashboards by using the wealth of information available in EM Cloud Control on OBIEE and Oracle DB.
    • .. will NOT fix any performance issues on its own, but will help identify bottlenecks while processing dashboard requests.

    (layout and post: Torben, authorized: Lia)

    Video on Hyperion Tax Provision

    ( in via Jan)

    EPM Information Development has asked us to remind you about the new video available for Hyperion Tax Provision.

    You can view it on the OracleEPMWebcasts YouTube channel


    An information rich 4:40 minutes of your time. 
    So please take a look.

    The video gives a brief overview of the main features of  Hyperion Tax Provision. You will learn ...

    • That Tax Provision and reporting System builds on the Hyperion Financial Close Reporting Platform
    • That much of the Tax Provision flow process is similar to the Financial Close Process and that the modules have been aligned to work together very closely.
    • That HTP enables you to integrate Book- and Tax Reporting on a common platform.
    • That It uses the technology of HFM, ties in with SmartView and can be used with Hyperion Financial Reporting.
    • That the native integration between the Financial System and the Tax System creates transparency for the Tax Departments and removes bottlenecks in the tax process.

    More technical information can be found here:

    Oracle Hyperion Tax Provision Data Sheet

    Oracle Hyperion Tax Provision White Paper

    Oracle Hyperion Tax Provision Documentation

    If you have another 45 minutes to spare and want to get into greater detail, then you can check out the recording of an Advisor Webcast that we did earlier last year:

    You can find this via
    KM Doc Oracle Business Analytics Advisor Webcast Schedule and Archive Recordings (Doc ID 1456233.1)

    -> Select the Tab "Archived 2013" and it is the third from the top:
    "Oracle Hyperion Tax Provision - Features and Overview with Demo"

    If you have questions towards that Advisor Webcast, you may participate in the

    Community Discussion

    about it.

    (layout and post: Torben, authorized: Lia)

    Tuesday Jun 10, 2014

    EPM Patch Set Updates - May 2014

    The following is Enterprise Performance Management (EPM) Patch Set Updates (PSU) released last month (May 2014).

     The "Patch" ID links will access the patch directly for download from "My Oracle Support" (login required).

    Oracle Hyperion

    Hyperion Essbase Studio Server
    - Patch 18505506
    Hyperion Essbase Studio Console MSI
    - Patch 18505503
    Oracle Hyperion Profitability and Cost Management
    - Patch 18685108
    Hyperion Strategic Finance
    - Patch 18400594
    Hyperion Essbase Admin Services Server
    - Patch 18505475
    Hyperion Essbase Admin Services Console MSI
    - Patch 18505468
    Hyperion Essbase RTC
    - Patch 18505499
    Hyperion Essbase Server
    - Patch 18505489
    Hyperion Essbase Client
    - Patch 18505494
    Hyperion Essbase Client MSI
    - Patch 18505483
    Hyperion Analytic Provider Services
    - Patch 18505515

    Oracle Hyperion

    Hyperion Financial Management
    Patch 18490422

    NOTE: Some patches listed may have been released a few days outside of the stated month.

    To view the patches released over previous months visit the earlier Blog posts:

    April 2014 EPM PSU Released
    March 2014 EPM PSU Released
    February 2014 EPM PSU Released
    January 2014 EPM PSU Released

    Friday Jun 06, 2014

    High Availability documents for OBIA

    There are 2 white papers that have been created by Product Management and Advanced Resolution team (thanks Rajesh, Archana).

    These documents describe how to deploy a high‐availability environment for the Weblogic components of BI Applications and including the Oracle Data Integrator.


     Configuring High Availability for Oracle Business Intelligence Applications Version (Doc ID 1679319.1


    Configuring High Availability for Oracle Business Intelligence Applications Version (Doc ID 1587873.1

    When implementing OBIA please take some time to review one or both of the papers.

    Do you still have a quick question that you want an expert to have a look at:
    check in the OBIA Community:

    Thursday Jun 05, 2014

    OBIEE bugs fixed list

    For anyone interested the bugs fixed list for OBIEE is now available

    OBIEE 11g: Bugs Fixed in (Doc ID 1678846.1)


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


    « June 2014 »