Jedox platform release 2022.3 introduces new visualizations and planning assistance

The Jedox platform 2022.3 release makes the “big” and “little” things easier for you to report business progress, run routine tasks, and adapt models to your current market dynamics. From new visualizations to security enhancements, to planning assistance that helps you avoid making costly mistakes, the new release increases your teams’ efficiency in operating the business.

You can now improve reporting by including “waterfall” charts, popular with both management and investors as they are able to quickly see how the business, or a project, is doing. Additionally, model developers can define simple and specific values to retrieve attributes to present related cells in list views within models. Further simplifying the lives of Jedox users, new planning assistance helps identify the implications of actions prior to changing a cell value that would result in unintended consequences. Lastly, it’s now much easier to plan and configure secure virtual private network (VPN) connections for users accessing sensitive business data across the globe.

How the Jedox planning and performance platform 2022.3 release simplifies reporting and operations

Builders of Jedox models and reports can now better illuminate insights and drive a culture of decisiveness for their organizations. Enhancements to this release enable users to:

• Create interactive management reporting and dashboards using horizontal or vertical waterfall charts.
  Include waterfall charts to visualize the cumulative effect of positive and negative changes. These are commonly used in financial analysis to display how a net value is arrived at through time with gains and losses, or between actual and budgeted amounts.
• Generate simplified expressions that make it possible to get an attribute value within a list definition using straightforward logic. For example, you can use an attribute value in a list to refer to a previous year to show actuals from the previous year compared with the forecasted period (e.g. – ${“Month”|”PreviousYear”}).
• Save number and language formats based on local preference. If you want English language settings and “1,000” to signify one thousand for your planners in the Nordics, no problem.
• Benefit from quicker, more straightforward modeling:
  • Jedox will smartly remember your last selected cube, reducing the time spent getting back to where you were.
  • Jedox Integrator now has better performance for Extract, Transform and Load (ETL) jobs that involve many calls to OAuth token data connections.
  • Using the planning assistant, Jedox will inform you before doing something that causes an unwanted explosion of data. For instance, Jedox will now provide additional context before “splashing” the number of cells in the model that are affected. You won’t try to update 33 million cells by accident.
  • VPN access can be configured through a self-service console to control access to company data.

Waterfall chart

Example of 2022.3 in action: reviewing a product line’s profitability and preparing for next year’s inflationary pressures

Imagine, as part of your integrated business planning process, you need to review one of your product line’s profitability.

Just off the plane in Perth, Australia, and you log into the network at a new facility that your organization has just opened. Thankfully, the IT department independently adjusted your organization’s VPN settings, allowing you to connect to Jedox data in this new location.

You launch the Jedox management dashboard and immediately see a waterfall chart that shows up-to-date net income generated by the product line you need to evaluate.

You spot a change in the cost of goods sold (COGS) and assume it is due to recent inflationary pressures on some of the packaging materials you use. You think this trend may continue into the next year.

You call the person who builds your model in the Riga office in Latvia and ask them to forecast the next year based on last year’s and this year’s actuals. Luckily, she was able to pick up right where they left off because the Jedox platform remembered where they last stopped working on the model. And, because of the improved method for referencing attributes, she is able to update what you are looking at in less than 15 minutes, including new tables and charts that include last year, the current year and forecasted COGS.

You are now prepared to discuss the impact of these trends with the rest of your management team later that day.

The 2022.3 release of the Jedox platform continues our commitment to delivering incremental value with every release of our solutions. If you want to see how Jedox can drive a culture of decisiveness in your organization, and empower you to realize a vision for financial and digital transformation, please request a demo today.