Friday Nov 08, 2013

November EPM Patch Set Updates released

(in via Greg)

Greg has provided us an updated listing of current patches for the EPM system.  These follow on from our previous Blog post last month in October [link].

17320505 - Oracle Hyperion Reporting and Analysis for Foundation - PSU 11.1.2.1.136
17413112 - Oracle Hyperion Planning, Fusion Edition - PSU 11.1.2.2.305
16345450
- Oracle Hyperion Reporting and Analysis for Financial Reporting - PSU 11.1.2.1.134
17609530 - Hyperion Essbase RTC - PSU 11.1.2.3.003
17609535 - Hyperion Essbase Server - PSU 11.1.2.3.003
17609533 - Hyperion Essbase Client - PSU 11.1.2.3.003
17609539 - Hyperion Essbase Client MSI - PSU 11.1.2.3.003
17609518
- Hyperion Essbase Administration Services Server - PSU 11.1.2.3.003
17609497 - Hyperion Essbase Administration Services Console MSI - PSU 11.1.2.3.003
17609493
- Hyperion Analytic Provider Services - PSU 11.1.2.3.003
16692973 - Oracle Hyperion Enterprise Performance Management - PSU 11.1.2.2.301
16984944 - Oracle Hyperion Financial Close Management - PSU 11.1.2.2.352
16989110 - Oracle Hyperion Financial Close Management - PSU 11.1.2.3.100
17636270 - Hyperion Strategic Finance - PSU 11.1.2.1.103


Be sure to review the related Readme files available per Patch Set Update.  These describe the defects fixed and/or updates included along with requirements and instructions for applying the patch. To access simply click on the "Read Me" button when accessing the PSU via My Oracle Support | Patches & Updates.


At any time to see listing of the latest Enterprise Performance Management (EPM) Patch Sets and Patch Set Updates for the current releases visit:

Doc ID 1400559.1 - Available Patch Sets and Patch Set Updates for Oracle Hyperion EPM Products
Doc ID 1525518.1 - Available Patch Sets and Patch Set Updates for Oracle Crystal Ball, DRM, FCM, HPCM and HSF

For OBIEE keep up to-date with the latest Patches and Patch Set Updates by visiting:

Doc ID 1488475.1 - OBIEE 11g: Required and Recommended Patches and Patch Sets



Tuesday Nov 05, 2013

Business Analytics Monthly Index - October 2013

Starting from this post we are providing a monthly summary. This provides a quick look at what has been happening in our Proactive Support Blog over the last month.

Welcome to the first Monthly Index posting!

Within each section the items are shown in chronological order.

Please let us know what you think and your suggestions are most welcome ...

Oracle Business Analytics - Blog
Monthly Index - October 2013
General Summary Link
Introducing the Business Analytics Proactive Support Team
- Outlining the Proactive Support Team function
Business Intelligence (BI) Summary Link
OBIEE version 11.1.1.7.131017 has been released
- Links to the latest OBIEE release information & downloads
Update to OBIEE Chrome 30 issue
- Information for patch release for OBIEE Chrome issue
OBIEE problems with Chrome (update 30)
- Highlight OBIEE 11.1.1.7.1 issue with latest Google Chrome update 30
OBIEE 11.1.1.7.1 Sample App (V309 R2) released
- Link and Information about the current OBIEE Sample App
OBIEE - APEX integration
- An article discussing the OBIEE APEX Integration
Enterprise Performance Management (EPM) Summary Link
Hyperion Smartview Assistance
- Information & resources for Hyperion Smartview inc. OBIEE integration
Java update alert: issue with EAS 11.1.2.3
- Advisory of recent Java release and identified EAS problem + workaround
EPM troubleshooting Utilities
-
Outlining additional resources for troubleshooting EPM
EPM Infrastructure Tuning Guide released
-
Link to the EPM Infrastructure Tuning Guide (v.11.1.2.2 / 11.1.2.3)
Essbase - FormatString
- Discussing Essbase "Typed Measures"
October EPM patch set updates released
- Links to the October Patches for EPM
featuring - the DRM blog
- Featuring one of our co-blogs that is very beneficial
Advisor Webcast Summary Link
Advisor Webcast: EPM 11.1.2.3 new features in Financial Applications
- AW: Discussing the new Features in Financial Applications (FA).
  (recording post presentation via Doc ID 1456233.1 | Archived 2013)
