Thursday Feb 26, 2015

Patch Set Update: Hyperion Essbase 11.1.2.3.506

The following Patch Set Updates (PSU) have been released for Oracle Hyperion Essbase 11.1.2.3.x.

These PSU downloads are available from the My Oracle Support | Patches & Updates section.

Hyperion Essbase Server 11.1.2.3.506

Patch 20184072: Essbase Server

Hyperion Essbase Client 11.1.2.3.506

Patch 20184078: Essbase RTC
Patch 20184067: Essbase Client
Patch 20184082: Essbase MSI

These PSU releases can be applied to the following releases of existing Hyperion Essbase installations:


  • 11.1.2.3.000
  • 11.1.2.3.001
  • 11.1.2.3.002
  • 11.1.2.3.003
  • 11.1.2.3.500
  • 11.1.2.3.501
  • 11.1.2.3.502
  • 11.1.2.3.503
  • 11.1.2.3.504
  • 11.1.2.3.505

Note: Versions listed may not have been released for all Essbase components.

Supported for use with Hyperion Essbase 11.1.2.3.506 are:

  • Essbase Administration Services (EAS) 11.1.2.3.505
  • Essbase Analytic Provider Services (APS) 11.1.2.3.505
  • Essbase Studio 11.1.2.3.505

Refer to the Readme files prior to proceeding with these PSU implementations for important information that includes the supported paths per component, along with a full list of the defects fixed, additional support information, prerequisites, details for applying patch and troubleshooting FAQ's.

It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file. The Readme file is available from the Patches & Updates download screen for each of the Hyperion Essbase components..


To locate the latest Essbase Patch Sets and Patch Set Updates at anytime visit the My Oracle Support (MOS) Knowledge Article:

Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase
Doc ID 1396084.1

Why not share your experience about installing this patch ...

In the MOS | Patches & Updates screen simply click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space:

Hyperion Patch Reviews

For questions specific to Hyperion Essbase ...

The My Oracle Support Community "Hyperion Essbase" is the ideal first stop to seek & find product specific answers:

Hyperion Essbase

Friday Feb 06, 2015

error 1030830 - need to recompile Essbase API clients in EPM 11.1.2.4

(in via Nancy)

We were just informed that there might be an issue when migrating API clients to the latest 11.1.2.4 release of Essbase.

Situation:
An API client executable was written in Java or C (remember the VB-API is not supported any more) and compiled using the 11.1.2.3.x RTC.

If you then try to use that client on a new installation of 11.1.2.4 with RTC 11.1.2.4 you may see the error:

Error 1030830
(with no additional text)

Searching for this Error in the  Error message Guide will not assist, as it is not documented yet.

However, you can find it in the esserror.h file:

"Error 1030830 The client was compiled using an earlier version of Essbase runtime client (RTC). Recompile your executable with the RTC that you are currently using. "

So that is what needs to be done - recompile the client executable with the latest RTC 11.1.2.4.

We also have created a KM note about this known issue (  Doc ID 1967479.1 )

(info: Nancy; Text and Layout: Torben; authorized: Lia)

Thursday Dec 04, 2014

Advisor Webcast: Getting Started with Essbase Aggregate Storage Option - ASO 101

Advisor Webcast

 Getting Started with
Essbase Aggregate Storage Option - ASO 101

10th December 2014

New Date: 20th January 2015


3:00 PM UTC/GMT

This one-hour session is recommended for Administrators and Application Designers who work with Oracle Essbase. It is aimed at Essbase users who have been mainly working with Essbase BSO in the past and want to get started with ASO.

Prerequisite: classic Essbase concepts of multidimensionality, data handling and calculation

The webcast will cover the very basic concepts and differences between ASO and BSO. Simple Formulas, data loading, retrieve etc. always with a focus on the differences and compared to BSO databases. So if you have been working with classic Essbase, but have not touched ASO yet, this webcast may give you an easy start to switch to using ASO in the future.

TOPICS WILL INCLUDE:

  • Definition of ASO specfic terms
  • ASO Syntax
  • Basic formulas and operations
  • Comparison of "Calculation Speed"
  • Recommended readings and Documentation


Register Now - visit:

My Oracle Support Community
Getting Started with Essbase Aggregate Storage Option - ASO 101


Register


To view scheduled & archived recordings of previous Business Analytics Advisor Webcasts visit:

Oracle Business Analytics Advisor Webcast
Doc ID 1456233.1



CUSTOMER NOTIFICATION : Attendees using recent Chrome or Firefox browser versions maybe required to activate the WebEx plug-in before joining a WebEx meeting. For up to-date information review the WebEx Support page:

https://support.webex.com/webex/meetings/en_US/chrome-firefox-join-faq.htm


Thursday Nov 27, 2014

