Business Analytics Newsletter v6 on Dec 06, 2012

Основные моменты

• The Premier Support for Oracle Business Intelligence Enterprise Edition 10.1.3.x ended in July 2013.
• The Premier Support product life cycle for Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Business Intelligence Publisher 11.1.1.5 ends March 2013.
• Oracle's Hyperion Application Builder.NET (HAB.NET) will not be available for distribution with newer releases of Oracle Essbase. Release 11.1.1.1 is the terminal release. Premier Support for Oracle Hyperion Application Builder.NET 11.1.1.1 ends July 2013, after which Sustaining Support will be provided.
• After 1st January, 2013, Oracle Essbase Spreadsheet Add-in will no longer be available for general distribution with new releases of Oracle Essbase.
• Please be advised that release 11.1.2.2 is the terminal release of the XBRL functionality in Oracle Hyperion Financial Reporting. Premier Support for Oracle Hyperion Financial Reporting release 11.1.2.x ends in April 2015, after which Extended Support is available in April 2018, and Sustaining Support will continue to be provided. Oracle recommends Oracle Hyperion Disclosure Management.

NOTE: "Sustaining Support" does NOT include:

• New program updates, fixes, security alerts, and critical patch updates
• New tax, legal and regulatory updates
• New upgrade scripts
• Certification with new third party products/versions
• 24 hour commitment and response guidelines for Severity 1 service requests.

EPM Patch Set Updates - Recent Releases

The following list are all Patch Set Updates (PSU) (as at 1-Dec-12) that have been released since the last Business Analytics newsletter issue:

Critical Patch Update - September 2011

Только что получил сообщение от Oracle Support: Oracle Security Alert for CVE-2011-3192

Description This security alert addresses the security issue CVE-2011-3192, a denial of service vulnerability in Apache HTTPD, which is applicable to Oracle HTTP Server products based on Apache 2.0 or 2.2. This vulnerability may be remotely exploitable without authentication, i.e. it may be exploited over a network without the need for a username and password. A remote user can exploit this vulnerability to impact the availability of un-patched systems. Affected Products and Versions - Oracle Fusion Middleware 11g Release 1, versions 11.1.1.3.0, 11.1.1.4.0, 11.1.1.5.0 - Oracle Application Server 10g Release 3, version 10.1.3.5.0 (Only affected when Oracle HTTP Server 10g based on Apache 2.0 has been installed from Application Server Companion CD) - Oracle Application Server 10g Release 2, version 10.1.2.3.0 (Only affected when Oracle HTTP Server 10g based on Apache 2.0 has been installed from Application Server Companion CD)

Имейте ввиду и не забывайте о защите! ;)

Как упростить установку обновлений для EPM 11.1.2

Обычная процедура установки обновлений выглядит так:
- Остановка всех или некоторых сервисов;
- Применение патча (через OPatch);
- Иногда нужны дополнительные действия;
- Повторное развертывание компонент на веб-сервере (через EPM Configurator);
- Запуск сервисов.

Я написал небольшой bat-файл для себя, который упрощает второй шаг из перечисленных выше:

set patch_number="hp_11.1.2.0.02"
rem Batch script to automate opatch by Antun Kulkov, 2011
@echo off
set year=%date:~6%
set month=%date:~3,2%
set day=%date:~0,2%
set hour=%time:~0,2%
if "%hour:~0,1%"==" " set hour=0%time:~1,1%
set minute=%time:~3,2%
set tdate=%year%%month%%day%-%hour%%minute%
@echo on
opatch.bat apply %EPM_ORACLE_HOME%\OPatch\%patch_number% -oh %EPM_ORACLE_HOME% -jre %JAVA_HOME% > opatchLog-%tdate%-p%patch_number%.log

Вот такой файл, который нужно положить в %EPM_ORACLE_HOME%\OPatch.
Самое главное – задать в первой строке значение переменной patch_number, которое равно названию папки, в которой лежат обновления. В данном случае применял фикс к Planning (hp_11.1.2.0.02). Если есть пробелы, обязательно берите все значение в кавычки. В ином случае – можно обойтись без них.

Можно, конечно, передавать параметром значение patch_number, но мне так показалось удобнее. А вот делать в цикле, считывая директории, не стоит. Каждое обновление требует дополнительных действий и тщательной проверки после выполнения всех действий по обновлению!

