Tuesday, December 6, 2016

Creating Intercompany Matching Reports via Script

One of the features that has been in HFM since almost day 1 is intercompany matching reports. HFM's predecessor, Hyperion Enterprise (which was originally called Hyperion) had intercompany matching reports. Enterprise's predecessor, IMRS MicroControl, a DOS product developed in the 1980s, had intercompany matching reports.

In the beginning of HFM, intercompany matching reports were developed in script (using KEdit or Notepad or other text editor), uploaded, and then you ran it to see if it worked, anything need changing, etc. Later on the graphical interface came along and nowadays no one really sees the script anymore.

But, it is still there.

Where working with script comes in handy is the initial build of the matching reports. Just built 45 matching reports today using script. Here are the steps.

Build one report through the graphical interface like normal and then extract it from the Documents screen.

Open the file in Notepad and copy the script into Excel.

In this screenshot, the script is in column L. Cells L2 and L3 and the last cell (AccountPlug) have been edited to use cell level formulas to point to I1 and I2. Column I is fed from a list in column E and F with all of the plug accounts that need a report.

Paste the script into Excel and save the file. Then move on to the next item in columns E and F. If you have a huge amount, you could write a macro that cycles through the list and writes out the text files.

Last, go into HFM to the Documents screen and load in the script files. Make sure to set the options at the top to the desired folder, document type, and security class before selecting the files.

Having to create the reports via script has gone the way of the green home page, but the utility of working with the script is still there.


No comments:

Post a Comment