Tuesday Apr 30, 2013

BI Apps 7.9.6.4 with OBIEE 11.1.1.7 - Installation Issue

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

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

You will therefore need to install BI EE 11.1.1.6.0 and then patch to 11.1.1.6.4 or higher. Then run the BI Apps installer. Once BI Applications has been installed, you can then upgrade BI EE to 11.1.1.7.0, 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 11.1.2.3 - Documentation is online

(in via Mel)

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

You can find it under:

http://www.oracle.com/technetwork/middleware/performance-management/documentation/index.html

EPM 11.1.2.3 - Essbase - Runtime Substitution Variables

With 11.1.2.3 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
e.g.:

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

SET RUNTIMESUBVARS {
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 11.1.2.3.00 is available on eDelivery

(in via Greg)

Word just came in that

EPM 11.1.2.3.0

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

11.1.1.7 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 11.1.1.7 bugs fixed list.

OBIEE 11g: Bugs Fixed in 11.1.1.7.0 [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. 
e.g.:

  • "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.

Cheers
Mel

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,
...\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin\essbase.cfg:

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
===============================================================
SELECT
{[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 11.1.2.3.x

(in via Lia)

Starting with release 11.1.2.3,

Oracle Financial Data Quality Management (FDM)
and
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 11.1.2.3,
  • migrate to FDMEE 11.1.2.3,
  • or run both in parallel.

New customers may license FDMEE 11.1.2.3 only.

Please note that starting with EPM 11.1.2.4, existing FDM customers will be required to migrate to FDMEE if they chose to upgrade other EPM products to release 11.1.2.4. (Release 11.1.2.3 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 11.1.2.3 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 11.1.1.7.0 ia available on eDelivery

(in via Lia)

In case you missed the news - OBIEE 11.1.1.7 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 11.1.1.7, 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 11.1.2.2 Add-in replaces the Oracle BI Office Add-in as the primary Office application for Oracle BI Foundation. Both are still available with OBI 11.1.1.7.  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 11.1.1.7 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 11.1.1.7 is not certified for Oracle Exalytics In-Memory Machine.

    OBI 11.1.1.7 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
at


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)

About


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

Authors:

italia.nowodworska@oracle.com
paul.anderson@oracle.com





Search

Archives
« April 2013 »
SunMonTueWedThuFriSat
 
1
3
6
7
9
11
12
13
14
16
17
19
20
21
23
24
27
28
    
       
Today