Еще перевязал оригинальный лайн на свой JRE, используя переменную windows-окружения %JAVA_HOME%. У меня это "c:\Java\jdk6\jre". Ну, и пишем все в лог, чтобы иметь возможность отслеживать результаты. Файл лога будет лежать в %EPM_ORACLE_HOME%\OPatch.

Не забываем внимательно читать Readme к каждому патчу и фиксу!

Использовать это!

Получил срочное ночное сообщение от Oracle Support.
Эти патчи:
- 9013376 - Oracle's Hyperion Shared Services 11.1.1.2.03 Service Fix
- 9235068 - Oracle's Hyperion Shared Services 11.1.1.2.06 Service Fix
- 9592841 - Oracle's Hyperion Shared Services 11.1.1.2.07 Service Fix
заменены на:
- 9754381 - Oracle's Hyperion Shared Services 11.1.1.2.09 Service Fix

If you are an Oracle Hyperion Planning customer using Life Cycle Management and have experienced “Unable to connect to Planning Application” message while accessing Lifecycle Management, you are advised to replace the obsolete patch(es) with patch 9754381- Oracle's Hyperion Shared Services 11.1.1.2.09 Service Fix. Replacement instructions are provided in the Readme.

Патчи

Oracle выпустил в рамках своей "октябрьской волны" обновлений патчи для линейки EPM, в частности:
- Patch 9025967: Hyperion Planning Release 9.3.1.1.12 Service Fix
- Patch 9003472: Hyperion Planning Release 11.1.1.1.04 Service Fix

Defects Fixed in Release 9.3.1.1.12
8568887 – Business rule sequences does not work on Planning offline, when set to run on save.
8759898 – You cannot add a folder to the Capex folder in data form management.
8719634 – When entering exchange rates, the Enter and Arrow Keys do not work to navigate the table.
8594393 - When you use the Fill Table function, then try to save exchange rates in an upgraded application, an error is displayed.
8637299 – When multiple users execute Business Rules from the Planning web, Run Time Prompts associated with some rules are not substituted correctly. This results in rule execution failing if the member being substituted is not valid for that application and database.
8482617 - When you search in a data form for a member that is not directly available on the page but can be viewed after scrolling, you are taken to that member. However, the data part of the data form does not scroll, and the row labels and data become misaligned.
8256185 - Ctrl+X does not cut the last cell in a selection. The cell is copied to the clipboard, but is not removed from the data form.
8208121 – When you create a graphical rule in the Hyperion Business Rules Graphical designer to copy data from a source database to a target database, the source outline dimension changes to the target outline dimension when you save the XREF custom formula.
6570543, 8-540099201 - The Size-to-Fit option for Column Width does not work for data forms. After selecting this option, the columns do not expand to accommodate large values.

Defects Fixed in Release 11.1.1.1.04
8992154 - You cannot launch the Essbase Administrative Services console from Web Launcher after applying Planning service fix 11.1.1.1.01, 11.1.1.1.02 or 11.1.1.1.03
Note: You must clear the already downloaded applications in Java Web Server console before launching Essbase Administrative Services console.
9006628 - When multiple users execute Business Rules from the Planning web, Run Time Prompts associated with some rules are not substituted correctly. This results in rule execution failing if the member being substituted is not valid for that application and database.

Oracle Enterprise Performance Management 11.1.1.3.0)

Скачать можно тут.
Прочитать об изменениях можно тут.

Oracle Hyperion Enterprise Performance Management Architect 11.1.1.2.01

Defects Fixed in This Release

· 8554026 - EPMA ERROR DURING PLANNING DEPLOYMENT IF REFRESH OUTLINE IS NOT SELECTED

· 8607978 - CAN'T INVOKE APPUPGR FROM WORKSP IF USER'S NAME HAS MORE THAN 50 CHAR

· 8240849 - INCREASE THE LIMIT ON NUMBER OF EXCLUDED MEMBERS DISPLAYED

· 8374185 - DEPLOYED APPLICTION THAT FAILS TO DELETE RETURNS ERROR ON SECOND DELETE ATTEMPT

· 8374200 - DEPLOYED APPLICTION THAT FAIL TO DELETE RETURN ERROR ON SECOND DELETE ATTEMPT

· 8420451 - BATCH CLIENT ISSUE WHEN TRYING TO UPDATE DESCENDANTS OF SHARED MEMBERS

· 7185420 - RE-DEPLOYMENT ERROR - UNABLE TO FIND OR OPEN [PATH\DATABASENAME.OTN]

