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).
Hyperion Smart View Toolkit Automating Daily Processes with Smart View Toolkit Functions
0 kommentar(er)
