28 апреля 2012

Изменение датасурса таблицы отчета Financial Reporting

Задача стоит так: изменить датасурс таблицы в одном отдельно взятом отчете FR (а не во всех). Источник – новое (другое, не промышленное) приложение HFM. Продакшн система – EPM 11.1.2.00.
Ограничение: В самом отчете через FR Studio для ранее настроенной таблицы данных (grid) изменить датасурс нельзя
Два пути решения: Вручную заново создать и собрать таблицу (долго и можно ошибиться) или изменить датасурс.
Если нужно изменить датасурс для всех таблиц отчетов, то нужно просто обновить существующий DB Connection на другое приложение: Workspace - Explore - Tools - DB Connection Manager
Решаем поставленную задачу:

1.    Создаем новый датасурс (DB Connection) для нового приложения HFM

a.    Идем в Workspace - Explore - Tools - DB Connection Manager
b.    Создаем новый датасурс на новое приложение, назовем его DS_new

2.    Получаем правильную ссылку на новый датасурс

Для этого нужно:
a.    Накидать новый простейший отчет с таблицей (кинуть по измерению в строки и столбцы, этого достаточно), привязавшись к DS_new. Назовем отчет REP_test
b.    Сохранить таблицу (grid) как отдельный объект в FR Studio (на заголовке Grid через райт-клик вызвать Save Object). Назовем таблицу GRID_test
c.    Экспортировать эту таблицу c помощью LCM на диск: LCM (HSS) - Application Groups – Reporting and Analysis – Repository Objects - <нужный объект>
d.    На диске (в папке import_export) найти файлик вида 00000136f2bdb8b6-0000-b8b3-ac16006a (GRID_test).00000136f2bdb8c8-0000-b8b3-ac16006a_1, где GRID_test - это имя, указанное при выгрузке в LCM
e.    Открыть этот файл в Notepad++ (любимом текстовом редакторе) и из него скопировть ссылку на новый нужный датасурс (вторая строка): поля DATASOURCE_DETAILS и DATASOURCE_ID
Замечание: при выгрузке отчета целиком (REP_test), я не смог найти этих объектов и ссылки на DS_new, поэтому пришлось экспортировать отдельно таблицу (GRID_test). См. шаги 2 b - 2 d
f.    После этого объекты REP_test и GRID_test в FR Studio можно удалить

3.    Обновляем датасурс таблицы данных (grid)

Для этого нужно:
a.    Сделать копию оригинального отчета. Назовем копию REP_new
b.    Сохранить таблицу (grid) из REP_new как отдельный объект в FR Studio. Назовем таблицу GRID_new
c.    Экспортировать эту таблицу c помощью LCM на диск
d.    На диске (в папке import_export) найти файлик вида 00000136f2bdb8b6-0000-b8b3-ac16006a (GRID_new).00000136f2bdb8c8-0000-b8b3-ac16006a_1, где GRID_new - это имя, указанное при выгрузке в LCM
e.    Открыть этот файл в Notepad++ и заменить в нем ссылку на новый нужный датасурс (вторая строка): поля DATASOURCE_DETAILS и DATASOURCE_ID, полученные на шаге 2 e.
f.    Удалить в FR Studio объект GRID_new
g.    Импортировать с помощью LCM обратно в R&A обновленный на шаге 3e GRID_new
h.    Открыть отчет REP_new, удалить в нем имеющуюся таблицу (grid)
i.    Импортировать в отчет REP_new обновленный GRID_new: Insert – Saved Objects
j.    Задать таблице нужные размеры и сохранить отчет, убедившись, что датасурс таблицы обновлен
В качестве альтернативного решения можно попробовать исправить ссылку на датасурс в самой БД, но там черт ногу сломит.

23 апреля 2012

Настройка сервера и клиента для работы со SmartView

В ходе эксплуатации системы во время работы, SmartView (над Planning/Essbase) может "обрадовать" пользователя сообщениями вроде:
  • The request timed out. Contact your administrator to increase netRetrycount and netRetryInterval
  • Request grid size is more than allowed limit