· 8395504 - PROBLEM RE-DEPLOYING WHEN A MEMBER HAS BEEN MOVED MULTIPLE TIMES

· 8566021 - OBJECT REPOSITORY GETS OUT OF SYNC FOR TRANSACTION ID

· 8331288 - DATABASE LOCKS NOT RELEASED AFTER IMPORTING METADATA

· 8290923 - DATASTORAGE VALIDATION FAILS WHEN TOP MEMBER IS DYNAMICCALC.

· 8409000 - MERGE IMPORT WITH EXISTING MEMBER PRODUCES RELATIONSHIP MEMBER NOT FOUND

· 8374172 - IMPORTING THE PLANNING SAMPLE .ADS FILE INTO THE APP RESULTS IN ERROR

· 8422539 - UPGRADE CLASSIC PLANNING APPLICATION TO EPMA IS UNSUCCESSFUL

· 8492043 - REPLACE OPTION DOES NOT REPLACE UDA THAT IS ALREADY IN EPMA WITH A BLANK

· 8266973 - NOT ABLE TO CREATE PROFILE IN DIMENSION LIBRARY FOR TURKISH LOCALIZATION

· 8294692 - EXPORT OF ALL SHARED DIMENSIONS APPENDS MSAD USER AS DIM OWNER IN ADS

· 8409020 - ESSBASE SECURITY ACCESS DROPPED FROM EPMA

· 8235072 - VERSION 11.1.1.1 DOES NOT CLEAN UP TRANSACTIONS ONLY BASELINES

· 8374921 - OUT OF MEMORY ISSUE IN DIMENSION SERVER WHILE UPGRADING APP FROM CLASSIC

· 8662461 - ESSBASE BOTTOMOFHIERARCHY FUNC MOVES ALL LEAF LEVEL DATA AND IGNORES HIERARCHY

Hyperion Smart View for Office 9.3.1.6.01

Defects Fixed in Release 9.3.1.6.01

· 8610598 – On Excel 2000, workbooks open slowly when Smart View add-in is enabled.

· 8527518 – When both Essbase Excel Add-in and Smart View are enabled, updating graphs in Excel causes Excel to shut down.

Hyperion Smart View for Office 9.3.1.6

Defects Fixed in Release 9.3.1.6

General

· 6537938 – If you copy a value from inside a grid and paste it outside the grid, any edits you make to the pasted value are lost when you refresh.

· 6580940 – The online help does not open for users who do not have administrative privileges.

· 6587944 – Spreadsheets created and saved in Excel 2007 lose the POV if they are opened in Excel 2003.

· 6666776 – Excel may terminate abruptly when you close it after running a VBA function.

· 6967292 – Smart View incorrectly ignores Excel sheet protection and unlocks cells.

· 7312912 If a workbook contains a large number of Excel objects such as buttons or text boxes, the process memory of EXCEL.EXE may peak and remain high even after you close the workbook. However, you still may see Excel memory leaks.

· 8298960, 7299904, 7300216 – Entering and submitting data in an ad hoc grid does not always change the cell text color as expected, even though the data is submitted successfully.

· 8354320 – Opening Connection Manager from a protected worksheet fails, and the following error message is displayed: "One or more sheets in the workbook are protected. Please unprotect the sheets and try the operation again."

Essbase

· 6591844 – If you select Use Excel Formatting in Smart View Options, cells that contain formulas display incorrect formatting.

· 7434938 – In smartview.bas, HypRetrieveRange was declared incorrectly as object. It should be declared as variant.

· 7675490 – You cannot submit data for cells that link to a different sheet in the same Excel workbook.

· 7700005 – When you attempt to view in Smart View a drill-through report that was created in Essbase Integration Services you should be able to retrieve the report, but instead get the error message, "No drill through reports found at this location."

· 7721231 – When you attempt to refresh on grid columns greater than 676, a blank error message box is returned, though the data is refreshed properly.

· 7758518 – If the Hyperion menu is active in Excel, you cannot save worksheets that are protected in Excel; you get the following error message: "Drawing Objects in one or more sheet(s) in the workbook are protected. Please unprotect them and try to save again."

· 8214296 – The Enhanced Comment Handling option has been improved to enable automatic selection.

· 8247419 – If you select No Data/#Missing in the Options dialog box, VBA functions may become inoperable.