Advisor Webcast: Troubleshooting Discoverer editions
- AW: Discussing Discover Logs/Tracing/EUL Status Workbooks & more.
  (recording post presentation via Doc ID 1456233.1 | Archived 2013)
For more information on future webcasts and archived recordings
visit Doc ID 1456233.1.

Thursday Oct 24, 2013

Java update alert: issue with EAS 11.1.2.3

(in via Nancy)

Customers using EPM 11.1.2.3 and a web browser to launch the Essbase Administration Services Console will lose the ability to launch EAS Console via the Web URL if they apply Java 1.7 build 45.

Development is currently investigating this issue.

Workaround:

If Java 1.7 Update 45 has been installed, it will need to be uninstalled and a previous version will need to be installed.

Older versions of Java are available in the Java Archive

Note:

Though it may work, Java 1.7 is not supported in previous versions of EAS.
(Exception for PSU 11.1.2.2.104 which introduced JRE 1.7 support in the 11.1.2.2 code line)

Customers running a version of EAS Console prior to 11.1.2.3 need to install the supported version of JRE.

Please follow this also in the Oracle Community

Update, 28 Feb 2014:
This issue is fixed in patch set update 11.1.2.3.003:
Available as:
patch 17609518 for the server and
patch 17609497 for the client component

Monday Oct 21, 2013

EPM troubleshooting Utilities

(in via Maurice)

"
Are you keeping up-to-date with the latest troubleshooting utilities introduced from EPM 11.1.2.2? These are typically not described in product documentation, so you might miss references to them. The following five utilities may be run from the command line.