Чтобы избежать первой проблемы, связанной с сетевыми параметрами, необходимо корректно настроить как серверную, так и клиентскую стороны системы:
  1. Прописываем сетевые параметры на сервере в essbase.cfg (или через EAS Console):
  1. В соответствии с рекомендацией Oracle "The Combined Parameters of NETDELAY and NETRETRYCOUNT" [ID 877432.1] произведение параметров NETDELAY и NETRETRYCOUNT не должно превышать 10 минут. На этот лимит и будем всё настраивать. Пример расчета:
1000 for NETDELAY
600  for NETRETRYCOUNT
1000 x 600 = 600000
Divide by 1000 = 600
Divide by 60 = 10 minutes
  1. Перезапускаем сервер Essbase (службу OPMN), чтобы изменения вступили в силу.
  2. Готовим изменения реестра операционных систем на клиентских станциях (на базе Windows XP; Windows 7), используя параметры: 
    • KeepAliveTimeout (интервал проверки активности HTTP-соединений) и ServerInfoTimeout, причем второй нам понадобится, т.к. значение первого превысит 2 минуты; значение второго параметра идентично значению первого
    • ReceiveTimeout (ограничение на время возврата данных от сервера)
  3. В соответствии с рекомендацией Oracle "Smart View Error: The request timed out. Contact your administrator to increase netRetrycount and netRetryInterval" [ID 744559.1] и "FDM Timeout on Import When Using Internet Explorer 7" [ID 1246294.1] получаем файл (*.reg) для внесения изменений в реестр на клиентской станции:
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
"ReceiveTimeout"=dword:000927c0
"ServerInfoTimeout"=dword:000927c0

"KeepAliveTimeout"=dword:000927c0
где 000927c0 - это 600000 мсек в HEX-представлении
  1. Этот файл необходимо применить на клиентской станции и перезагрузить ее, чтобы изменения вступили в силу.
Для решения второй проблемы, связанной с ограничением количества запрашиваемых из SmartView у сервера ячеек данных, необходимо настроить только серверную часть:
  1. Прописываем параметр на сервере в essbase.cfg (или через EAS Console):
MAX_REQUEST_GRID_SIZE EssbaseAppName 5000000
  1. В соответствии с рекомендацией Oracle "When Executing MDX Query Network Error Occurs: "[10054] Cannot Send Data" [ID 1071407.1] необходимо также настроить сетевые параметры на сервере. Это мы уже сделали, борясь с первой проблемой :)
  2. Перезапускаем сервер Essbase (службу OPMN), чтобы изменения вступили в силу.

22 апреля 2012

Рекомендуемые настройки браузера IE

Internet Explorer (IE7, IE8 and IE9) Recommended Settings for Oracle Hyperion Products [ID 820892.1]

Applies to:

Hyperion Planning - Version: 9.3.1.0.00 to 11.1.2.1.000 - Release: 9.3 to 11.1
Hyperion BI+ - Version: 9.3.0.0.00 to 11.1.2.1.000   [Release: 9.3 to 11.1]
Hyperion Essbase Administration Services - Version: 9.3.0.0.00 to 11.1.2.1.000   [Release: 9.3 to 11.1]
Hyperion Financial Management - Version: 9.2.1.0.00 to 11.1.2.0.00   [Release: 9.2 to 11.1]
Hyperion Financial Data Quality Management - Version: 9.2.0.0.00 to 11.1.2.1.000   [Release: 9.2 to 11.1]
Information in this document applies to any platform.

Goal

The following Internet Explorer settings should be applied in order for Oracle Hyperion Products to work correctly with Internet Explorer 7 (IE 7), Internet Explorer 8 (IE 8) or Internet Explorer 9 (IE9).