· 8365889 – Refreshing an Excel sheet after pasting data from two different Word data sources causes Excel to terminate.

· 8369071 – When you try to connect to Workspace with SSL enabled, Smart View displays a dialog box containing a list of certificates from which you must choose, even if there are no related certificates or only one certificate.

· 8412440 – HypConnect and HypRetrieve cause the Application.Screenupdating property to be set to true, resulting in slow performance and possibly introducing errors.

· 8423513 – It takes much longer than expected to open a workbook containing Smart View functions.

· 8475319 – Setting enhanced comment handling and refreshing data incorrectly rearranges data and dimensions in spreadsheets.

· 8503380 – If a member is referenced in a header row, you cannot change to the default alias table.

· 8584164 – The VBA function HypSetGlobalOption cannot be used for the replacement label “#Meaningless” in the Options dialog box.

Financial Management

· 6652410 – Members selected on the POV are not saved when the spreadsheet is closed and reopened.

· 7299904 – Cells that reference data on another worksheet may still retain “dirty” color formatting even after they are submitted.

· 8371691 – Smart View files do not get converted if any cells in a file refer to any other cells in the same file, whether in the same sheet or a different sheet. Conversion fails with the error message: “Conversion is not completed in the sheet P&L because there is user defined formula which contains an error in this workbook. Please correct it first and then run Migration Utility.”

· 8541750 – Large worksheets that are heavily used may cause memory leaks in Excel.

Planning

· 8501738 - Using offline, if you map your local My Documents drive to a network drive, you may get the following error message: “’V:\My Documents\hstbar.xla’ cannot be found. Check your spelling, or try a different path.”

Reporting and Analysis

· 6589564 – Users cannot connect to the Reporting and Analysis repository from Excel or Word unless single sign-on is disabled.

Hyperion Shared Services 9.3.1.1

New Features

The following new features are included in this service pack.

· Support for custom authentication module. See Custom Authentication Instructions for details.

· Mechanism to periodically change the encryption key to better secure System 9 products. See Regenerating the SSO Encryption Key for information.

· Restricted access in User Management Console

Enhancement to Infrastructure Support

· High availability support for Shared Services Web application and OpenLDAP using Oracle Clusterware. See Oracle Enterprise Performance Management / Business Intelligence White papers web site for a whitepaper that discusses how to implement Oracle Clusterware support for Shared Services.

Performance Fixes

Performance improvements made in this service pack include the following:

· Improved performance while listing users and groups in Workspace, Planning, and Business Rules

· Improved System 9 login performance

· Improved provisioning performance in User Management Console

· Faster startup of System 9 products

· Improved performance while using the Import/Export Utility

Functional Bug Fixes

Some of the important bug fixes in this service pack include following:

· Essbase Security refresh bug fixes

· Fixes to Projects listing in the User Management Console to correct intermittent disappearance of projects

· Fixes to application status listing in the User Management Console to correct intermittent mislabeling of application status

· Fixes to reduce the number of calls made by System 9 products to LDAP/MSAD servers

· Fixes to correct Financial Management taskflow issues

· Fixes to correct issues in the UpdateNativeDir Utility

Supported Platforms

This service pack can be applied to all supported platforms for release 9.3.1. See the Installation Start Here, for a list of supported platforms.

Supported Languages

This release supports English only.

Oracle Hyperion Planning 11.1.1.2.03

Defects Fixed in Release 11.1.1.2.03

· 8591118 - Planning Web data forms may have performance issues when Calculation Manager rules are attached to the data form.

· 8649922 - During data synchronization in Performance Management Architect, the Level0(member) and BottomofHierarchy(member) functions move all leaf level data of the dimension and ignore the specified member argument. This is an issue with Essbase, Financial Management, and Planning connectors.

Note: The Enterprise Performance Management Architect (EPMA) Release 11.1.1.2.01 must be installed.

Hyperion Essbase 9.3.1.4

Defects Fixed in Release 9.3.1.4

· 6566253– Spreadsheet Client. In Oracle Essbase Spreadsheet Add-in, running VBA programs results in large memory usage in Excel.

· 6672034 – Data Extraction. Issuing Lock and Send commands causes Spreadsheet Add-in to terminate abnormally.

· 6679658 – Metadata. Error messages are sometimes not displayed correctly in the Outline Editor verification window, and a warning treated as an error prevents an otherwise correct outline from saving.

· 7434971 – Attributes. When attributes are retrieved from a BSO application/database, values for shared members do not roll up correctly if the base member is not a level 0 member.

