Wednesday, September 25, 2013

PowerPoint can't read file while exporting Hyperion Fincanical Reprot from Workspace into Powerpoint

Hi,

Recently users were unable to export Hyperion Financial Report from Workspace into Powerpoint. They get below error message.


PowerPoint can't read  "Path\filename.ppt"

Here is the workaround for this issue:

1> Save the .ppt file exported from Workspace.
2> Rename the saved file by changing the extension from .ppt to .mhtml
3> Launch PowerPoint and open the .mhtml file from PowerPoint 
4> Save the file opened in PPT as PPT 97-2003 Presentation
5> The resulting .ppt file can then be opened in PowerPoint .

Hyperion environment : 11.1.1.3

Leave the comments, if this article helps to resolve your issue.

An error occurred - while accessing Planning Dimensions/Application

Hi,

Recently , we faced issue "An error Occurred" while accessing Dimensions under Planning Administration from Workspace. You can similar error when you login to the Planning. This issue comes after planning patch on websphere server.


In Planning log you see error : /LogOn.jsp failed to compile

To resolve this issue, we added below entry in 'ibm-web-ext.xmi' file and recycled the Planning JVM.




FYI, this issue occurred in 11.1.1.3 / SQL srever DB and using Websphere 6.x env.

Location of this file is on Planning server under Websphere path. (you can get the idea of the xmil file path in the planning log file as well)

C:\IBM\WebSphere6\AppServer\profiles\yourservername_node\config\cells\Hyperion_DEV_Cell\applications\Planning.ear\deployments\Planning\HyperionPlanning.war\WEB-INF

Note: If you redeply planning ear file this setting will disappear . you have to add this setting again in the 'xmi' file.

Happy Reading!!!!

Monday, September 23, 2013

How to change Native Admin user for Hyperion


Please find below oracle ID for How to change Native Admin user for Hyperion.

How To Reset Native Admin User's Password for Hyperion Shared Services in version 9.x? (Doc ID 808213.1) - can use Version 9.2.0.0.00 and later

Unable to view PDF Preview in Hyperion Workspace

Hi Readers,

After Hyperion FR patches in 11.1.3 environment , Users are not able to generate PDF files  from Hyperion  Workspace.

User are able to open reports in workspace --> Explore -->XYZ(folder) --> open report.

After opening the report they are doing File --> Open In --> PDF Preview. They are getting blank page in workspace. After investigation I suspect that HR Printers may got corrupted. So I re created those on FR Server and issue is resolved.

Steps to Recreate FR Printers

No need to stop any service while performing below step and there is no impact on existing functionality

Step1
Login to Server FR Server

Delete the existing HRPRinters before creating new ones.

  1. From the Start menu, select  "Printers & Faxes".
  2. Select and delete the HRPrinters.
  3. Right click ‘properties’ à Delete. (do this for all HRPrinters 1-5)
  1. Right-click on any remaining printer on the list, and select Properties.
  2. Select the Ports tab.
  3. In the window, widen the Port column, then scroll down and delete the Hyperion ports.

Delete ports for all HRprinters (1-5)

Step2

Verify the file HRCreatePrinters.ini on below path and verify the StartNum and StopNum Parameters D:\Hyperion\Products\biplus\bin


Step 3

Go to D:\Hyperion\products\biplus\bin

Run HRCreatePrinters.exe

Step 4


Verify the printers in “Printers & Faxes” and verify the port for all the printers (right click à propertiesà ports)

Leave comments..if it helps.

Regards
Guru

HARSnapin Initialize() Error - 2147467259 java.rmi.UnmarshalException

Hi Guys,

Recently  one of the user getting below error message while opening the reports in Hyperion FR studio .

FYI, We have 11.1.3 Hyperion version and recently we deployed lot of patches to make 11.1.3 compatible with Windows 7  .



To resolve above issue, I copied HReports.jar and Foundation.jar from the FR server to the client machine where he is using FR studio to open the reports. (take the backup of existing files before replacing it)

Location on server: D:\Hyperion\products\biplus\lib   
and hope the same location is on the client machine as well.
 

Happy Reading