Jedox 4 Beginners, Author at Jedox for beginners

Jedox ComboBox: Presenting Future Dates with Ease

July 1, 2023July 21, 2023 by Jedox 4 BeginnersNo Comments

Jedox, the versatile business intelligence and performance management solution, offers a range of features to streamline data analysis and visualization. In this article, we'll dive into the capabilities of Jedox ComboBox and explore how it can be used to present future dates in a user-friendly manner. We'll guide you through a step-by-step process to leverage this functionality, opening up new possibilities for data exploration and decision-making. So let's get started! As a pre-requirement, we will need a Day dimension in some of your databases. Step by Step: Presenting Future Dates in Jedox ComboBox 1: Retrieve the Current Date using TODAY(). 2: Convert the Current Date to the Day Dimension Format. 3: Return the DayValue Attribute: In this step, we retrieve the DayValue attribute, which represents the current date in integer format. 4: Set a Named Range for Attribute Filtering: We establish a named range in Jedox, which allows us to conveniently filter the DayValue attribute. 5: Create a ComboBox and Apply the Attribute Filter. 6: Get...

Utilizing Multi-Selection Elements from Listbox

June 29, 2023July 20, 2023 by Jedox 4 Beginners7 Comments

Listboxes are an essential feature in Jedox, a powerful business intelligence and performance management solution. They allow users to select multiple elements simultaneously, enabling dynamic analysis and reporting. This article will explore how multi-selected elements from Listbox can be effectively used in dynaranges, subsets, and Palo formulas. We will also demonstrate how formulas can automatically sum the values from the selected elements, providing enhanced functionality for data analysis. Understanding Multi-Selection Listboxes Listboxes in Jedox provide a dropdown list of elements that users can choose from. By enabling the multi-selection feature, users can select multiple elements simultaneously, offering flexibility in data analysis. This allows for creating dynamic reports and calculations based on specific selections. We will present 3 use cases where you can see how Multi-Selection elements can be utilized: Leveraging Palo Formulas for Automatic Summation Palo is the powerful multidimensional database engine that underlies Jedox. With multi-selected elements from a Listbox, you can enhance Palo formulas to automatically sum the values from the selected elements....

Geocharts visualisation in Jedox

June 14, 2023February 26, 2024 by Jedox 4 BeginnersNo Comments

In today's post, we'll explore the world of geocharts and how they can enhance your data visualization capabilities in Jedox. Specifically, we'll dive into using geocharts from Google and discuss how to leverage the Google API key to unlock their potential. What are Geocharts? Geocharts are powerful visual representations of data that allow you to display information on a geographic map. With just a few lines of code, you can transform your data into an interactive map. This helps you identify patterns, trends, and correlations across different regions. Why Use Geocharts in Jedox? Jedox, a BI and EPM platform, provides a wealth of features for data analysis and visualization. Geocharts offer a layer of insight, enabling you to explore data geographically and gain a deeper understanding of regional variations. Getting Started with Geocharts and Google API Key: To utilize Geocharts in Jedox, we'll need to integrate the Google Charts API, which powers these visualizations. Before we proceed, you'll need a Google API key,...

Bridging the Gap: Integrating Jedox with ChatGPT for Enhanced Analytics

June 6, 2023June 28, 2023 by Jedox 4 BeginnersNo Comments

In today's data-driven world, businesses rely heavily on advanced analytics solutions to gain valuable insights. One such powerful combination is the integration of Jedox, an enterprise planning and business intelligence platform, with ChatGPT, an AI language model developed by OpenAI. This integration opens up new possibilities for organizations, allowing them to leverage the capabilities of both technologies to achieve enhanced analytics and decision-making. Recently Jedox realised the model which showcases this bond. It can be found on the public marketplace and it is available for everyone. In order to work with the model users will need to have their own API key. Documentation of the model explains in detail how to obtain one and how to set it up in Jedox. The model contains 3 parts: 1st part is where you can send the numeric values to the model and ask it for interpretation of values. The goal is to receive a summary of values and it is good for the people who...

Jedox Datepicker 101: Creating Flexible Dynamic Ranges for Data Analysis

May 6, 2023June 28, 2023 by Jedox 4 BeginnersNo Comments