The information in this document applies to the following Enterprise Performance Management products:
  • Calculation Manager
  • Data Relationship Management (DRM)
  • Enterprise Performance Management Architect (EPMA)
  • EPM Workspace
  • Essbase Administration Services (EAS)
  • Financial Data Quality Management (FDM)
  • Financial Management (HFM)
  • Financial Reporting
  • Foundation Services
  • Interactive Reporting
  • Planning
  • Shared Services
  • Web Analysis

Solution

1. Configure browser to check for new version every time user visits a page
  • Open Internet Explorer
  • Go to Tools - Internet options - General
  • In "Browsing history" section click on "Settings" button and then select "Every time I visit the webpage" option
  • Click OK, then Apply.
2. Disable default pop-up blocking
  • Open Internet Explorer
  • Go to Tools - Internet options - Privacy tab
  • Uncheck "Turn on Pop-up Blocker"
3. Add Workspace URL to trusted sites
  • Open Internet Explorer
  • Go to Tools - Internet options - Security tab
  • Select "Trusted sites" from "Select a zone to view or change security settings" window, then click on "Sites" button.
  • Type your workspace URL in form http://workspaceserver:portnumber in "Add this website to the zone"
  • Uncheck "Require server verification (https:) for all sites in this zone"
  • Click Add, then Close.
  • Click OK and Apply.
4. Minimize security setting for trusted sites
  • Open Internet Explorer
  • Go to Tools - Internet options - Security tab
  • Select "Trusted sites" from "Select a zone to view or change security settings" window
  • Select custom level
  • From "Reset to:" list select "Low"
  • Click OK
  • Click Apply, then OK
5. Customize security settings
  • Open Internet Explorer
  • Go to Tools - Internet options - Security Tab
  • Select zone containing your Oracle Hyperion servers and click on "Custom level..." button
  • In "Miscellaneous" section enable options "Access data sources across domains" and "Allow script-initiated windows without size or position constraints"
  • In "ActiveX controls and plug-ins" section enable "Run ActiveX controls and plug-ins" and "Script ActiveX controls marked safe for scripting".
6. Enable option "Always allow session cookies".
  • Open Internet Explorer
  • Go to  Tools - Internet options - Privacy Tab - Advanced. 
  • Check the "Override automatic cookie handling", accept the first and third party cookies and check the "Always allow session cookies" option.
7. Only for SSL enabled environments: Disable option "Do not save Encrypted Pages to Disk".
  • Open Internet Explorer
  • Go to Tools - Internet options - Advanced Tab.
  • In "Security" section uncheck the option "Do not save Encrypted Pages to Disk".
8. Disable option "Enable Native XMLHTTP". This setting is recommended only for customers using HFM 9.3.1 or older with IE 7. If you are using version 11.1.1.x of EPM products or newer, this option should be enabled.
  • Open Internet Explorer
  • Go to Tools - Internet options - Advanced Tab. In "Security" section uncheck the option "Enable Native XMLHTTP".

21 апреля 2012

Браузеры и EPM

Совместимость с браузерами

Enterprise Performance Management Products Compatibility with Internet Explorer ( IE6, IE7, IE8 and IE9) [ID 1355681.1]

Applies to:

Hyperion Financial Management - Version: 9.2.0.0.00 to 11.1.2.1.101 - Release: 9.2 to 11.1
Hyperion Financial Data Quality Management - Version: 9.2.0.0.00 to 11.1.2.1.000   [Release: 9.2 to 11.1]
Hyperion BI+ - Version: 9.2.0.0.00 to 11.1.2.1.000   [Release: 9.2 to 11.1]
Hyperion Performance Scorecard - Version: 9.2.0.0.00 to 11.1.2.1.000   [Release: 9.2 to 11.1]
Hyperion Planning - Version: 9.2.0.0.00 to 11.1.2.1.000   [Release: 9.2 to 11.1]
Information in this document applies to any platform.

Purpose

Current support status for Internet Explorer browser versions used with Enterprise Performance Management (EPM) products. This information applies to the following products:
  • Calculation Manager
  • Data Relationship Management (DRM)
  • Enterprise Performance Management Architect (EPMA)
  • EPM Workspace
  • Essbase Administration Services (EAS)
  • Financial Data Quality Management (FDM)
  • Financial Management (HFM)
  • Financial Reporting
  • Foundation Services
  • Interactive Reporting
  • Planning
  • Web Analysis