· 7488884 – SQL Interface. At times, no more than two data loads can occur simultaneously.

· 7510439 – EssPerl. Repeated calls return this error message: XS: Fatal error in perl_MaxlOutputNextRecord.

· 7523766 – Kernel. ASO databases may terminate abnormally during exports that are large enough to create multiple export files. (When an export file reaches 2 GB, it starts writing to a new export file that is named sequentially.) This affects both serial and parallel ASO exports.

· 7558950 – MaxL. Parser errors are returned if you encrypt MaxL import data statements containing slice options.

· 7569551 – Agent. Essbase agent hangs when concurrent set active operations are occurring and applications are crashing.

· 7572754 – Metadata. Converting a BSO outline with Time Balance members to aggregate storage sometimes fails and causes Essbase Administration Server to terminate abnormally.

· 7579482 - Metadata. Oracle's Hyperion Planning – System 9 refresh does not complete if a database partition exists, and changes are made to a shared member.

· 7582994 – ASO. YTD calculations return incorrect results when MaxFormulaCacheSize is not large enough.

· 7585809 - ASO. Retrieving data from an ASO database results in an exception and the application terminates abnormally.

· 7596581 – Installation. Errors occur in two Essbase startup scripts (startmaxl.sh and startesscmd.sh) on Linux platforms.

· 7609962 – Calculator. Dynamic calculation results differ between Release 7.1.3 and later releases because of a dense "two-pass" calculation that depends on sparse members.

· 7610230 – Server API. When running MDX queries, Essbase Server terminates abnormally if the administrator forcibly logs out all sessions.

· 7610650 – Server Administration. When loading data and an error occurs, the process continues to run and the application cannot be stopped properly.

· 7612546 – Agent. When OUTLINECHANGELOG is set to true in the essbase.cfg file, ASO applications terminate abnormally when a member is renamed and the outline then is compacted using MaxL.

· 7621018 - MaxL. The MaxL “Display Session” column fails to identify the request and prints a generic request name, “MaxL:Execute.”

· 7623915 – Agent. On HP Itanium, setting the jvmmodulelocation to null in the essbase.cfg file causes errors when you start Essbase.

· 7628183 – Client API. Essbase drill-through reports are not accessible to users connecting with SSO token, through clients such as Oracle's Hyperion Web Analysis – System 9.

· 7631145 - Server Administration. When importing, files larger than 2 GB cannot be opened.

· 7634059 - Server Administration. Connecting and disconnecting to a client multiple times causes the Essbase agent to terminate abnormally.

· 7653525 – Data Extraction. When two consecutive cells with values of zero or #missing return multiple LROs of different types, the returned LRO types are not correct.

· 7660269 – Data Extraction. ReportWriter script executed on an empty target partition incorrectly suppresses rows with data.

· 7660328 - API. Calling the API function EssDisplayTriggers sometimes caused the API client program to terminate abnormally. In addition, if the user was searching for a trigger that did not exist, the function would erroneously give the error message “Please upgrade your client application.”

· 7675024 – MDX. An exception occurs on Essbase Server when running an MDX query with embedded substitution variables.

· 7682215 - MDX. Essbase Server terminates abnormally on Windows AMD 64-bit platform while running an MDX query that has a calculated member on the slicer with a solve order of AGGREGATION_SOLVEORDER.

· 7682260 - MDX. Essbase Server terminates abnormally while running an MDX query containing a FILTER function with a large conditional expression.

· 7827499 – Security. Running a full refresh in Administration Console causes groups to disappear from Hyperion Shared Services.

· 8230465 - Data extraction. ASO databases sometimes terminate abnormally when an Essbase user who has a filter runs a report.

· 8230482 – Calculator. Some calculations take much longer to run in Essbase 9.3.1.2 compared to Essbase 7.1.3 on HP-UX 11.11 PA-RISC.

· 8251402 – ASO. Retrievals on ASO databases with time balance may fail with out of memory errors.

· 8257035 – Agent. Essbase agent fails when the app directory contains a symbolic link.

· 8264167 – Data extraction. Execution of incorrect asymmetric report on BSO database by user with filtered access causes Essbase to terminate abnormally.

· 8272955 – MDX. Member names that contain ampersands (&) that are not surrounded by spaces (such as “B &Z” for member name) cause query errors.