Patch Set Update: Hyperion Essbase 11.1.2.3.505

The following Patch Set Updates (PSU) have been released for Oracle Hyperion Essbase 11.1.2.3.x.

These PSU downloads are available from the My Oracle Support | Patches & Updates section.

Hyperion Essbase Server 11.1.2.3.505

Patch 19906085: Essbase Server

Hyperion Essbase Client 11.1.2.3.505

Patch 19906081: Essbase RTC
Patch 19906103: Essbase Client
Patch 19906079: Essbase MSI

Hyperion Essbase Administration Services (EAS) 11.1.2.3.505

Patch 19613844: Essbase Server
Patch 19613853: Essbase Console MSI

Hyperion Analytic Provider Services (APS) 11.1.2.3.505

Patch 19509172: APS Services

Hyperion Essbase Studio 11.1.2.3.505

Patch 19509186: Essbase Studio Server
Patch 19509181: Essbase Studio Console MSI

These PSU releases can be applied to the following releases of existing Hyperion Essbase installations:


  • 11.1.2.3.000
  • 11.1.2.3.001
  • 11.1.2.3.002
  • 11.1.2.3.003
  • 11.1.2.3.500
  • 11.1.2.3.501
  • 11.1.2.3.502
  • 11.1.2.3.503
  • 11.1.2.3.504

Note: Versions listed may not have been released for all Essbase components.

Refer to the Readme files prior to proceeding with these PSU implementations for important information that includes the supported paths per component, along with a full list of the defects fixed, additional support information, prerequisites, details for applying patch and troubleshooting FAQ's.

It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file. The Readme file is available from the Patches & Updates download screen for each of the Hyperion Essbase components..


To locate the latest Essbase Patch Sets and Patch Set Updates at anytime visit the My Oracle Support (MOS) Knowledge Article:

Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase
Doc ID 1396084.1

Why not share your experience about installing this patch ...

In the MOS | Patches & Updates screen simply click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space:

Hyperion Patch Reviews

For questions specific to Hyperion Essbase ...

The My Oracle Support Community "Hyperion Essbase" is the ideal first stop to seek & find product specific answers:

Hyperion Essbase

Thursday Nov 20, 2014

Patch Set Update: Essbase Analytics Link for HFM 11.1.2.2.400

Hyperion Product Management have advised the release of a Patch Set Update (PSU) for Oracle Essbase Analytics Link (EAL) for Hyperion Financial Management (HFM) 11.1.2.2.x

This PSU is available from the My Oracle Support | Patches & Updates section.


Oracle Essbase Analytics Link for Hyperion Financial Management
Patch 17395188

This PSU provides various defect fixes and is a cumulative patch that includes the previous patches. It can be applied to the following releases only:

  • EPM 11.1.2.2.xxx
  • EPM 11.1.2.3.xxx

The EPM pre-11.1.2.2.xxx releases are not supported.

The EAL for HFM 11.1.2.2.400 requires a fresh installation and the previous release is required to be uninstalled prior starting the install. The installation process will use the Oracle Universal Installer (OUI) 11.2 (32-bit), however it will install a version that matches either 32-bit or 64-bit Operating System as applicable.

Ensure to review the Readme file prior to proceeding with this PSU implementation for the full details of the above, along with important information that includes additional support information, defects fixed listing, prerequisites and installation details for this PSU.

The Readme file is available from the Patches & Updates download screen.

Share your experience about installing this patch ...

In the MOS | Patches & Updates screen for EAL for HFM Patch 17395188 - simply click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space:

Hyperion Patch Reviews

Questions specific to Essbase Analytics Link for Hyperion Financial Management ...

The My Oracle Support Community "HFM" is an ideal place to seek & find product specific answers:

Hyperion Financial Management (HFM)

Wednesday Oct 29, 2014

Patch Set Update: Hyperion Essbase 11.1.2.3.504

The following Patch Set Updates (PSU) have been released for Oracle Hyperion Essbase 11.1.2.3.x.

These PSU downloads are available from the My Oracle Support | Patches & Updates section.

Hyperion Essbase Server 11.1.2.3.504

Patch 19613865: Essbase Server

Hyperion Essbase Client 11.1.2.3.504

Patch 19613868: Essbase RTC
Patch 19613886: Essbase Client
Patch 19613877: Essbase MSI

These PSU releases can be applied to the following releases of existing Hyperion Essbase installations:


  • 11.1.2.3.000
  • 11.1.2.3.001
  • 11.1.2.3.002
  • 11.1.2.3.003
  • 11.1.2.3.500
  • 11.1.2.3.501
  • 11.1.2.3.502
  • 11.1.2.3.503

At time of writing, there is no current 11.1.2.3.504 release for:

- Hyperion Essbase Administration Services (EAS)
- Hyperion Analytic Provider Services (APS)
- Hyperion Essbase Studio

It is recommended the same version of all Essbase portfolio products (Essbase, Essbase Administration Services, Hyperion Provider Services, and Essbase Studio) and components (server, client, runtime client, API, and JAPI) are used. When only some Essbase portfolio products are included in a patch release, the last released versions of the products that are not included in the patch are supported.

Essbase Administration Services 11.1.2.3.503, Provider Services 11.1.2.3.502, and Essbase Studio 11.1.2.3.502 are supported for use with Essbase 11.1.2.3.504.

Refer to the Readme files prior to proceeding with these PSU implementations for important information that includes a full list of the defects fixed, along with additional support information, prerequisites, details for applying patch and troubleshooting FAQ's.

It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file. The Readme file is available from the Patches & Updates download screen.


To locate the latest Essbase Patch Sets and Patch Set Updates at anytime visit the My Oracle Support (MOS) Knowledge Article:

Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase
Doc ID 1396084.1

Why not share your experience about installing this patch ...

In the MOS | Patches & Updates screen simply click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space:

Hyperion Patch Reviews

Thursday Oct 02, 2014

Essbase product family 11.1.2.3.503 patches released

(in via Greg)

Hyperion Product Management have advised the release of the

11.1.2.3.503

series of patches for the Hyperion Essbase 11.1.2.3.x products family.

These patches are available from the My Oracle Support | Patches & Updates section, or via the respective KM Docs


Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase
KM Doc 1396084.1

Please review the Readme file prior to proceeding with these patches. The readme contains important information such as additional support information, prerequisites, details for applying patch and troubleshooting FAQ's.


Please note:

There has been no 11.1.2.3.503 patch for Hyperion Essbase Studio or for the Analytic Provider Services.


Why not share your experience about installing this patch ...

In the MOS | Patches & Updates screen simply click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space:

Hyperion Patch Reviews

(info: PM; text and layout: Torben; authorized: Lia)

Thursday Sep 11, 2014

Patch Set Update: BI+ Financial Reporting 11.1.2.3.503

The Hyperion Product Management have advised the release of a Patch Set Update (PSU) for Hyperion BI+ Financial Reporting 11.1.2.3.x

This PSU is available from the My Oracle Support | Patches & Updates section.

Hyperion Financial Reporting PSU 11.1.2.3.503
Patch 19570230

This PSU can be applied to the following releases:

  • 11.1.2.3.500
  • 11.1.2.3.500 PSE 18467894
  • 11.1.2.3.500 PSE 18609854
  • 11.1.2.3.501 PSU 18183723
  • 11.1.2.3.502 PSU 19033046

The PSU 11.1.2.3.503 patch addresses issues encountered with Batch Scheduler and redundant Essbase sessions in Hyperion FR 11.1.2.3.502. It is a cumulative patch and includes the fixes from previous 11.1.2.3.50x releases.

Ensure to review the Readme file prior proceeding with this PSU implementation for important information that includes additional support information, prerequisites, details for applying patch and troubleshooting FAQ's.

The Readme file is available from the Patches & Updates download screen.

Sharing your experience about installing this patch ...

In the MOS | Patches & Updates screen simply click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space:

Hyperion Patch Reviews

For questions specific to Hyperion FR ...

The My Oracle Support Community "Hyperion Reporting Products" is the ideal first stop to seek & find product specific answers:

Hyperion Reporting Products

Wednesday Sep 10, 2014

Essbase Integration Services - Statement of Direction

(in via Susan)

The Essbase Integration Services product has reached its final stage.

Starting out as Arbor Integration Server (AIS) the product quickly became known as Hyperion Integration Server (HIS) after the Arbor/Hyperion merge in 1998.  The product was then also known as Essbase Integration Server (EIS), Analytic Integration Services (AIS) and finally as Essbase Integration Services (EIS).

EIS has mapped many a relational Database into Essbase and made seamless integration and drill through easy to achieve and maintain.

The Statement of Direction for the Essbase Integration Services has now been released:

Oracle Essbase Integration Services Statement of Direction
Doc ID 1921432.1

The details state that EIS 11.1.2.3 is the final release of EIS and it will not be shipped from version 11.1.2.4 on.

Oracle will continue to support Hyperion Essbase Integration Services in accordance with the  Lifetime Support Policy .

It does not come as a surprise that the evolution of Enterprise Performance Management System (EPM) required a new and more powerful system. It was now necessary to also tie in Planning and HFM databases, so a new technology emerged:

Essbase Studio - released in 11.1.1.x, it was soon announced to be the new strategic platform to use for RDBMS to Essbase integration.

Now that Essbase Studio has been on the market for some time and has been well adopted by a larger customer base, it is time to move from EIS to Studio within the next few releases.

