Code: 1 – element not found : unspecified default write element in the dimension

Code: 1 – element not found : unspecified default write element in the dimension

In this article, we will explain what the following error message means and how to deal with it: Code: 1 - element not found : unspecified default write element in dimension This error appears when the user wants to extend his cube with an additional dimension. The problem is that system doesn't know to which element to assign already existing data. If the dimension which needs to be added has more than 1 element that is where the confusion starts. In the below example, we will show how to deal with it. Like always we will use the Demo database: Dimension country is the one which should be added and extend Sales cube. As stated in the error message, there is a necessity to proclaim one default write element so all the data is assigned to it. We can do it here: In the picture above we assigned the element Europe as the Default Write Element. After this action, saving the changed layout of the...
Read More
Create a calendar in Jedox

Create a calendar in Jedox

In this article, we will show you how to create a calendar widget inside Jedox. For this task, we will need a Day dimension filled with additional attributes NextDay. Idea is to create a calendar that can be extended with additional dimensions and serve as a data planning area. Possible use cases could be task planning, reminders, planning cycles availability, etc. Everything is built on a spreadsheet without any coding knowledge. We could say that Excel familiarity is sufficient. Creating Time dimension For this task, we will use simple dimension creating where Dimension Template will be Day. That dimension we will extend with an additional attribute called NextDay which is generated by ETL. NextDay will represent Date +1. The transformation function used is Previous. Example: [2022-05-02-----> 2022-05-03] Calendar Creation Once we have all the necessary elements we can start building up the template in a spreadsheet. The template will be mixed with excel formulas and conditional formattings. Selected month dates cells will be colored in white and...
Read More