Enterprise Performance Management Products Compatibility with Internet Explorer ( IE6, IE7, IE8 and IE9)

* Product Direction Statement - The following information is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle products remains at the sole discretion of Oracle.

Internet Explorer 6 support status for Oracle EPM products

System 9 or EPM  release versionCurrent support statusFuture support status*  (please see Product Direction Statement above)Notes
System 9, version 9.2.xSupported.--
System 9, version 9.3.xSupported. See Notes for additional details for version 9.3.3.-In version 9.3.3 support only for Shared Services, Workspace, Financial
Reporting, Smart View, HFM and Planning.
EPM 11.1.1.xSupported.-Not supported for DRM.
EPM 11.1.2.1Not supported.No support planned.-
EPM 11.1.2.2Not supportedNo support planned-

Internet Explorer 7 support status for Oracle EPM products

System 9 or EPM release versionCurrent support statusFuture support status* (please see Product Direction Statement above)Notes
System 9, version 9.2.xSupported only in version 9.2.0.3 and later.--
System 9, version 9.3.xSupported. See Notes for additional details for version 9.3.0.0 and 9.3.0.2-IE7 is not supported with version 9.3.0.0 and 9.3.0.2.
EPM 11.1.1.xSupported.--
EPM 11.1.2.1Supported.--
EPM 11.1.2.2Supported-Not supported for Arabic.

Internet Explorer 8 support status for Oracle EPM products

System 9 or EPM release versionCurrent support statusFuture support status* (please see Product Direction Statement above)Notes
System 9, version 9.2.xNot supported.No support planned.-
System 9, version 9.3.xSupported in version 9.3.3 and later. See notes for details regarding support in version 9.3.1.x.-IE8 is supported in version 9.3.1.x for:
EPM 11.1.1.xSupported only in version 11.1.1.3 and later. See Notes for details.-In version 11.1.1.3 IE8 is supported for:
  • Calculation Manager
  • DRM
  • EAS
  • EPMA
  • EPM Workspace (with Patch 9314073)
  • ERP Integrator
  • FDM
  • Financial Reporting (with Patch 9657652)
  • HFM (with Patch 9976978 when on Windows 7)
  • Interactive Reporting
  • Planning
  • Shared Services
  • Smart View (with Patch 9779433)
  • Web Analysis
In version 11.1.1.4 IE8 is supported with all products.
EPM 11.1.2.1Supported.--
EPM 11.1.2.2Supported-Not supported for Arabic.

Internet Explorer 9 support status for Oracle EPM products

System 9 or EPM release versionCurrent support statusFuture support status* (please see Product Direction Statement above)Notes
System 9, version 9.2.xNot supported.No support planned.-
System 9, version 9.3.xNot supported.No support planned.-
EPM 11.1.1.xSupported from version 11.1.1.4.--
EPM 11.1.2.1Not supported.--
EPM 11.1.2.2Supported-Not supported on Windows XP Professional SP3.
IE10 is currently not supported with any Oracle EPM products. Any third party software that is not generally available, ie. software available for testing purposes as beta release or developer preview, will not be supported with any Oracle Hyperion  products.

Смотреть также

16 апреля 2012

Списки пользователей в Excel

Как и обещал, начинаю выкладывать некоторые "секреты" подготовки материалов к аудиту моей теперешней промышленной системы (FDM, HFM, Planning 11.1.2.00).
Для начала аудиторы запросили список существующих и удаленных пользователей системы. Используя вот эту подсказу вендора (структура и описание реляционных БД продуктов EPM), накидал 2! вьюхи в СУБД (MS SQL Server), в которых отразил все необходимые данные. К сожалению, FDM/HFM слабо интегрированы с HSS, поэтому вьюх и оказалось две.

