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....
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...
In this article, we will show you how to import different stylesheet examples inside your report.
In order to do this, we will use the stylesheet example given by Jedox which can be downloaded here.
If you don't know how to create a model check this article.
After that follow the next steps:
Step 1: Download the design system model from here: https://design-system.cloud.jedox.com/resources
Step 2: Export the DS Stylesheets report from the "//Models/Design System Templates/Configuration Reports/DS Stylesheet.wss" folder in the report designer.
Step 3: Import the report into your instance
Step 4: Configure the styles based on client requirements in the report by modifying them individually as described here: https://knowledgebase.jedox.com/models/other/configuring-design-elements.htm?Highlight=design
Step 5: Save the stylesheet report and tag it as a resource
Step 6: Insert the tagged stylesheets report as a resource in the client report where you want to apply the styles
Step 7: Use the styles in the client report....
While doing different projects we noticed that one of the repeating requirements is to export the Jedox report in Excel and then perform some additional analysis. As you know from before there are a few ways to export to excel.
xlsx - standard export
xlsx_snapshot - standard snapshot export
xlsx_olap_snapshot - OLAP snapshot export
In the case of xlsx export, data will be downloaded as a constant value. In this article, we will show you how to use the famous Excel function SUM incorporated in dynaranges.
How to create a button for exporting in Excel?
SUM in Jedox dynarange
Imagine that we have two sheets. The first one contains data in Dynarage which could be editable when exported to excel. The second sheet supposes to read all changes from the first one and sum it up accordingly.
In order to do that we will need to set up some steps:
Create name range for Products and for considered data. Remember: it is important to select one row before and after dynarange.
Create SUM function in the...
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...
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...
Hi Jedox beginners,
How many times has it happened that while working on your super complex ETLs, the save button becomes unclickable?
It can become really annoying problem, especially if you spent a decent amount of time in front of the PC.
Until now, the problem could be solved by:
Clicking Test button before and then pop up with "Save button" will appear
Log out, delete cache and log in again.
Since both solutions bring anxiety to your hands, simple CTRL + S typing on the keyboard is enabling the SAVE button again.
Click now and thank us later....
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.
