An update to the last post on running ETL via Excel.
We have modified the combo boxes to List boxes for clarity and updated the code. Note that the current release only runs on 5.1 – there are security changes coming in Jedox 6 which will mean the code will have to change in the VBA module.
You can download the excel file here and the vba module (for customising your own files) here.
There has been excitement building around the upcoming Jedox 5.1.With so many new features it could be called Jedox 6. One very powerful addition is the upcoming marriage of Jedox and R.
I’ve seen the enthusiasm among Jedox partners and clients, but what benefits does R bring to the business place of a Jedox user? As a prelude to Chris Mentor’s technical articles on Jedox 5.1 (starting soon), I speak here with Vladislav Malicevic, Head of R&D at Jedox, on what happens when the world’ s most innovative and easy to use BI solution meets probably the world’s most powerful statistical language.
Let’s start by looking at R.
Sam Perrin: What is R?
Vladislav Malicevic: R is a language and environment for statistical computing used for complex predictive analysis. With a community of over 2 million, you find R used from credit risk analysis in financial institutions, to reducing customer churn and optimizing your marketing spend.