Отчет по доступу к подсистеме бюджетирования на базе Planning/Essbase был получен таким образом из БД HSS:

SELECT DISTINCT TOP (100) PERCENT
dbo.CSS_USERS.NAME, dbo.CSS_USERS.FIRSTNAME, dbo.CSS_USERS.LASTNAME, dbo.CSS_USERS.DESCRIPTION, dbo.CSS_USERS.EMAIL, dbo.CSS_USERS.ACCOUNTSTATUS, dbo.CSS_GROUPS.NAME AS HSS_GROUP
FROM dbo.CSS_PROVISIONING_INFO CROSS JOIN
dbo.CSS_GROUP_MEMBERS INNER JOIN
dbo.CSS_GROUPS ON dbo.CSS_GROUP_MEMBERS.LOWER_GROUP_IDENTITY = dbo.CSS_GROUPS.LOWER_IDENTITY_ID INNER JOIN
dbo.CSS_USERS ON dbo.CSS_GROUP_MEMBERS.LOWER_MEMBER_IDENTITY = dbo.CSS_USERS.LOWER_IDENTITY_ID
ORDER BY dbo.CSS_USERS.NAME, HSS_GROUP

Отчет по доступу к подсистеме подготовки МСФО отчетности на базе FDM/HFM был получен из БД HSS + HSV_ProductionHFMAppName_SECCACCESS:
SELECT DISTINCT TOP (100) PERCENT
hyp11hss.dbo.CSS_USERS.NAME, hyp11hss.dbo.CSS_USERS.FIRSTNAME, hyp11hss.dbo.CSS_USERS.LASTNAME, hyp11hss.dbo.CSS_USERS.DESCRIPTION, hyp11hss.dbo.CSS_USERS.EMAIL, hyp11hss.dbo.CSS_USERS.ACCOUNTSTATUS,  dbo.HSV_ProductionHFMAppName_SECCLASSES.Label AS SecClass
FROM dbo.HSV_ProductionHFMAppName_SECCACCESS INNER JOIN
dbo.HSV_ProductionHFMAppName_SECCLASSES ON dbo.HSV_ProductionHFMAppName_SECCACCESS.ItemID = dbo.HSV_ProductionHFMAppName_SECCLASSES.ItemID INNER JOIN
hyp11hss.dbo.CSS_USERS ON dbo.HSV_ProductionHFMAppName_SECCACCESS.UserSID = hyp11hss.dbo.CSS_USERS.LOWER_IDENTITY_ID
ORDER BY hyp11hss.dbo.CSS_USERS.NAME
где hyp11hss - имя БД HSS, HSV_ProductionHFMAppName_SECCLASSES - имя таблицы с классами безопасности FDM/HFM.

Таким образом, подключившись к созданным вьюшкам из Excel, свободно получаем данные для формирования отчетов по безопасности.

Отмечу, что пользователей мы декативируем, а не удаляем, сохраняя таким образом целостность аудита. По полю ACCOUNTSTATUS устанавливаем фильтр: где 1 - активный пользователь; 2 - "мертвая душенка".


12 апреля 2012

Oracle EPM System Release 11.1.2.2.000 is Now Available

What is being announced?

Oracle’s EPM System Development Team is pleased to announce General Availability of Oracle Hyperion Enterprise Performance Management System release 11.1.2.2.

Oracle's performance management applications are a modular suite of integrated applications that integrate with both Oracle and non-Oracle transactional systems. EPM System products form a comprehensive Enterprise Performance Management system that integrates modular suites of financial management applications with the most comprehensive business intelligence capabilities for reporting and analysis.

This is a localized release available in seventeen languages. See System Requirements and Supported Platforms for Oracle Enterprise Performance Management System 11.1.2.2 for details.

In this release, EPM System products extend the new features and products offered with release 11.1.2.1 (See My Oracle Support note 1306738.1 - Oracle Enterprise Performance Management System Release 11.1.2.1.00 is now available). The following is a summary of new features provided with EPM System release 11.1.2.2. For additional details, please visit the product New Features Guides, available in the Enterprise Performance Management System Documentation Library.

