Why I created a blog

Its been four years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.

Wednesday, December 21, 2011

Smart View Patch to a patch

In September, Smart View patch was released which gave us parity with the Excel Add-in. While it is great, I was informed by a colleague that there is a newer version of the patch available. I checked on Oracle support and sure enough, there is now available. It is only for Smart View, there don’t appear to be equivalent patches for Essbase, APS or any other  products. Below are the fixes in this patch. If you go to the support site and look up the patch, there are also known issues that are worth looking at. 

• 6928106

General: Smart View cannot display member names and their aliases at the same time.

• 12828079

General: When Smart View is enabled in PowerPoint, images are displayed as blanks during Slide Shows.

• 12858015

General: When you perform web launch from Financial Reporting with a report that has multiple members in the POV, the POV selection is lost in Smart View.


General: If Smart View is located in a different directory from that specified in the server, Excel may terminate abruptly with this runtime error: "Microsoft Visual C++ Runtime Library…"

• 12957863

General: When you to open or save a Smart View Excel file, you may get this message: "Microsoft Office Excel experienced a serious problem with the 'oracle hyperion smart view for office, fusion edition' add-in. If you have seen this message multiple times, you should disable this add-in and check to see if an update is available. Do you want to disable this add-in?"

• 11779755

Essbase: When you change the POV, you may get this error: “Invalid start location.”

• 12918727

Essbase: If you are connected to a non-unique Essbase outline from a multiple-grid worksheet, you may get this error: "Invalid spread sheet data. An application protocol error might exist between server and client processes."

• 13242869

Essbase: When the Use Excel Formatting option is selected, cells that contain formulas may display the formulas rather than data after you refresh. In addition, cell formatting may change from general to text.


Planning: In the Smart View Panel, Planning folders and forms are not displayed the same order that they are in Planning. Instead, they are displayed in alphabetical order.


Planning: In ad hoc grids, cross-worksheet references in formulas do not work; the formula itself is displayed in the cell rather than the contents of the cell referenced.

• 12908185

Planning: When you search for members using the drop-down menus in the Page section of a Planning data form, Smart View may take an inordinate amount of time to return the members.

• 13001747

Planning: When you try to open Smart View from within Planning, you receive a Microsoft Excel error.

• 13253314

Planning: If the first worksheet of a composite form contains a formula, you cannot submit data from the other worksheets in the composite form.

• 13403509

Planning: After refreshing, column widths are reset even if Adjust Column Width is selected.

• 13419370

Planning: The "The form contains unsaved data." warning mesage is not displayed when you refresh a composite form.

• 13255112

Financial Management: Excel files in which Smart View is enabled may take a long time to open.

• 13401856

Financial Management: If "Member Name and Description" is selected as a member name display option, Smart View only displays only the description.

• 12559490

Reporting and Analysis: When you attempt to export a Financial Reporting query-ready report to Smart View, you get an error.


Reporting and Analysis: When you import a functional grid from Financial Reporting into Smart View, the formatting may be lost.

• 13093388

Reporting and Analysis: After you upgrade to Smart View, Excel may not launch.

• 13365904

Reporting and Analysis: After you upgrade to Smart View, Excel may terminate abruptly.