Subsets, Lists and Virtual Dimensions in Jedox

Subsets, Lists and Virtual Dimensions in Jedox

by Jedox 4 BeginnersNo Comments
In the realm of Jedox, manoeuvring through different data structures such as subsets, virtual dimensions, and lists can feel like finding your way through a maze. Each of these possibilities has its unique function, and knowing how and when to utilize them can greatly improve your Jedox usage. This guide will explore subsets, virtual dimensions, and lists in-depth, covering their uses, benefits, drawbacks, and the optimal situations for integrating them into your Jedox endeavours. Subsets Subsets in Jedox act as filtered views of dimensions, allowing users to focus on specific elements within a dimension. They are useful for simplifying data analysis and report generation by narrowing the scope of data to relevant subsets. They can be static or dynamic, meaning they can either have fixed elements or dynamically adjust based on specified criteria. Within Jedox subsets, users can filter elements by including or excluding specific ones, applying dynamic criteria like numerical, text, or date ranges, leveraging hierarchical relationships to select entire branches...
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
Version blending

Version blending

by Jedox 4 BeginnersNo Comments
Version blending is functionality that brings actual figures to be visible in the forecast versions. Each forecast element in the Version dimension can be configured in the Actual Months attribute to contain actual figures for the first given number of months, starting with January. Here we could see that versions have 3,6,9 months of actual data for corresponding forecast versions. This can be achieved if in the version dimension we add the attribute Actual Month. [is already there if you use Version template dimension when creating]. After that rule needs to be set on the cube level. Here is a good description of this feature in Jedox Knowledge Base. Also, you can download the mini-project of version blending from here. ...
Read More
Audit in Jedox

Audit in Jedox

by Jedox 4 BeginnersNo Comments
When the cycle of planning starts it is important to track all inputs. One reason is for monitoring purposes [Who did when what and why] and the second is to keep the log of how data looked before that step. For that purpose, we will use Audit functionality. This functionality can be found in the Administration tab: By default, an audit is not started until the user enables it in Settings Panel. Auditing can be done for 1,7,30 or 365 days. Have in mind that a larger auditing period is selected, the file on your server will take more memory. Once you select the cube which should be monitored, add some value inside. In our case, we will add 400 Units for Handlebars inside Orders Cube which we previously enabled in Audit. After hitting that splash functionality new value is visible in the Audit section. Now, you can check why the values are appearing in the report since everybody claims it was not their...
Read More
Locked Dimensions and Cubes

Locked Dimensions and Cubes

by Jedox 4 Beginners2 Comments
Technically speaking this is not a bug but a feature of Jedox software. Jedox has the possibility to lock a specific area of the cube in order to disable additional data entering. The majority of the time users click on this functionality by accident and then owners of the application break the head what went wrong. When the cube is locked, elements cannot be added or deleted. Etls cannot run import as well. The error usually displays the following message "M_EL1 - dimension is locked: dimension is used in a locked cube" One reason for the error could be the Hold functionality is triggered by the user as follows: A similar thing is with Enable Undo functionality as well. Both of this information could be found in modeler under Cube properties. Once both of the actions are released, an error will not appear anymore. After that users could continue adding the data or working on the architecture of the database. In case you try...
Read More
Slowly Changing Dimensions

Slowly Changing Dimensions

by Jedox 4 Beginners Comment Closed
Slowly Changing Dimensions are a recurring topic in Business Intelligence and Data Warehousing in general. Theterm describes the unpredictable change of dimensions over the life-cycle of a data model and the approachesused to capture and document historical data for future reference. Before: After: There are 4 ways to deal with them: Dimension Update Parallel Hierarchies Split information over different dimensions Attribute/Control Cube Dimension Update (Slowly Changing Dimensions) The first approach is the so-called “Update” approach. As the word “Update” suggests, this approach removes theold structure and replaces it with the new one. This approach has proven to be efficient, in the case when no historicalcomparison is required. The latest structural changes should simply be displayed in the respective dimension. Parallel Hierarchies (Slowly Changing Dimensions) An approach to preserve historical structures and information is to create so-called “parallel hierarchies”. Herebythe new structure is created under a new consolidated element in the respective dimension.Attention should be paid to how many parallel hierarchies are being set up as this method can quickly “clog” thedimensions...
Read More
How to create a model in Jedox?

How to create a model in Jedox?

by Jedox 4 BeginnersNo Comments
Jedox introduced the possibility to create a model from 2017. Many predefined models could be also downloaded from the Marketplace. Here we are going to show how to create one. "Models are predefined applications, consisting of files/reports, OLAP databases, Integrator jobs, scheduled tasks, and settings." That saying, models are logical unities that allow users to differentiate between applications. When the model is created following folders are predefined in Jedox: Integrator area folder Report Designer folder Reports folder The database could be created on its own. Below you can see how Jedox academy explains installation. In order to create a model, we need first to check our license. It is important that your license allows creating modes. Usually, you could see it in Administrations -> Licences - >Jedox Model Developer. In case you don't have it, then Create New model would not be visible]. If in case you have the license this is the place to start. Model Settings The name needs to contain the prefix com.jedox without any capital or irregular characters. More...
Read More