Installation and Deployment
EPM System release 11.1.2.2 supports the migration of applications and data from prior releases, 9.3.3, 11.1.1.3, 11.1.1.4. It also supports upgrade of EPM System release 11.1.2.0 and 11.1.2.1 as an application of a maintenance release. Operating System support is extended to include Windows 2008 / Windows 2008 R2. Support is extended to include Microsoft Office 2010. For complete platform support information, please visit System Requirements and Supported Platforms for Oracle Enterprise Performance Management System 11.1.2.2.

ORACLE’S HYPERION® FOUNDATION SERVICES:

Oracle's Hyperion® Shared Services and Lifecycle Management


Oracle’s Hyperion Shared Services-

-Enhancements to default EPM System Administrator Account (admin), ability to rename and deactivate account
-Ability to Add External Users to Multiple Native Directory Groups-EPM System administrators can now add users from configured external user directories to many native groups at once.
-On-demand Cache Refresh

Lifecycle Management-

-Simplified User Interface, Migration Definition File, Migration Status Report
-New Oracle Hyperion Financial Reporting Artifacts – You can now use Lifecycle Management to migrate Oracle Hyperion Financial Reporting Annotations, User POV, and Batch Jobs.
-New Planning Artifact – You can now use Lifecycle Management to migrate Planning Report Scripts.
-Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications Support – ERP Integrator now supports Lifecycle Management.

Oracle Hyperion EPM Architect, Fusion Edition


-Unlimited custom dimensions for Financial Management applications
-Support for a new Oracle Hyperion Profitability and Cost Management application type
-Support for interface data source management from within Performance Management Architect
-SSL-Enabling of Performance Management Architect
-Support for using Data Relationship Management metadata in Performance Management Architect
-The ability to reuse data synchronization filters

ERP Integrator


ERP Integrator has been enhanced to support new source systems:
-Packaged Integrations

Fusion Financials
SAP ERP Financials
JD Edwards Enterprise One
PeopleSoft Commitment Control

-Custom Data Source Integrations

File Based Data Loading
Open Interface Adapter

-ERP Integrator has added Account Reconciliation module (ARM) of Financial Close Manager as a target application.

Hyperion Calculation Manager

-
In this release, the Script Editor includes several enhancements: support for auto suggestion, code completion, line numbers, enhanced code coloring, and performance improvements.
-In previous releases of Financial Management, four custom dimensions were supported. In this release, Financial Management applications can have unlimited custom dimensions. Unlimited Financial Management custom dimensions are supported throughout Calculation Manager wherever dimension information is displayed, including in the Data Range and Metadata Loop components and in the Function and Member selectors.
-This release of Calculation Manager includes bi-directional language support for languages like Arabic and Hebrew that are read from right to left

Oracle Hyperion Smart View for Office, Fusion Edition
-This release of Smart View supports the 64-bit version of Microsoft Office 2010.
-Smart View supports two new extensions and will display their own ribbons in Excel, Oracle Hyperion Strategic Finance and Predictive Planning, which works with Oracle Hyperion Planning

ORACLE ESSBASE:
Oracle Essbase


-For Essbase running on Windows, UNC paths are supported to specify network shared paths
-Block Storage Performance Enhancements
-Optimization of Distinct Count Calculations on Aggregate Storage Databases
-Distinct Way to Reference Shared Members in MDX
-Changing Essbase Server and Application Log Levels in Administration Services
-Essbase API Changes
-Configuration Setting (essbase.cfg) Changes
-New MDX Functions
-MaxL Grammar Changes

Oracle Essbase Administration Services

-
For Essbase and Administration Services running on Windows, UNC paths are supported to specify network shared paths
-Filters listed in dialog boxes in Administration Services are now sorted in alphabetical order.
-One can change Essbase log levels at the server and application level in Administration Services
Console.

