1. User's Guide
  2. Migrating Functions
  3. Converting Workbooks

Converting Workbooks

You can convert workbooks that contain Oracle Hyperion Financial Management or Oracle Hyperion Enterprise® functions by using the migration utility.

Data source types: Financial Management, Hyperion Enterprise

You can convert workbooks that contain Financial Management Retrieve Data functions or Hyperion Enterprise HP Retrieve and VBA Retrieve functions. For example, you can convert Financial Management functions such as HFMVal, HFMLnk, HFMLab, HFMDes, and HFMCur and Hyperion Enterprise functions such as HPVal, HPLnk, HPCur, HPHea, HPCde, and HPFul.

The utility might not be able to convert all of your functions. Some functions might require manual adjustment.

For functions that use cell references, the following functions are converted:

  • If every parameter in the function is a cell reference. For example: =HFMVal($B$1&$C$1&$B$2&$C$3&$B$5&$C$5&$B$6&$C$6).

  • If the dimension parameters are specified in the function, the members are cell references, but the period separator is hard coded in the function. For example: =HFMVal("S#"&D2&".Y#"&D3&".VW#"&D5&".')

The following functions that use cell references are not converted:

  • If the dimension parameters are specified in the function and the members and period separator are cell references. For example: =HFMVal("S#"&E2&"Y#"&E3&"VW#"&E5), where E2=Actual, E3=2004, E5="<Scenario View>."

  • If the dimension parameters are specified in the function, the members are cell references, but the period separator is in a separate cell, the function is not converted. For example: =HFMVal("S#"&F2&C1&"Y#"&F3&C1&"VW#&F5&C1), where C1=. (period separator).

  • If the application specified in the function is a cell reference.

  • If any cell in a workbook contains more than 1024 characters, the workbook does not convert properly. To reduce the size of data in cell, reference multiple functions, or remove dimensions that can be set in the background POV.

Before you run the migration utility, ensure that the path is correct (the default path is MIDDLEWARE_HOME\EPMSystem11R1\common\empstatic\wsspace\ ). During migration, Excel inserts the original path of the add-in file to functions. This can make the functions too long and cause errors. Excel limits Oracle Smart View for Office functions to a maximum of 256 characters.