One of the features of Jedox is the Datepicker, a user-friendly interface that allows you to select dates, periods, and other parameters to filter and analyze your data. In this article, we'll show you how to create a dynamic range between two dates using the Jedox Datepicker. A dynamic range is a flexible range that automatically adjusts to include new data, and it can be a powerful tool for analyzing trends and making predictions. Before we create a report you need to prepare the following things: Create a Day dimension using a Day template Create additional attribute DayValue2 Create a rule which duplicates data from DayValue to DayValue2 Datepicker RULE After this is done let us create the spreadsheet report: Add two data pickers Add their values in the sheet and save them as a namerange Attribute Add Dyna range and in the Attribute, section use the variable "Attribute" =PALO.SUBSET("localhost/Datepicker","Day",1,,,,,PALO.AFILTER(Attribute,0,{true,true,true,true,true,true,true,true,true,true,true}),,PALO.SORT(1,0,,0,,0,0,,)) Save it and you are ready to go. This will now provide a more flexible and customizable approach to data analysis...

Connect Jedox Cloud and Power BI

April 24, 2023March 22, 2024 by Jedox 4 BeginnersNo Comments

To connect Jedox to Power BI, you will need to follow these steps: Make sure that the oData Hub service is running. (check Cloud Console) Obtain the Jedox OData API URL: usually, add odata before the cloud name. Example https://odata.test-jedox4begginers.cloud.jedox.com/DATABASENAME. It is also essential to add a database name at the end. In our case, we will put Biker as a database. Connect to Jedox from Power BI: Here, click on the "Get Data" button in the Home tab, and select "OData Feed" from the list of available data sources. Paste the Jedox OData API URL into the "URL" field, and click "OK" to connect to the Jedox server. Add the username and password. Depending if your team is using SSO choose Windows or Basic for standard Jedox credentials. Import data into Power BI: Once connected to the Jedox server, you can select the Jedox cubes or views you want to import into Power BI. Select the cube or view from the list of available tables,...

Running ETLs via macro using REST standard

February 12, 2023June 28, 2023 by Jedox 4 BeginnersNo Comments

The Integrator Server SOAP API has been deprecated as of Jedox 2022.4. If you used this standard to run ETL via macros you will need to change it now. There are two ways of doing that: Running ETLS via action buttons (highly recommended) Running ETLs via macro using Rest standard Action buttons are now already well incorporated in many Jedox projects and running ETL via them should be an easy task. However if you have issue to build such a connection, check out this link. Running ETLs using Rest standard takes a bit of coding but nothings super complex. IF you had SOAP connection-build-macro-report, make a backup of it and then delete all the code. Have in mind that if you had any IF or any other statements in the code before, make sure to save them. First we need to call the library require library('integrator-rest'); After that code for running looks like this: function sampleETL() { $etlProject = "PROJECT NAME"; $etlJob = 'JOB NAME'; // define array...

Jedox password policy

December 14, 2022December 14, 2022 by Jedox 4 BeginnersNo Comments

Starting from 2022.2 version Jedox implemented password policy change. That means that users cannot have abc123 passwords. Something more sophisticated should be done. Therefor certain rules needs to be followed: at least 10 characters at least one digit at least one of the symbols !@#$%^&* at least one uppercase or lowercase letter [A-Z] [a-z] cannot contain a period or space Example: Q20J!b5ei0951 This policy can be changed if the company has different set of rules. in that case parameter password-pattern in palo.ini allows you to change the password settings concerning the password length and the password pattern/complexity. Any attempt to change the password that does not match the defined pattern will result in an error displayed in the Change Password dialog. The password pattern can be defined by the key password-pattern <regular_expression>. If the new password does not match the pattern, an error message (error code 1004) is returned. <according to KB>. if in any case you built up the ETL which automatically assign the passwords to newly created users, groovy should look something like this: def user = API.getProperty('user'); def generator = { String alphabet, int...

How to hide System database to users

December 1, 2022December 1, 2022 by Jedox 4 BeginnersNo Comments

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: ...

IOUtils.setByteArrayMaxOverride() issue

November 2, 2022November 2, 2022 by Jedox 4 BeginnersNo Comments

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. ...