As luck would have it, there is an import wizard in Essbase Studio that should make the import of older EIS models and metaoutlines easy.

Yet -  be aware that the way that Studio works is different than EIS, so it is recommended prior use to review the Essbase Studio User Guide.



Monday Aug 25, 2014

Patch Set Update: Hyperion Essbase 11.1.2.3.502

The following Patch Set Updates (PSU) have been released for Oracle Hyperion Essbase 11.1.2.3.x.

These PSU downloads are available from the My Oracle Support | Patches & Updates section.

Hyperion Essbase Server 11.1.2.3.502

Patch 18950479: Essbase Server

Hyperion Essbase Client 11.2.3.502

Patch 18950453: Essbase RTC
Patch 18950474: Essbase Client
Patch 18950482: Essbase MSI

Hyperion Essbase Administration Services (EAS) 11.1.2.3.502

Patch 17767626: Essbase Server
Patch 17767628: Essbase Console MSI

Hyperion Analytic Provider Services (APS) 11.1.2.3.502

Patch 18907738: APS Services

Hyperion Essbase Studio 11.1.2.3.502

Patch 18907980: Essbase Studio Server
Patch 18907987: Essbase Studio Console MSI

Refer to the Readme files prior to proceeding with these PSU implementations for important information that includes a full list of the defects fixed, along with additional support information, prerequisites, details for applying patch and troubleshooting FAQ's.

It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file. The Readme file is available from the Patches & Updates download screen.


To locate the latest Essbase Patch Sets and Patch Set Updates at anytime visit the My Oracle Support (MOS) Knowledge Article:

Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase
Doc ID 1396084.1

Why not share your experience about installing this patch ...

In the MOS | Patches & Updates screen simply click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space:

Hyperion Patch Reviews

Tuesday Apr 08, 2014

Advisor Webcast: Troubleshooting Essbase Analytics Link

Advisor Webcast

 Troubleshooting Essbase Analytics Link

16th April 2014
2:00 PM UTC/GMT

This one-hour session is recommended for technical and functional users who use and administer Essbase Analytics Link.

The Advisor Webcast will cover installation preparation and planning, troubleshooting techniques, log file locations, how to read and interpret the logs as well as talk about the internal communication between EAL components.

In addition the Ports and Protocols used as well as the prerequisites to establish the connections will be addressed, with a quick look at tools to assist with troubleshooting.

TOPICS WILL INCLUDE:

  • EAL Architecture
  • EAL Communication Paths
  • Use Cases
  • Troubleshooting Installation and Configuration


Register Now - visit:

Troubleshooting Essbase Analytics Link
Doc ID 1633062.1

Register



To view scheduled & archived recordings of previous Business Analytics Advisor Webcasts visit:

Oracle Business Analytics Advisor Webcast [Doc ID 1456233.1]



CUSTOMER NOTIFICATION :

Attendees using recent Chrome or Firefox browser versions maybe required to activate the WebEx plug-in before joining a WebEx meeting.

For up to-date information ensure to review the WebEx Support page:
https://support.webex.com/webex/meetings/en_US/chrome-firefox-join-faq.htm


Friday Mar 21, 2014

Patch Release: Hyperion Essbase 11.1.2.3.500 PSU

The Oracle Hyperion Essbase 11.1.2.3.500 Patch Set Updates (PSU) have been released.

These are available for download via the My Oracle Support | Patches & Updates section. The "Patch" ID links below will access each these PSU patches directly.


Hyperion Essbase Server 11.1.2.3.500
     - Patch 17767302: Essbase Server


Hyperion Essbase Client 11.1.2.3.500
     - Patch 17767299: Essbase RTC
     - Patch 17767301: Essbase Client
     - Patch 17767307: Essbase Client MSI


Hyperion Essbase Studio Server 11.1.2.3.500
     - Patch 17767295: Essbase Studio Server
     - Patch 17767296: Essbase Studio Console MSI


Hyperion Essbase Administration Services (EAS) 11.1.2.3.500
     - Patch 17767309: EAS Server
     - Patch 17767316: EAS Console MSI


Hyperion Analytic Provider Services (APS) 11.1.2.3.500
      -
Patch 17767293: APS Services




Be sure to review the related Readme files
available per Patch Set Update
.

... for the latest Business Analytics Patch Sets & Patch Set Updates visit:

Doc ID 1400559.1 - Oracle Hyperion EPM Products
Doc ID 1488475.1 - OBIEE 11g

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

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 Apr 30, 2013

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.


About


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

Authors:

italia.nowodworska@oracle.com
torben.hein@oracle.com
paul.anderson@oracle.com
julie.foster@oracle.com





Search

Archives
« March 2015
SunMonTueWedThuFriSat
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today