Download K14-Using HFM Process Management to Drive HFM Extracts PDF

TitleK14-Using HFM Process Management to Drive HFM Extracts
TagsComputer File Microsoft Excel Application Programming Interface Visual Basic For Applications Zip (File Format)
File Size2.9 MB
Total Pages60
Document Text Contents
Page 1

A New Twist to HFMA New Twist to HFM
AutomationAutomation

Using HFM Process ManagementUsing HFM Process Managementto Drive HFM Extractsto Drive HFM Extracts

Alice Lawrence – Walmart

Samrat Chakraborty – Deloitte

Page 2

 27 Countries

 Multiple currencies

 Sub Consolidations within some countries

 HFM only used for Actuals

 Essbase used for Management Reporting

HFM Implementation is complexHFM Implementation is complex

Page 30

• Challenge was to determine if the process status was one we

wanted to extract

• Ensure that we had not already extracted data based on that
process status

• Use excel to store the last process status retrieved from HFM

• Use excel formulas to compare old vs new

Determining what to extractDetermining what to extract

Page 31

Excel Formula handles comparisonExcel Formula handles comparison

Formula

in column

F

compares

New

Status vs

Old

Status

and

checks if

the new

Status is

one we

want to

extract

Page 59

Private Declare Function HypMenuVRefresh Lib "HsAddin" () As Long

Private Declare Function HypSetOption Lib "HsAddin" (ByVal vtItem As

Variant, ByVal vtOption As Variant, ByVal vtSheetName As Variant) As

Long

Private Declare Function HypConnectionExists Lib "HsAddin.dll" (ByVal

vtConnectionName As Variant) As Variant

Private Declare Function HypDisconnect Lib "HsAddin" (ByVal vSheetName

As Variant, ByVal vLogoutUser As Boolean) As Long

Functions to declare…contd.Functions to declare…contd.

Page 60

Private Declare Function GetCurrentProcessId Lib "kernel32" () As Long

Private Declare Function OpenProcess Lib "kernel32" (ByVal

dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal

dwProcessId As Long) As Long

Private Declare Function TerminateProcess Lib "kernel32" (ByVal hProcess

As Long, ByVal uExitCode As Long) As Long

Private Declare Function HypExecuteMenu Lib "HsAddin.dll" (ByVal

vtSheetName As Variant, ByVal vtMenuName As Variant) As Long

Private Declare Function HypRemoveConnection Lib "HsAddin.dll" (ByVal

vtFriendlyName As Variant) As Long

Functions to declare…contd.Functions to declare…contd.

Similer Documents