Показаны сообщения с ярлыком Smart View. Показать все сообщения
Показаны сообщения с ярлыком Smart View. Показать все сообщения

23 мая 2013

Анонсы webcast'ов


На MOS доступен набор анонсов и архивных записей с webcast'ов по EPM:

Financial Reporting Reports troubleshooting

Начало: 22 мая 2013 в 19:00 (Moscow; GMT+04:00)
Регистрация: https://oracleaw.webex.com/oracleaw/onstage/g.php?d=593146224&t=a

Preparing EPM 11.1.2.3 in an Linux VirtualBox Environment

Начало: 26 июня 2013 в 18:00 или 27 июня 2013 в 6:00 (Moscow; GMT+04:00)
Регистрация: https://oracleaw.webex.com/oracleaw/onstage/g.php?d=592357520&t=a

Архивы

Доступны записи и презентации с комментариями в PDF

2013

  • EPM Log Hide and Seek (with generic Oracle tools)
  • EPM Log Hide and Seek (with Hyperion tools)
  • Migrating Business Rules to Calc Manager

2012

  • Integrating DRM with Oracle General Ledger and EPM Applications
  • New Features and Improvements in HFM and Calculation Manager 11.1.2.2.300
  • Just in Time Diagnostic Dumps for EPM 11.1.2.x
  • Catch the Pulse of EPM 11.1.2.x in Enterprise Manager
  • Mapped Reporting Applications (MRA)
  • Troubleshooting EPM Reporting & Analysis 11.1.2.x
  • Planning Performance Pitfalls
  • Improving the Performance of HFM

2011

  • Remote Diagnostic Agent (RDA) Use with EPM/BI Applications - US; EMEA/APAC
  • User Productivity Kit 11
  • How to Resolve your EPM and BI Technical Issues Faster
  • Smart View Release 11.1.2.1.102 for Oracle Hyperion Essbase

24 сентября 2012

SmartView 11.1.2.2.300

Доступна новая версия клиента SmartView 11.1.2.2.300 для win32 и win64 (патч на MOS: 14362638).
Новая фича In-Cell Point of View в действии









По мотивам: essbase.ru

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), чтобы изменения вступили в силу.

24 июля 2009

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.