This blog entry will describe how to start a ETL job from a report. Many of you know this situation, if you want to implement a simple button in a report, which has a function to start an ETL job. So you can start ETL jobs from the report manager. There are many ways how to solve this problem and
Month ends are like haircuts. Towards the end of the process, there are a lot of little snips and clips. Enter month-end adjusting journal into ERP, run Jedox Integrator, rinse, repeat. The adjustments can go on for a long time, so an easy way to process them is critical. Having a custom Jedox web page to run jobs helps, but
hmmm….. not that type of macro… In macros, the Worksheets object allows you to manipulate individual worksheets inside a workbook. This can be advantageous when you are doing things like running a macro to prepare a management briefing book which might be spun out via a customised batch printing process to Excel. You can take existing sheets and add new,
Jedox Web variables are session based, in-memory objects which allow users to transfer values between and around reports. Variables allow you to do things like: Set a default value on a report Transfer selected filter values from one report to another Pass user selected parameters to a relational Dynarange Setting a Variable value 3 Ways 1. Directly on the spreadsheet.
OK. So you know have got the hang of writing a bit of php code and you can now refer and transfer data around your spreadsheet with ease. However, there is a problem here. The issue with referring to cells in Jedox Web is the same issue you get with referring to cells on a spreadsheet – a cell reference
The Jedox Macro Engine implements PHP to interact with the Jedox Spreadsheet. One of the most used and basic functions is referring to a cell reference in the PHP code. You can put data into a cell on the spreadsheet, or you can read from that cell. Download the example spreadsheet here Reading Cells [crayon-5a8ff92c5f34f800485310/] Writing Cells [crayon-5a8ff92c5f354063623035/] Note, the