Predictive Analytics and R-Integration


As of Version 5.1 Jedox introduces powerful new analytics functions for future-focused data, statistical forecasting, and real-time scoring. By integrating the powerful R statistic tools, Jedox allows sophisticated high-performance data analysis across highly volatile and rapidly changing data. This addition provides a whole new class of analytic applications within Jedox. For example, detailed predictive analysis to recognize chances (e.g. click-stream analyses for customer assessment) and minimize risks (e.g. quality assurance).

Jedox combines analytical and classic BI/Performance Management functions in a consistent, unified and intuitive environment.

Predictive Analytics

On any template, you can use “predict” to calculate values from linear regression with one command.

Calculate your sales forecast for the coming year(s) across products, regions, and months, among other dimensions. With the “predict” command, Jedox creates the desired linear regression and projects this forecast in real-time.

R-Integration in Jedox Integrator


  • Write and run any R scripts within Jedox Integrator, based on any input data from any Integrator source
  • Directly write-back data from R analysis paths to the Jedox OLAP server
  • Access the full R-functionality in a user-friendly interface (Excel, Web, and Mobile)
  • Flexibly edit R-analysis results and customize charts that R power users can open and edit in Jedox
  • High performance across very large data volumes with the multi-core Jedox server
  • Highlighting R-syntax in the Integrator editor

Jedox Software integrates R in Jedox Integrator Server to provide a comprehensive library of analytic functions to predict trends and detect patterns in your data. Whatever your industry, R gives you the edge. R is used for credit risk analysis in financial institutions, recommendation engines for online services, statistical demand planning in retail, analyzing economic activity, understanding multi-channel advertising efficacy, investment analysis, weather and housing-price forecasting, time-series modeling, and geospatial analysis.

With a user community of over 2 million, R provides Jedox users with powerful statistic programming. R provides methods and custom data including statistical test methods, time-series and cluster analyses, text mining, and linear or nonlinear modeling. New, high-quality libraries are frequently added by domain experts to expand its capabilities. Tutorials and sample code are readily available, and there is an active user community.

Jedox Software brings the power of R to Jedox users. As a new transform type, your Jedox Integrator manages and controls the data so you can interact with powerful statistical forecasting easily through Excel, Web, and Mobile. By combining R with the Jedox real-time rules-engine and write-back, and copying new scenario versions in seconds, you have powerful modeling and statistical analysis that users can interact with through intuitive visualizations.

Was this post helpful?
NoYes (No Ratings Yet)