When the results tie, the cube reconciliation is finished.HYPERION HFM Online Training by highly skilled industry expert MonsterCourses offers HYPERION HFM Online training by very experienced and skilled Instructor.
Information from the electronic ledger reports is then compared to the results from the cube.
x = HypConnect("Balances", “username", "password", “connectionName").
Range("a28:b28").PasteSpecial (xlPasteValues)Īutomated Reconciliation Process THIS PORTION OF THE CODE PERFORMS THE RETRIEVAL.
Range("a7:b7").PasteSpecial (xlPasteValues).
THIS PORTION OF THE CODE SETS UP THE RETRIEVAL SHEET.
The following Excel sheet shows the control as well as the date parameters (which are formula driven) to be used in the retrievalĪutomated Reconciliation Process The formula used for the years and months is: =TEXT(GLBALRpt!B6,"yyyy") =TEXT(GLBALRpt!B6,"mmm") These parameters are then used to select the applicable month and year for the reconciliation.
The code is attached to a control button in Excel.
Portions of this automation use the Smart View toolkit.
Next step performs the set up and retrievals from the Essbase application.
compared against the data retrieved from the application for the reconciliation process.
Report dates are used for the date parameters (month and year) for the Essbase retrieval.
The next two slides show images of the electronic balancing reports after they have been imported into Excel.
First step of the cube balancing process runs code to export the on-line balancing reports, parse them and import into Excel.
Electronic ledger reports are available on the mainframe for printing/viewing.
Reconcilation process is written in Visual Basic.
Application is reconciled to ledger balances each day.
Last portion of the cycle runs the calculations.
EIS process loads outline and data from DB2.
Batch files to cycle the application are scheduled and are event driven.
Ledger data is loaded to DB2 table each morning around 2am.
AgriBank has 1 general ledger reporting application.
Two applications currently being developed.
Have 4 production applications (1 Planning).
Upgraded to Version 9.3.1 in April, 2009.
Utilize Hyperion Essbase, Planning and EIS (Essbase Integration System).
0 kommentar(er)
