26 07, 2016

How to Start an ETL Job From a Report

By | 2017-03-30T11:15:02+00:00 July 26th, 2016|How To|

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

2 03, 2015

ETL from Excel

By | 2016-12-09T11:42:56+00:00 March 2nd, 2015|How To|

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

28 03, 2014

Macros : Manipulating Worksheets

By | 2016-12-09T11:43:26+00:00 March 28th, 2014|How To|

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,

19 11, 2013

Macros: Variables

By | 2016-12-09T11:43:39+00:00 November 19th, 2013|How To|

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.

15 11, 2013

Macros: Named Ranges

By | 2016-12-09T11:43:43+00:00 November 15th, 2013|Data Modeling|

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

15 11, 2013

Macros: Cell References

By | 2016-12-09T11:43:44+00:00 November 15th, 2013|Data Modeling|

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-5a2a8f65626bd727603995/] Writing Cells [crayon-5a2a8f65626c2471444225/] Note, the

Load More Posts