Upgrading to the 2022.2 version brings more perks and features. One of these is also the IOUtils.setByteArrayMaxOverride() issue. Usually, it comes in this type of form and states that the maximum length for this record type is achieved.
The fix is very simple. If you have access to the config file it is necessary to add this line:
Afterward, you just need to restart the ETL service and you are ready to go.
In case you don't have access, please write to Jedox Cloud Support....
In my numerous Jedox projects career, I was constantly getting questions related to cube load modes. Although is very well explained in the knowledge base, users frequently asked for clarification. When is a great moment for the update, where for add, and where for delete + insert combination?
It is important to start with the type of load modes for the cube:
Add - Values from the data source are aggregated and added to the existing values in the cube.
Insert - Existing values in the cube are overwritten with the values from the data source.
Create - The existing cube is deleted and created anew with the dimension order as defined in the source.
Delete- Values from the data source are deleted in the cube.
Update - The existing cube is emptied; values from the data source are aggregated and written to the cube.
How it practically looks is something which is in the best way explained in the below EXCEL screenshot:
Based on this image you...
Jedox is fastly growing software and with every new version many cool features are released. That brings a bigger market and eventually more customers. Recently many projects are done for big corporations which handle a large number of users. In order to manage and control all of these users and licenses customers frequently ask for some type of report where all this information is displayed.
In the below picture, you can see a list of all users split by activity or in other words, are they allowed to use the system or not.
As you can see there are possibilities to assign or unassign the license, activate or deactivate the user, and search for them in case the list becomes super long. Speaking of super, take a look at the newest super planning program by Jedox.
It is worth mentioning that license assignments can be found in the System database under the _USER_USER_PROPERTIES. More about system cubes can be found on the following...
In a Jedox, a hyperlink (or link) is an item like a word or button that points to another location. When you click on a link, the link will take you to the target of the link, which may be another report, excel document, or other online content. There are two possibilities to create a hyperlink in Hedox:
Searching the hyperlink in functions
Clicking on the right click and selecting the hyperlink icon
Hyperlink function
The syntax for the function is HYPERLINK(link_location, friendly_name, screen_tip, source1, destination1[, source2, destination2, …]).
link_location - > here we can define where will our link takes us to. It can be on the same page "#SELF", different sheet "[SELF]Sheet2!A1", a particular report "//Demo Spreadsheets/Demos/Bikers Best/Navigation/Bikers Best Navigation" or a web page like "https://jedox4beginners.com/".
friendly_name - > How will link the world to the outside world <Link Friendly Name>
Tool_tip -> What is visible when covering the link? In case you don't want to see any addresses or strings just...
In this article we will show you how to pull the report will all your users and their creation and last login time. This could be useful in case you are wondering which of your users actually use Jedox and utilize the "Free seat" license. In case you are interested more in how licensing in Jedox works you can check it out here.
As we learned in some of the previous articles details about Users can be found in the System database and _USER_USER_PROPERTIES cube. SO therefore we will paste a view with this information:
As you can see both data values are stored in Serial number time of date. Example:
=DATEVALUE("01-02-2015") returns Unix time stamp 1420156800, which represents 02-Jan-2015 (=60*60*24*16437 seconds since 1.1.1970).
Obviously, we will need to convert these values into something more readable. There are two ways to do it:
Convert from UNIX to normal date using excel formula =(A1/86400)+DATE(1970,1,1)
Option to convert the value with Rule. For this option, I suggest...
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...
Palo.ini is a configuration file where superusers (the ones who administrate the server) could add or remove some functionalities of Jedox. It is located in data folder and on-premise could be accessed at this address <instalation folder>/Jedox/Jedox Suite/olap/data. Edit is possible if you do the right click and edit it. For this purpose, we will open it via standard Notepad.
Standard palo.ini
Lines starting with # are commented configurations and therefore will not be executed. The line will be skipped and the next one will be processed. More about palo.ini can be found on this link.
Here are the explanations of the lines:
http line represents the IP and port where jedox can be accessed.log sink is the location of the file where OLAP logs will be writtensplash-limit 1000 shows an error if splashing requires more space than the first number. 500 shows a warning if splashing requires more space than the second number. 100 Shows info if splashing requires more space than the...
In this blog post, you will be able to learn how to create ascending and descending sorting in Jedox based on the data value. This type of sorting is very valuable in cases when the end-users would like to make an analysis based on the best, worst-performing product, country, or customer. It can be combined with a top 10 analysis as well. This type of report we already covered in this post.
As you are probably guessing, we will be heavily relying on the subset for this example. Our goal will be to create a report where the same data can be sorted based on 3 measures (Sales, Cost of Sales and Units). Ascending and Descending sorting will be based on countries. Like always, Biker's best will be our testing database.
In our subset, we can see that sorting will be using PALO.D and there we will read from the orders cube. Only 10 countries will be selected and in the sort...
In this article, we will show you how to copy databases via ETL. This method does not require a service restart. All you need is a groovy script that is run in Groovy job. For this example, we will use the "Demo" database.
Groovy script
copyJedoxDatabase( 'Demo', 'Demo_Copy' )void copyJedoxDatabase( String jedoxConnectionSrc, String jedoxDatabaseDst ) {String jedoxDatabaseSrc = OLAP.getDatabase( jedoxConnectionSrc ).getName()String backupFilename = API.getProperty( "Demo_Copy" ) + jedoxDatabaseSrc + '.zip'// Remove backupFile if exists (e.g. from a previous run)new File( backupFilename ).delete()IDatabase db = OLAP.getDatabase( jedoxConnectionSrc )LOG.info( 'Saving database ' + jedoxDatabaseSrc + ' to ' + backupFilename )db.backup( backupFilename )IConnection conn = OLAP.getConnection( jedoxConnectionSrc )LOG.info( 'Restoring database ' + jedoxDatabaseDst + ' from ' + backupFilename )conn.addDatabase( jedoxDatabaseDst, backupFilename )boolean fileSuccessfullyDeleted = new File( backupFilename ).delete()}
Once the job is run, the new database will appear in the modeler.
ETL job can be downloaded from this location....
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 [email protected] 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....
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
