In the second post in our blog series on the new Jedox 2020.3, we introduce the all new Jedox OData Hub, which makes queries faster and enhances the data basis for Power BI analyses. Get more highlights of Jedox 2020.3 in our release blog series.

With version 2020.3, Jedox is releasing OData Hub, a new data service that makes it even easier to query, prepare and utilize Jedox data for analysis and visualizations in Power BI. This means finance and BI teams can discover and share new insights even faster based on latest forecast data along with budgets and targets.

The native access to financial planning and analysis (FP&A) data broadens the foundation for analytics in Power BI. By integrating financial planning and operational planning across business functions, companies promote the organizational alignment based on strategic, financial and operational goals.

Users across the organization benefit from integrated planning and BI

A tighter integration of enterprise planning and business intelligence allows report builders and analysts to easily include formatted Jedox financial reports in their Power BI apps or create new analytics and visualizations using Jedox financial planning data. It also means decision makers in all functions can see the bigger picture and run integrated scenarios of financial and business impacts thanks to the enhanced data foundation. Finally, users can also submit their budgets and forecast directly in Power BI supported by intuitive planning tools that help create their plans faster and more effectively, capture comments and follow harmonized workflows.

Key features of the Jedox for Power BI package:

  • Native access to Jedox data in Power BI Desktop for query, data preparation and analysis
  • Instant refresh of Jedox data in Power BI visualizations and dashboards
  • Write-back of values and comments to Jedox from the Power BI interface
  • Include Jedox formatted views and reports in Power BI dashboards and apps
  • Jedox planning workflows can be triggered from within Power BI
  • Single-Sign on for Jedox and Power BI with Azure Active Directory

Query Jedox data in third-party systems with ease

The Jedox for Power BI package now also includes the new Jedox OData Hub. As a cloud-based service it makes Jedox data available for consumption by 3rd-party systems based on the OData Protocol standard. Jedox OData Hub allows querying Jedox planning, budgeting and forecasting data natively from a number of enterprise applications including Microsoft Power BI and Power Query (Excel), Qlik, Tableau and others.

Get the full technical details about Microsoft Power BI connectivity and the new OData Hub in the Jedox Knowledgebase.