-
Jedox 4 Beginners replied to the topic "How to remove ^-,.|} from the element name?" – 2 years, 9 months ago
you can use groovy for it
return _input1.replaceAll(“[^a-zA-Z0-9]”, “”);
where all non alphabetic characters will be replaced by empty string -
Jedox 4 Beginners posted a new topic "How to remove ^-,.|} from the element name?" – 2 years, 9 months ago
How to remove ^-,.|} from the element name?
-
Jedox 4 Beginners replied to the topic "exclude ~ from text filter" – 2 years, 9 months ago
Hi!
Try like this
“^((?!~).)*$” -
Jedox 4 Beginners posted a new topic "exclude ~ from text filter" – 2 years, 9 months ago
How to exclude ~ from text filter via Regular Expression?
-
-
Jedox 4 Beginners posted a new topic "REMOVING EXTRA SPACE IN THE JEDOX REPORT" – 2 years, 9 months ago
Issue related to the big size of the report which disables fast opening.
-
Jedox 4 Beginners wrote a new post 2 years, 9 months ago
Unable to click save button in Jedox ETL
Hi Jedox beginners, How many times has it happened that while working on your super complex ETLs, the save button becomes […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Building Dynamic Calendars in Jedox
In this guide, we’ll walk you through the process of crafting a calendar widget within the Jedox platform. This endeavor requires the presence of […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Add element to the Jedox database via macro
In this post, we are going to show you how to use multiple PALO functions in the macro to successfully add element in the dimension. For this purpose […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Excel download using macro
Here is one quick way to download a file as an Excel. In normal conditions, Jedox offers two possibilities to Export to Excel: XLSX […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Dynamic denormalization
One of the commonly used transformations in ETL is Table denormalization. DenormalizationΒ is the reverse of normalization. Row-based data with […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Mapping Matrix
When working with dimensions like products there must be a use-case when mapping matrix is necessary. This little mapping matrix is used when there […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Best way to copy data without using the ETL
During the planning process, there will be activities that require to copy data from the previous year or another version. There are multiple ways to […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
How to create a colour picker in Jedox?
Jedox has a wide range of possibilities when it comes to reporting since it is working based on Excel technology. Having that in mind it might […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
How to return IP address from the Spreadsheet in Jedox
Here is the sample of the macro PHP code which can help you to return the IP address of the current server from the spreadsheet. It could be useful […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
How to create paging in Jedox?
When crafting reports in Jedox, it’s not uncommon to encounter scenarios where the large volume of rows becomes unwieldy. In such cases, the […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Create slideshow widget in Jedox
Jedox provides many possibilities when creating a report or a dashboard. Apart from native components like buttons, combo, and checkboxes, lists […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Exchange rate Cubes
In this post, we will show you examples of an exchange rate cube, a planning cube, and how to set up the rules between them. This topic is very […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Version blending
VersionΒ blendingΒ is functionality that brings actual figures to be visible in the forecastΒ versions. Each forecast element in the Version di […] -
Jedox 4 Beginners wrote a new post 2 years, 10 months ago
Audit in Jedox
When the cycle of planning starts it is important to track all inputs. One reason is for monitoring purposes [Who did when what and why] and the […] - Load More