Oracle Hyperion Provider Services
-To assist Oracle Hyperion Smart View for Office connection management, Provider Services dynamically detects and retrieves Essbase data sources using the registry
-Essbase Web Services will expose Essbase user and administrative functionality in a services oriented (SOA) environment via Provider Services, and allow Essbase to be easily integrated
with both Oracle and third-party applications.

ORACLE’S HYPERION REPORTING AND ANALYSIS:
Oracle Hyperion Financial Reporting, Fusion Edition


-New Print Engine
-Bi-Direction Support
-Support for Hyperion Financial Management Extended Dimensionality in Financial Reporting
-Support for Hyperion Planning: Ability to attach multiple user notes and multiple documents to a cell in Financial Reporting
-Life Cycle Management support for:
-- Financial Reporting Batch Jobs
-- Financial Reporting User POV's
-- Financial Reporting Annotations
Interactive Report
-File export to Microsoft Excel 2007 using the *.xlsx file format

ORACLE’S HYPERION FINANCIAL PERFORMANCE MANAGEMENT APPLICATIONS:
Oracle Hyperion Planning, Fusion Edition

-Classic application administration is now called Oracle Hyperion Planning application administration
-The Upgrade Wizard automatically upgrades applications having Oracle Hyperion Business Rules business rules, converting them to Calculation Manager business rules.
-Administrators can now set up forms to include a rolling forecast window.
-When Predictive Planning is installed and valid form (not an ad hoc grid) is loaded into Oracle Hyperion Smart View for Office, planners can use the Predict item on the Planning menu or ribbon to predict performance based on historical data.
-To provide greater flexibility in managing a budget's review process, Approvals workflow now supports groups of users.
-various planners with write access permissions to cells can add multiple comments to cells.

Oracle Hyperion Public Sector Planning and Budgeting, Fusion Edition
-Decision Packages and Budget Requests
-Integration with PeopleSoft Financials and Commitment Control

Oracle Project Financial Planning
-Perform planning for Indirect, Capital, and Contract projects
-Perform expense planning at a detail level or account level (labor, material, equipment)
-Allocate workforce resources and capital assets to projects

Oracle Hyperion Financial Management, Fusion Edition
-This release provides the ability to create an application with more than four custom dimensions.
-The Financial Management Application Upgrade utility has been enhanced to support configurable dimensionality by upgrading required documents that are stored in the application database from previous versions to the 11.1.2.2 release.

Oracle Crystal Ball Enterprise Performance Management, Fusion Edition
-One can group assumptions in a sensitivity chart to combine similar assumptions, such as grouping Monthly assumptions into a single Year assumption group
-When fitting distributions for assumptions, one can filter historical data to use only data values that fall within specified value ranges.

Oracle Hyperion Profitability and Cost Management, Fusion Edition
-With this release, in addition to Standard (existing) Profitability and Cost Management, there is now a Detailed Profitability option that offers another method to build your applications. Detailed Profitability enables you to utilize pre-existing relational databases to create a model that contains a single source and destination.

Oracle Hyperion Financial Close Management
Financial Close Management has two modules: Close Manager and Account Reconciliation Manager.

-Close Manager
-Configurable File Upload Limits
-Bulk Reassignments Within Schedules
-Event Monitoring Integration Type
-Account Reconciliation Manager
-Comprehensive tracking of unlimited numbers of reconciliations, including reconciliations of accounts in non-Oracle systems
-Structured formats to guide preparation and ensure high quality reconciliations
-Approval and rejection capabilities with unlimited levels of review
-Dashboard reporting
Oracle Integrated Operational Planning, Fusion Edition

-Paging support for exceptions, cell comments, and data changes
-Ability to execute MDX queries in scenarios
-Ability to approve a subset of data changes
-Metadata security filters
-Ability to search for attributes