(1) Deployment Report was introduced with EPM 11.1.2.2 (11 April 2012).
It details logical web addresses, web servers, application ports, database connections, user directories, database repositories configured for the EPM system, data directories used by EPM system products, instance directories, FMW homes, deployment distory, et cetera.
It also helps to keep you honest about whether you made changes to the system and at what times! Download Shared Services patch 13530721 to get the backported functionality in EPM 11.1.2.1.

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/epmsys_registry.sh report deployment
(on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat report deployment (on Microsoft Windows).
The output is saved under
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\deployment_report.html


(2) Log Analysis has received more "press".
It was released with EPM 11.1.2.3 and helps the user to slice and dice EPM logs. It has many parameters which are documented when run without parameters, when run with the -h parameter, or in the 'Readme' file. It has also been released as a standalone utility for EPM 11.1.2.3 and earlier versions. (Sign in to  My Oracle Support, click the 'Patches & Updates' tab, enter the patch number 17425397, and click the Search button.
Download the appropriate platform-specific zip file, unzip, and read the 'Readme' file.
Note that you must provide a proper value to a JAVA_HOME environment variable [pointer to the mother directory of the Java /bin subdirectory] in the loganalysis.bat | .sh file and use the -d parameter when running standalone.)

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/loganalysis.sh -h (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\loganalysis.bat -h (on Microsoft Windows).
The output is saved under the
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\
subdirectory.


(3) The Registry Cleanup command may be used (without fear!) to clean up various corruptions which can  affect the Hyperion (database-based) Repository.

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/registry-cleanup.sh (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\registry-cleanup.bat (on Microsoft Windows).
The actions are described on the command line.


(4) The Remove Instance Command is only used if there are two or more instances configured on one computer and one of those should be deleted.

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/remove-instance.sh (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\remove-instance.bat (on Microsoft Windows).


(5) The Reset Configuration Tool was introduced with EPM 11.1.2.2.
It nullifies Shared Services Hyperion Registry settings so that a service may be reconfigured. You may locate the values to substitute for <product> or <task> by scanning registry.html (generated by running epmsys_registry.bat | .sh).
Find productNAME in INSTANCE_TASKS_CONFIGURATION and SYSTEM_TASKS_CONFIGURATION nodes and identify tasks by property pairs that have values of 'Configurated' or 'Pending'.

Run it from
/Oracle/Middleware/user_projects/epmsystem1/bin/resetConfigTask.sh -product <product> -task <task> (on Unix/Linux)
\Oracle\Middleware\user_projects\epmsystem1\bin\resetConfigTask.bat -product <product> -task <task> (on Microsoft Windows).

"
Thanks to Maurice for this collection of utilities.


Friday Oct 18, 2013

EPM Infrastructure Tuning Guide released

(in via Mel)

The EPM Infrastructure Tuning Guide (v.11.1.2.2 / 11.1.2.3) has been released:

https://blogs.oracle.com/pa/entry/epm_infrastructure_tuning_guide_v11

Thursday Oct 17, 2013

Essbase - FormatString

A look at the documentation for "Typed Measures" shows:
"Using format strings, you can format the values (cell contents) of Essbase database members in numeric type measures so that they appear, for query purposes, as text, dates, or other types of predefined values. The resultant display value is the cell’s formatted value (FORMATTED_VALUE property in MDX). The underlying real value is numeric, and this value is unaffected by the associated formatted value."

To actually switch ON the use of typed measures in general, you need to navigate to the outline properties:
  1. open outline
  2. select properties
  3. change "Typed Measures enable" to TRUE


(click to enlarge)

As an example, I created two additional members in the ASOSamp outline.
- A member "delta Price" in the Measures (Accounts) Dimension with the Formula: ([Original Price],[Curr_year])-([Original Price],[Prev_year])
This is equivalent to the Variance Formula used in the "Years" Dimension.

- A member "Var_Quickview" in the "Years" Dimension with the same formula as the "Variance" Member.
This will be used to simply display a second cell with the same underlying value as Variance - but formatted using Format String hence enabling BOTH in the same report.


(click to enlarge)


In the outline you now select the member you want the Format String associated with and change the "associated Format String" in the Member Properties.
As you can see in this example an IIF statement reading:
MdxFormat(IIF(CellValue()< 0,"Negative","Positive" ) )
has been chosen for both new members.

After applying the Format String changes and running a report via SmartView, the result is:

(click to enlarge)


reference:
Essbase Database Admin Guide ,Chapter 12 "Working with Typed Measures "

Tuesday Oct 15, 2013

Introducing the Business Analytics Proactive Support Team

Dear Reader,

So you're reading this blog and its all pretty cool but have you ever wondered who are these "Proactive" people behind the blog and what exactly do they do?
Well here's a visual to help you out. It pretty much sums up our tasks: 


(click to enlarge)

The Business Analytics Proactive team are a team of 11 engineers located worldwide focused on getting information out to you as quickly and efficiently as possible. We're close to the SR-handling arm of the org so we get to know the common hurdles and questions coming in.

Our job is to try to pre-empt these questions thereby improving your overall experience with our products.

We also get involved in knowledge management, product improvements, diagnostics and testing.

So say hello to :

  • Paul (AU, Brio/BI+)
  • Nancy (US, Essbase)
  • Debbie (UK, Essbase/OBIEE)
  • Greg (UK, HFM)
  • Tanya (US, OBIEE, HFM)
  • Mel (UK, HFM/Enterprise)
  • Martin (DE, OBIEE)
  • Ian (UK, OBIEE)
  • Julie (UK, WCP/OBIEE )
  • Maurice (UK, BI/automation) and
  • Torben (DE, Essbase)

You'll see them pop up on LinkedIn occasionally as well as in  MOS Communities and you may even bump into them during a SIG or user group. We'll let you know where they'll be loitering next in the  'Meet the team' section.

Wednesday Oct 09, 2013

October EPM patch set updates released

(in via Greg)

Greg has passed me the list of the October patch set updates for the EPM system.

The list reads:


I would be too much to cover all fixes of these patch sets here, and they are covered in the readme files of the patch sets anyway. Just remember to read the installation instructions first. As  Henri mentions on his blog, for some patches more than just one of these patch sets is necessary.

Among the fixed issues we see:

  • A fair number of drill issues with SmartView / Essbase
  • EAS login issues
  • APS enhanced ODL logging
  • 25 Bugs in Disclosure Management
  • 19 Issues in Hyperion Planning
  • and many more

As always we have also updated the list in the recommended patch KM notes under the overview KM Doc:

Available Patch Sets and Patch Set Updates for Oracle Hyperion Enterprise Performance Management Products (Doc ID 1400559.1)

For OBIEE as a closed system an overview KM note is:

KM Doc 1488475.1 - OBIEE 11g: Required and Recommended Patches and Patch Sets

Although patching and upgrading are two completely separate tasks, that may require attention to detail, and follow different workflows, some of the procedures around patching and upgrading are identical.

I would therefore like to point you to our KM Note: Upgrade Advisor: Enterprise Performance Management (EPM) System Upgrade from 11.1.1.3 to 11.1.2.x (Doc ID 324.1) as a first reference and starting point to keep your system current.


Monday Oct 07, 2013

Advisor Webcast: EPM 11.1.2.3 new features in Financial Applications

(in via Tanya)

Are you on an older release of HFM and thinking about upgrading to the latest and greatest? What is holding you back from doing so? Is it fear of the unknown or not knowing how much effort is involved? Or maybe you’re concerned about how will it impact your other products?

If any of these questions/concerns sound all too familiar to you, put your mind at ease and join us for the

 Advisor Webcast:
EPM 11.1.2.3 - New Features in Financial Applications Products: HFM, FR, FCM, FDM

on October 10th.

Take advantage of the fact that the experts from product management will be presenting the key items on 11.1.2.3. They will walk you through all of the key features and main reasons that you should upgrade to the latest release…..and the best part is that you can ask them questions during the call.

In addition, keep in mind that although the main focus will be HFM, the team will also discuss the key enhancements with Financial Reporting, FDQM and SmartView.

This is your opportunity to learn about the new release and how it can benefit you and your company….so don’t hesitate in registering for the webcast!

UPDATE:

TOPICS WILL INCLUDE:

  • New technical and functional enhancements
  • Information related to upgrading
  • Provide real customer examples who already upgraded
  • Provide some additional general information about FR, FDM and Smart View
  • Interactive session led by product management experts

As always with Advisor Webcasts - you do not need a Support ID to register - you can register directly via this  webex link as well.

Monday Sep 30, 2013

Standalone Log Analysis Utility

I just had a comment from Development on one of our older posts.

Good news:

The Log file Analysis Tool that was introduced in EPM 11.1.2.3.000 ( read post here ) has now been made stand-alone.

Why would that be important?
Because:  "You can use this standalone log analysis utility to analyze logs from any 11.1.1.x or 11.1.2.x deployments.  It will run on EPM servers or non-EPM servers."
That's why!

It is available as a patch via MOS under the number  17425397

As of the readme, the prerequisites are fairly lightweight and not surprising:

Prerequisites
Any user can run this utility from any machine on which log files are stored.
- Users running the Log Analysis Utility must have execute privileges on the following files:
Windows: EPM_ORACLE_INSTANCE/bin/loganalysis.bat
LINUX/UNIX: EPM_ORACLE_INSTANCE/bin/loganalysis.sh

- The user who runs this utility must have read permissions on the directory where the log files are located.

The download is just over 2 MB and it includes the readme file. This will not only tells you how to install and use the utility, it also contains the list of available commands.

Sidenote:
The comment on the blog requesting a backport was posted early in September 2013 (our first mention in May).
The answer from Development came in on September 25th 2013. Less than a month to get this done!

Thanks to Fuad and Maurice for making this happen so quickly.


Monday Sep 23, 2013

Fusion and EPM lifetime extended

Monday, eh?

I'll make this post a quick and easy one:

Good news: one less thing to worry about.

We extended the lifetime support for
Fusion and EPM

So what exactly happened?
Oracle extended the three dates for the life cycle of Fusion and EPM to be


(please be aware that this only goes for some defined versions, usually the latest ones. Older releases may still carry the previous announced dates. Make sure to download and save a copy of the current lifetime policy for your reference)

So what do the terms "Premier", "Extended" and "Sustaining" Support mean? Let us have a look at the definition:


    (click to enlarge)

    For a more detailed overview of what is included in the lifetime support policy you should visit this site.


    Wednesday Sep 18, 2013

    EPM / OBIEE certification general

    (in via Ian)

    We just had a series of post that talked about certification, and I hope that you liked the breakdown and the pointers that I did there.

    Now, one of the issues that we face with certification and supported versions is that we live in a world of ever evolving and changing hard- and software. So while Oracle can test and clarify what versions work together, it might be the case that the same version soon is outdated or superseded by a later patch or product update. (We had a post about how to  read supported update versions earlier)

    As Oracle does not know the patchdates, -versions or-contents of all third party products, and as we can not test products that do not exist yet, there usually is a time gap between the release of a patch and Oracle stating that this patch is supported/certified. And for legal reasons Oracle can not and will not announce the support of future versions.

    As far as we CAN say anything towards third party patching, we have tried to get a few statements from Product Management.

    Ian got a clarification in a  community thread for BI where Gerald wrote:

    "We "test" the versions that are available at the time that we release, but we "support" much more than we certify and are documented.
    If we test a base version of a 3rd party datasource and the 3rd party vendor releases a Service Pack/Patch/Release Update that addresses a product defect (functionality/security/other), we would not know about the 3rd party patching timeframe but would support the update because we tested the base version as well as cover it under the 'Generic ODBC support' (that we document).
    We have tested the configuration, the configuration passed our test, we support higher releases, and service packs.
    The Support team will address SR's on those configurations and file bugs where the defect is shown to occur with Oracle BI.
    Although we support more than we document, we only document what we tested.
    "

    I also went out and spoke to Product Management if there was any input they could give us on the topic. Bill pointed me to the second Tab of the supported Platform matrices (EPM) that states:

    "Oracle's Backward Compatibility Policy:
    Oracle acknowledges and supports the backward compatibility assertions for platform software as provided by its vendor. Therefore when vendors assert backward compatibility, subsequent maintenance releases and service packs may be used. If an incompatibility is identified, Oracle will specify a patch release on which EPM System should be deployed (and remove the incompatible version from the supported matrix) or provide a maintenance release or service fix to the EPM System product software."

    This does not only applyto Operating Systems, but all third party products that are used in combination with EPM.

    I hope this sheds some light on Oracle policies and what can and can not be said about support of updates and patches. And of course I cannot finish this post without advertising our certification matrices again ; ) , in case you still have a question.



    Tuesday Sep 17, 2013

    EPM September patch set released

    (in via Greg)

    Greg just informed us of the release of the September patch set (11.1.2.2.104, 11.1.2.1.601, 11.1.2.2.401 and 11.1.2.3.001) for the EPM System. 

    The detailed list of released patches is:

    The list of defects fixed and the installation documentation can be found in the readme for the patches.

    You find the readme if you follow the links to the patch(es), click on your chosen patch and select "readme" in the pop up in MOS.

    The list is a little too long to be posted here, and I will not go into detail of it. But I would like to mention that this patch (11.1.2.2.104) is cumulative, and contains all fixes from the patches 11.1.2.2.101, 11.1.2.2.102, 11.1.2.2.103, so there is no need to install these once you have installed the latest one.

    The same goes for the patches to R&A (11.1.2.2.401 - cumulative) and BR (11.1.2.1.601 - cumulative).

    HSS (11.1.2.3.001 - LCM fix only) fixes only one issue and there was no previous patch to that code line.


    Wednesday Sep 11, 2013

    EPM / OBIEE certification with Java 7

    the final part 4 of our little series about compatibility will deal with :

    • Internet Explorer 10 compatibility
    • Windows 2008 support
    • Office 2013 compatibility
    • Java 7 support

    So here we go

    "Java 7 compatibility" 

    Before we begin talking about Java compatibility, we need to understand a few specifics about our products and Java, that are a little more complex than e.g. the OS the products run on.

    First of all, Java is more a technology than a product - there are multiple JDKs (Java Development Kits) and JREs (Java Runtime Environments) out from various vendors, and only specific parts of the EPM System and OBIEE make use of these in their server and client components.

    One way to get into the topic is to check the download site for "Java 7" as it shows up in e.g a google search:
    Here we get some of the common aliases that Java uses:
    "Java software for your computer, or the Java Runtime Environment, is also referred to as the Java Runtime, Runtime Environment, Runtime, JRE, Java Virtual Machine, Virtual Machine, Java VM, JVM, VM, Java plug-in, Java plugin, Java add-on or Java download."

    This makes answering the question "Is EPM (or OBIEE) compatible with Java 7" close to impossible.The question is simply not specific enough as an EPM Systems usually consist of a multitude of servers and clients, all running different parts of the System, and all of them in need of different aspects of Java.

    A more specific question would need to include the version, the component, the OS and e.g the Application Server.

    For example: "If our 11.1.2.3.0 Essbase Administration Services Server runs on Oracle Weblogic 10.3.5 (11g R1) on Windows 2008 R2 (64-bit), can we install Oracle JRE 1.7.0_21 on that machine without a problem?". And the answer as it comes from the support matrix is - yes, this is a supported version (stated is: JRE Plug-in 1.7.0_07+).


    (click to enlarge)

    The additional information section of this also gives us an idea of what modules/parts of the EPM System actually make use of the JRE version mentioned, and we can work backwards from there to find out which parts actually do NOT make use of it and simply ignore it.

    Another example: the Excel Add In and SmartView are not mentioned and therefore do not need or use the installed JRE on a client.

    Likewise will the EAS Server ignore the installed JRE on the server box, as it simply does not use it, while the JDK that is used by weblogic 10.3.5 can only be of version 1.6.0_35+ (as of certification tab). So - yes, you can install the JRE 1.7.0_21 and will not run into trouble - as the EAS Server component does not use it anyway.

    So much for the introduction. Java 7 seems not to be easy to tackle. But let us give it a shot:


    EPM and Java 7

    A search for "EPM Java 7" on KM gives us a good hit:

    KM Doc "Java 7 Compatibility With Hyperion EPM Products (Doc ID 1546957.1)"
    (last update August 13 2013)

    This states:

    "Currently Java 7 is not supported with any Hyperion EPM products, so it should not be upgraded to this release on EPM servers. Java version that is shipped by default with EPM System should be used."

    This seems to be rather clear, but does not say anything about the JRE on the clients (where potentially nothing gets installed by the system, if we access EAS Console via a Web Browser).

    So second stop - the certification tab - with the result:


    (click to enlarge)

    We see that no JRE is mentioned at all, but at least we now have an idea about the JDKs that we can choose from on the server side.

    Next stop is the  compatibility matrix. We get the information as above on the "EPM System Basic Platform" Tab of the sheet. And see that indeed JRE Plug-in 1.7.0_07+ may be used on the client.

    So - this is EPM pretty much covered. On to:


    OBIEE and Java 7

    A search on KM for "OBIEE Java 7" and for "OBIEE "Java 7"" does return a number of Documents but none of then appear helpful.

    So second stop - compatibility matrices:


    (click to enlarge)

    in which we see the Oracle JDK 1.7.0_0.7 listed along with e.g HP 7.0.3- an indicator that Java 7 is on the list for this one

    and


    (click to enlarge)

    again, we see a number of JDKs with a "7" in them (HP, IBM, Oracle) so based on this we can conclude that OBIEE is (at least partially) certified with Java 7.

    Having said that - we better check back to the compatibility matrices, to see if we can find more details:


    (click to enlarge)

    Surprisingly enough we find that the only supported JRE version for the client part of OBIEE (11.1.1.7.0) is 1.6.0_35+ !
    So from a client perspective Java 7 is a no-go, while the server part seems to be fine with it.


    General Certification Information

    I would like to close today's post with a definite - maybe !

    The question of Java 7 compatibility is simply not specific enough for a System like EPM or OBIEE. Some modules do support some brands and versions of Java 7 while others do not. I have tried to get you closer to an answer with this, but chances are, that your specific issue at hand may not correlate to what I outlined above.

    My ideal post would have included a clear Yes or No answer to the Java 7 support question. Eventually I can only give you a starting point for your research, and an idea about the complexity of the system architecture.

    Overall it can be said that the Java 7 issue is something that needs a closer look about the architecture in question, the versions used and what part/module of the software is touched.

    So here is where you find the answers:

    A word to the wise

    Keep in mind, that not being in these lists does not necessary mean, that things do not work.
    It just means that it has not been tested, is not certified, and Oracle does not say anything about it working or not, and therefore does not guarantee its behaviour.
    Chances are - it might just work anyway, but do not come running if it does not.
    Oh and - a lot of people post their findings in the comment section here or in the Communities - so make sure to check there for real-life experience.

    Tuesday Sep 10, 2013

    OBIEE and EPM search helpers are online

    (in via Mel, Tara, Lia)

    In order to make finding information easier, Oracle Support has created a series of what we call search helpers (aka Resolution Wizards, Task Assistant, Troubleshooting Assistant, Installation and Configuration Assistant or Integration Assistant depending on what it is each of them does : ) ).

    One of the problems that our customers face when working with KM is digging up the information they need to overcome a problem.

    This is rather easy when you have an error message to start with. Error messages are great for classifying the type of problem that you have, and you also instantly note if a KM Doc deals with your problem, or not.

    So - what if you do not have an error message? There are many reasons for that. From How to questions, product configuration questions or any other proactive task (like - best backup practice etc.).

    The wording people may use when they write a KM note, may simply not match how you would describe the issue (we see that on a daily basis where people search for "compatibility" while throughout KM "certification" is used) so it might be difficult for the search to match your issue with existing KM notes.

    Would it not be nice if you could run through a kind of interactive checklist that filters down the available KM notes based on your input?

    That's what the search helpers are.

    They are in NO way related to this little chap


    I would describe them as "hand picked, engineer selected, automatically updated, classifying filters to KM".

    With the right search terms you can locate any KM Doc that they display. Alas - that is the trick! You do not need to come up with your own search terms. This is what the search helpers provide.

    Now - where do you find them?

    You can find them via the KM Doc 1378677.2 ( Resolution Wizard ). I have also put a list of available search helpers at the bottom of this post. As this list is constantly growing the question remains: how to keep track of these?

    Good news: You do not need to.

    The search helpers appear automatically when you log an SR.


    (click to enlarge)

    Notice in the above picture, that the search helper comes up as the first KM note offered during the SR logging process (step 2). As the helper is using JQuery for its content, loading the selections happens without opening a new KM Doc - all you see is already pre-loaded. It now offers a choice of search topics that it can assist with.

    When following the selections in this one, it eventually give you a list of KM notes directly related to your issue.


    (click to enlarge)

    So - yay! 

    Search helpers are created as another layer within MOS KM that tries to make information more accessible for you as a customer. Let us know what you think of them. We have a community thread about them ( here for OBIEE ) and are waiting for your feedback.

    Oh, one last remark: search helpers are a work in progress and they do not exist for all our products yet. As we add more, you will encounter them more often, but for now the list below is all we have live.



    List of KM search helpers (as of Sept 09.2013)

    1545233.2 - Troubleshooting Assistant: Oracle Business Intelligence Enterprise Edition (OBIEE)
    1560184.2 - Installation and Configuration Assistant for Oracle Business Intelligence (OBIEE)
    1558400.2 - Integration Assistant with Oracle Business Intelligence (OBIEE)
    1563079.2 - Server Related Issues - Task Assistant for Oracle Business Intelligence (OBIEE)
    1558378.2 - Security/Access Control Assistant for Oracle Business Intelligence (OBIEE)
    1562668.2 - Administration Task Assistant for Oracle Business Intelligence (OBIEE)
    1562361.2 - Presentation Service Task Assistant with Oracle Business Intelligence (OBIEE)
    1562934.2 - Delivers and Schedulers Task Assistant for Oracle Business Intelligence (OBIEE)

    1550461.2 - Troubleshooting Assistant: Hyperion Financial Management Technical Issues 11.1x
    1548628.2 - Task Assistant: Hyperion Financial Management 11.1.x
    1566812.2 - Task Assistant: Hyperion Financial Management and Oracle Data Integrator Issues
    1566505.2 - Task Assistant: Hyperion Financial Management and EPMA Issues
    1553294.2 - Troubleshooting Assistant: Financial Data Quality Management (FDM)

    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
    « July 2014
    SunMonTueWedThuFriSat
      
    1
    5
    6
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
      
           
    Today