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

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

by Jedox 4 BeginnersNo Comments
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
User settings and properties – language

User settings and properties – language

by Jedox 4 BeginnersNo Comments
In this article, we will explain how to change language via User properties and ways to do it. Usually, when creating a user in Jedox there are a few things you need to add in order to create it: All of this information is stored inside the System database and _USER_USER_PROPERTIES cube. Previously we talked about how to remove the panel from the side which uses appstate dimension element here. Today we are going to focus on how to change the language. Different users are coming from different regions and they would like to see their applications in regional languages. Sometimes it can happen that even decimal delimiters are important to them. For example, Germans use commas (,) for decimal delimiters and other dots (.). There are two ways to sort it: From the User Setting Panel. 2. From the Integrator. This method is much better for a large number of users. Before we start creating the ETL it's important to know where this property...
Read More
Setting up default page for groups – 3 ways

Setting up default page for groups – 3 ways

by Jedox 4 BeginnersNo Comments
Setting the default page in Jedox for a specific group is not a big issue if your application contains a smaller number of groups. When a number of groups enlarge, we should look for a more alternative solution instead of checking the boxes one by one. This represents 1st way. Information of the default homepage is stored in the dimension GROUP_PROPERTIES, more specifically in the prefs element. More about the system database could be found here. Once we check this box from picture one, XML code is immediately generated and information on the default page is written. This code could be now pasted in every other cell. In that way, we could significantly decrease the time of checking and as well automate a bit process. This represents 2nd way. 3rd way would be to use this code and copy it via ETL. Import to have in mind is that once a new start page is chosen code needs to be arranged. Also, if the Start...
Read More