ORACLE’S DATA MANAGEMENT:
Oracle Hyperion Data Relationship Management, Fusion Edition
-Oracle Hyperion EPM Architect can import hierarchies, nodes, and properties directly from Oracle Hyperion Data Relationship Management for use by EPM applications.
-Data Creator, Data Manager, and Application Administrator role users can utilize variables to refer to versions in a Data Relationship Management application.
Version variables may be used to dynamically refer to different versions over time or provide an easy method of selecting a version from a large list of versions
-Data Manager role users can archive or migrate data from one Data Relationship Management
application to another using version backup and restore.
-Domains are available to preserve integrity and ensure consistency of node names and descriptive
properties across multiple versions for nodes of a common type.
-You can directly access a hierarchy or local node in the Data Relationship Management Web
Client from an external document or program using a context-senstive URL.

--------------------------------

Источник: Doc ID 1447507.1



Интересные материалы по теме:
Подробности (новые фишки) по каждому продукту
System Requirements and Supported Platforms for Oracle EPM System 11.1.2.x 
Дистрибутивы на e-Delivery
 

06 апреля 2012

MaxL по расписанию

Часто бывает необходимым поставить выполнение MaxL скрпита в расписание. Причем этот скрипт создан в EAS Console и хранится на сервере. Я решил эту задачу созданием batch файла, который ставится в расписание Windows Server:
@echo off
rem - Input parameter is a name of MaxL script (only name w/out extension)
Входящим параметром является имя MaxL скрпита без расширения.
setlocal
cls

Rem Set Variables
SET ESSSETENV=F:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin\setEssbaseEnv.bat
SET SERVER=EssbaseServerNameOrIP
SET USER=Ess_admin_name
SET PASSWORD=Ess_password
Rem See more info about Encyption on https://forums.oracle.com/forums/thread.jspa?threadID=1021677
SET PKE=set_your_Public_Key_for_Encryption
SET PKD=set_your_Private_Key_for_Decryption
SET MaxLPath=F:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eas\storage\mxlscripts\%USER%
SET EADMaxl=%MaxLPath%\%1
Вся информация сохранится в логе, имя файла которого задается переменной EXECLOG.
SET EXECLOG=AutoStartMaxL-%1.log
SET RunMaxl=AutoStartMaxL.mxl
SET CurrDir=%CD%

echo Started: %date% @ %time% > %CurrDir%\%EXECLOG%
Поскольку в консоли вход и подключение производить не нужно, а внешним скриптом - необходимо, добавляем строки входа (login) и завершения работы (logout и exit).
Rem - Generate MaxL Script - Start
echo login '%USER%' '%PASSWORD%' on '%SERVER%'; > %CurrDir%\%RunMaxl%
Сам скрипт считываем из исходного файла на сервере.
Rem - Read original MaxL
For /F "eol=; delims=/" %%i In (%EADMaxl%) Do (
    echo %%i ) >>  %CurrDir%\%RunMaxl%

echo logout; >> %CurrDir%\%RunMaxl%
echo exit; >> %CurrDir%\%RunMaxl%
Rem - Generate MaxL Script - Finish

Rem Set Essbase Env
call %ESSSETENV%
Сам скрипт запускаем в шифрованном виде. 
Rem Encrypt MaxL Script
essmsh -E %CurrDir%\%RunMaxl% %PKE% > nul
Rem Del Original MaxL Script
del %CurrDir%\%RunMaxl% > nul
Rem Run Encrypted MaxL Script with LOG
essmsh -D %CurrDir%\%RunMaxl%s %PKD% >> %CurrDir%\%EXECLOG%

echo ... >>  %CurrDir%\%EXECLOG%
echo Script: >>  %CurrDir%\%EXECLOG%
For /F "eol=; delims=/" %%i In (%CurrDir%\%RunMaxl%s) Do (
    echo %%i ) >>  %CurrDir%\%EXECLOG%
echo ... >>  %CurrDir%\%EXECLOG%

Rem Del Encrypted MaxL Script
del %CurrDir%\%RunMaxl%s >> %CurrDir%\%EXECLOG%

echo Finished: %date% @ %time%  >> %CurrDir%\%EXECLOG%
Добавляем в расписание (Task Scheduler) задачу на выполнение нашего bat-файла с параметром - именем MaxL скрпита.