· 8275606 - Calculator. When running Essbase on 32-bit HP-UX, calculations yield double values for some members.

· 8296358 – Installation. Spreadsheet Add-in installation location is incorrect when using the silent installer.

· 8331758 – Agent. After upgrading to Release 9.3.1.3.4, Essbase terminates abnormally during security refresh.

· 8334682 - Server Administration. The Essbase Administration Server call-back URL is not set properly in the .instance files when Essbase Administration Server is configured on SSL port. Instead of pointing to https, it points to http.

Hyperion Essbase Administration Services 9.3.1.4

Defects Fixed in Release 9.3.1.4.00

Export Filters To Shared Services Fails

Clicking the “Export Filters to Shared Services” button in Administration Services Console fails to export filters and results in an error message. This feature was deprecated, and the button has been removed. (7705584)

Data and Rules Files Deleted when Running MaxL Import

Executing a data load in MaxL Editor using the “import…from local” command may result in deletion of the data and rules files. (7507246, 7566303)

Invalid eas location is Set when Deployed on a Port with Fewer than Five Digits

If Administration Services has been deployed to an application server on a port number containing fewer than five digits, an invalid eas location will be set in Essbase and Shared Services instance files, causing access errors while using Administration Services in Shared Services mode. In other words, a deployment on port 9091 may generate errors, but a deployment on port 19091 will not. (7516152)

Essbase Application Settings Deployed from Performance Management Architect Works Only Once

After deploying an application to Essbase From Hyperion Enterprise Performance Management Architect, subsequent attempts to redeploy the application may result in application settings not being successfully deployed. (8202329, 8225983)

Data Load Scale Setting May Not Work Properly

When loading data using a rules file, setting the scale may not work correctly. (7625997)

Incorrect Check Box Description In Add Essbase Server Dialog

The “use external authentication” check box was incorrectly labeled in the Add Essbase Server dialog box. The name has been changed to “Use Single Sign-On.” (8354239)

Unnecessary Warning in Partition Wizard

In Partition Wizard, a warning message regarding potential overwriting of a target application and database may be displayed even if no target application or database has been selected. (7272501)

Passwords Displayed as Clear Text

When viewing Essbase server connections in the User Properties dialog box, the password may be displayed as clear text if the password column is moved. (7637083, 8321435)

Can't Delete Sparse Dimension on AIX

If Essbase Administration Server is installed on a server running AIX 5.3, deletion of a dimension from Administration Services Console may fail. The outline will show the dimension as deleted, but when the outline is closed and reopened, the dimension will reappear. (7557518)

Cancel Button in Deleted Dimension Dialog Box Works Incorrectly

Clicking the Cancel button in the Delete Dimension dialog box may result in an incorrect result, such as incorrectly removing the dimension from the outline view even though the dimension is not deleted. (7562501)

Retrieving/Saving Substitution Variables Fails

Retrieving and saving substitution variables using the Open SQL dialog box may fail. (8409278)

Unicode Encoding Issue with Report Scripts

When a report script is run against a non-Unicode application, the resulting report may be UTF-8 encoded. Attempting to import this script into Essbase will generate an “Essbase Error: Loading Unicode-encoded data to non-Unicode mode application is not supported.” (8450369)

Saving Aggregate Storage Outlines to Essbase 9.3.1.2 Will Fail

When running Administration Services Release 9.3.1.3, saving an aggregate storage outline to Essbase Release 9.3.1.2 will fail. (8413246)

Empty Nodes Displayed Incorrectly

Displaying an Attribute Calculation dimension in Filter Editor in an aggregate storage outline may show extra empty nodes. (6551283)

Data Load Errors Not Written to File

When Administration Services Console is running on a different computer from Essbase Administration Server, errors occurring during a data load may not be written to the error log. The workaround is to specify a different error log file for each separate load. (7552094)

Silent Installation May Not Read Setup

When performing a silent installation of Administration Services Console, the installation may not read information from the setup file. (8246949)

Null Email Address May Corrupt User XML File

When a user is external, and there is no email address associated with the user, the user XML file may become corrupted. (8447445)

Hyperion Analytic Provider Services 9.3.1.4

Defects Fixed in Release 9.3.1.4

· 7263346 - In Smart View, submitting #missing using HSSETVAL returns an “Empty String” error message.

· 7434553 - In Workspace, you cannot run Essbase drill-through from Web Analysis reports for users other than the administrator.

