How to hide System database to users

How to hide System database to users

System database is vital part of Jedox modeler. It contains all information of users, groups, roles and their interactions in cubes. By default, it is visible by every user with modeler rights. In some environments admin user do not want to make this database visible. In _GROUP_DATABASE_DATA cube is not possible to choose System database, since this cube is in fact in this database and therefor not possible to put N on the group. Workaround will be to play with the Roles for a bit. Usecase is that user should see Modeler, some Databases inside, but not the System. That we can achieve by doing this rule rights: Modeler is Full Access or Read and Rights is no access. Now, when our role is active and updated we should see modeler like this: ...
Read More
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
A session token is missing from the request

A session token is missing from the request

This bug appears when we are trying to upload a cube or dimension from the modeler. To learn more about that you can check here. The error usually looks something like this: One of the possible reasons why this happens could be the size of the file. If the file size is bigger than stated in the configuration file then an error could occur. Definitely, this is not the best error message but I am sure the Jedox Dev team will change this. So, to fix this you will need to change upload_max_filesize to the size you need. After that, a restart of services is required. In case you are on cloud ---> Just write to support@jedox.com and they will do it for you. In case you are on-premise --->, you will need to go to Jedox/Jedox Suite/httpd/php/php.ini and find the line upload_max_filesize. Then restart the services. ...
Read More
How to sort attributes?

How to sort attributes?

In this article, we will show you how to sort attributes in the way you like. When building dimensions in Jedox it could happen that some of them require a huge number of them. The modeler screen in normal zooming conditions can fit around 10 attributes. For all the rest we will need to use a scroller. If you are someone who works with Jedox for a few years you will notice that adding attributes on the end of the page when scrolling could be annoying. Especially because after adding any attribute manually, the page refresh and bring you back to starting position. We can resolve it by pushing the last attribute at the beginning. There are two ways to do it: Create attribute directly on desired position Moving attribute around in #_MONTH_ cube For the second case, arrows, in the end, will be blocked, so the best way is to drag and drop elements around. Maybe at first sight useless tip, sorting manually really...
Read More
Error while restoring the database

Error while restoring the database

When having two servers that are running on different versions, it could happen that restoring the database backup from a newer one to an older one can lead to an error. In our case, it appeared when trying to restore the database in Modeller from 2021.4 to 2021.2. If you are not familiar with how to restore the database from one server to another without including support, the article can be found here. The process is simple: Log in on your server from where you want to take the database Go to desired database in Modeler Right Click on it and choose Download Database... Go to second server where you want to perform restoring the database activity Right click on it and choose Restore Database... IF the scenario is smooth you are ready to celebrate, but in case it's not (like below) CODE: M_DB3 - zip operation failed : not a valid backup file,subfolders found Perform the following steps: Unzip the database Find folder checksum and remove it Zip it again Try to perform...
Read More