Refreshing Rules in Jedox: A Step-by-Step Guide

Refreshing Rules in Jedox: A Step-by-Step Guide

by Jedox 4 BeginnersNo Comments
Hi team, today we will talk about keeping your OLAP (Online Analytical Processing) rules up-to-date in a dynamic environment where data changes frequently. Jedox, a powerful platform for planning, analytics, and reporting, allows users to refresh or update rules easily from the spreadsheet server in case your business rules are set in that way. In this post, we'll dive into how you can use a simple PHP function to refresh rules for a specified database and cube. Why Refresh Rules? In Jedox, rules define how data is calculated within a cube. For instance, you might have rules that calculate 'Price' or 'Units' in a sales-related cube. When underlying data or logic changes, these ones need to be recalculated or refreshed to ensure the accuracy of your reports and dashboards. The Code Explained Here's a look at a simple function that makes the refresh in Jedox: function _Refresh_Click(){ $host = $_JEDOX['OLAP_HOST']; $port = $_JEDOX['OLAP_PORT']; $conn = palo_init($host,...
Read More
Exchange rate Cubes

Exchange rate Cubes

by Jedox 4 BeginnersNo Comments
In this post, we will show you examples of an exchange rate cube, a planning cube, and how to set up the rules between them. This topic is very much present in a lot of projects and therefore we will explain the simple logic behind it. Exchange rate cube For every project exchange rate functionality is probably one of the must-have cubes. The logic behind is simple. We need a place to store rates and the place where we calculate them with the planned data. For keeping rates somewhere we need a cube with at least 2 dimensions: Month or Day Currency It is important to dedicate one reporting currency. In our case the central currency is EUR. All the other currency data will be converted to EUR. Another cube is the place where we plan the data. This cube will contain more dimensions like: Month Version Country Currency Measure In the end connection between these two cubes will be done by a rule: In this rule, we are dividing data that is...
Read More