08 июля 2009

Куда пойти учиться...

Открылся новый авторизованный по продуктам Oracle Hyperion учебный центр Sitronics IT. Если вам необходимо качественное обучение специалистов продуктам Oracle Hyperion, то это, наверно, лучший выбор.

P.S. Рекомендую потому что в свое время учился у Ларионова Дениса.

07 июля 2009

BI Beer 2009

Итак, 16 июля пройдет замечательное мероприятие под названием BI Пиво 2009. Организует Его компания Oracle, но в отличие от большинства ее конференций и семинаров, тут вам не будут ничего продавать, тут просто соберутся люди, профессионалы в области BI для того чтобы в неформальной обстановке попить пивка, пообщаться на профессиональные и не очень темы. Но формальная часть таки будет - будет несколько докладов от, в основном, неоракловых специалистов, которые поделятся своими впечатлениями и пожеланями по поводу аналитических инструментов Oracle.

Более подробно читайте в блоге у Андрея Пивоварова.

*Если получится, то я может даже выступлю там*

P.S. Регистрация тут

17 июня 2009

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.

22 мая 2009

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.

27 апреля 2009

Как установить Oracle (Hyperion) Essbase.

На прошлой неделе опыт по установке Oracle Essbase проделал Андрей Пивоваров о чем и написал в своем блоге.

Ценность статьи в том, что писал ее человек, котрый
а) умеет все доходчиво объяснять
б) не знаком с essbase и он смотрел на этот процесс также, как смотрят большинство новичков.

Так что очень рекомендую прочитать статью тем, кто начинает знакомство с Essbase или Hyperion Planning (так как Essbase основная часть этого продукта).

03 апреля 2009

Где можно пообщаться...

Формат блогов не особенно подходит для обсуждения и я давно хотел создать какой-нибудь форум.

На форуме по бизнес-аналитике я встретил человека, который уже это сделал. Прошу любить и жаловать: hyperion.su.

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

Первая официально локализованная версия Oracle Enterprise Performance Management

Ура, дождались!!
На E-Delivery появился Oracle Enterprise Performance Management 11.1.1.2.0. Обещали локализацию. Надеюсь, не обманули.

UPD: Если вам лень качать все это добро, то можете подъехать ко мне в офис на Октябрьской и я вам солью все, что пожелаете кроме OAS.

13 февраля 2009

Форум Oracle по бизнес-аналитике

19 февраля 2009г. в гостинице Марриотт Гранд Отель, ул. Тверская, 26/1 состоится Форум Oracle по бизнес-аналитике.

Событие больше маркетинговое, чем техническое. но тем не менее там будет несколько интересных докладов и, что самое главное, будет возможность пообщаться с людьми, которые занимаются оракловым (и не только) BI в России.

Программа семинара:
09.30 – 10.00 Регистрация

10.00 – 10.30 «От оптимизации бизнес-процессов к совершенству в управлении»
Дженк Кирал, Старший директор по направлению Oracle BI/EPM решений в регионе EE & CIS

10.30 – 11.00 «Технологии и продукты Oracle для решения аналитических задач»
Ольга Горчинская, Oracle СНГ

11.00 – 11.30 «Аналитические приложения Oracle – обзор и демонстрация возможностей»
Наталья Зубенко, Oracle СНГ

11.30 – 11.50 Перерыв

11.50 – 12.20 «Oracle Exadata – новые возможности для хранилищ данных»
Андрей Пивоваров, Oracle СНГ
Максим Андреев, заместитель директора ДИТ, руководитель направления бизнес-приложений компании КРОК

12.20 – 12.50 «Опыт успешного использования технологий Oracle в реальных проектах»
Выступление партнера (IBS Borlas)

12.50 – 13.30 «Пространственные данные в аналитических системах»
Александр Рындин, Oracle СНГ

13.30 – 14.00 «Опыт успешного использования технологий Oracle в реальных проектах»
Выступление партнера (ФОРС)

14.00 – 15.00 Обед

15.00 – 15.30 «Oracle RTD (Real Time Decision)»,
Али Риза Куюджи, Директор по технологическому консалтингу BI&EPM, Oracle

15.30 – 16.00 «Многомерный анализ данных на основе Hyperion Essbase»
Ольга Горчинская, Oracle СНГ

16.00 – 16.30 «Анализ больших объемов данных на базе Hyperion Essbase. Опыт Спортмастер и КРОК»
Алексей Тюренков, руководитель группы разработки DataWarehouse, компания КРОК
Кудрявцев Юрий, менеджер по внедрению бизнес-приложений компания КРОК

16.30 – 17.00 Перерыв

17.00 – 17.30 «Опыт успешного использования технологий Oracle в реальных проектах»
Выступление партнера. (TOPS BI)

P.S. Но я все-равно с нетерпением жду BI Beer'а. Надеюсь, он в этом году снова повторится.