· 7452203 - In Smart View, if a large number of Essbase connections exists, adding an Essbase connection returns a “Cannot list olap applications. Null” error message, and the connection is not created.

· 7572202 - In Smart View connected to Essbase, when you expand the Essbase node in Connection Manager to open the list of applications, you may get an error message. This happens only if you have more than 262 applications.

· 7615604 - Ancestors are displayed in different positions when you zoom- in versus using member selection.

· 7649867 - Regression function values disappear when the alias table is changed.

· 7659650 - Refreshing cells containing =HSGETVALUE returns “#Invalid member xxxx for dimension xxxx” error message.

· 7666239 - When Essbase Integration Server is not running, requests for drill-through from Smart View return a “Cannot perform cube view operation.null” error message.

· 7685570 - In Smart View, HSGETVALUE performance is slower in release 9.3.1.2 than in release 9.2.0.

· 7700730 - When two consecutive cells with values of #missing return multiple LROs of different types, the returned LRO types are not correct.

· 7707808 - Listing applications using the JAPI method getApplications () returns a com.essbase.api.base.Ess exception when the number of applications is greater than 525.

· 7757303 - Running an MDX query through JAPI against an application created with Studio returns this error: Error: Cannot perform cube view operation. Analytic Server Error6117

· 7834684 - Smart View clients connected to Provider Services 9.3.1.2 are not backward compatible with Essbase releases earlier than 9.3.1 when Essbase is deployed in Shared Services mode.

· 8210386 - Users with an active session are able to log on again using invalid passwords.

· 8231521 - After installing Provider Services 9.3.1.3 on Win64, the default Tomcat server (located at /bin/StartAPSTomcatServer.bat) fails to run because JAVA_HOME is set incorrectly.

· 8282497 - Using HSGETVALUE with cell references on sheets with multiple points of view locks up all open connections.

Hyperion Planning 9.3.1.1.11 Service Fix

19 мая появился свежий патчик для пленинга (Metalink #8527948). Вот список исправлений:

Defects Fixed in Release 9.3.1.1.11

· 8517525 – The Planning cube refresh utility does not display correct usage for PARAMETER /FSV or /FVS.

· 8429971 – In data forms, Smart Lists do not work with user variables.

· 8426056 – When you restart the Planning Web service, Smart Lists associated with the Period dimension members are removed.

· 8405636 – SSL communications from Workspace to Planning is unsuccessful.

· 8308229 – After upgrading to Planning 9.3.1.1.5 or higher, existing Essbase custom defined functions in Business Rules may not work.

· 8300814 - When limits are specified for a run time prompt, members are not returned in hierarchical order or alphabetical order in the Planning Member Selection dialog box.

· 8217170 - Planning may output out-of-memory errors after continuous launch of rules in Planning Web.

· 8208968 – Data forms with rules attached take a longer time to open if there are numerous rules.

· 8198005 – Supporting Details calculated values are not updated in the associated cell in the Web form if the values are directly entered in the Web form while the supporting details window is open.

· 7830283 - When running a Business Rule in Essbase Administration Services and selecting a dimension member for a runtime prompt, not all the dimension members are listed and some members are listed twice.

· 7817828 - Working with a graphical rule that contains AND, OR, and NOT component may output an error message.

· 7715336, 8351274 - Substitution variables may not be displayed in the Member Selection dialog box in Planning Web running on a WebSphere application server.

· 7714456 - Invalid values are moved to Essbase from Planning during a cube create or refresh if exchange rate method is set to divide.

· 7640704 - The Initialize Workforce and Initialize Capex options proceed without a user confirmation.

· 7590751, 8207363 - In the Effective Access report, the Show Effective Origin option does not work.

· 7589261 - Improved messaging is provided to differentiate a Planning Create and a Planning Refresh.

· 7554316 – When you open the Member Selection dialog box in Smart View, an error message is displayed if a substitution variable value contains an ampersand.

· 7015931 - Outline Refresh and Create Filters do not work if they are selected together during application deployment.

· 8485406 – Essbase Administrator Services session count increases on the Oracle database repository when the Administrator Services server is running.

· 8479241 - Shared member alias displays as null in page dimension in the Planning Web form.

· 8464904 – Opening a Planning application in Workspace may output a javascript error.

· 8240092 – A very long Essbase Administration Services server host name may result in updates to business rules not available in Planning Web.

· 6819869 – When two business rules are run simultaneously, an error message is displayed and the business rules may stop running.