jedox Archives - Page 2 of 3 - Jedox for beginners

Report Management in Jedox: Converting report paths to dimension elements

October 15, 2023November 20, 2023 by Jedox 4 Beginners5 Comments

Are you looking for an efficient way to manage and organize your reports in Jedox? This guide will explore how to export folders and files from Jedox Report Designer and transform them into a dynamic dimension of elements within the Modeler. By leveraging the paths as attributes, we can create an easily navigable system to represent all reports in the Jedox environment, enhancing user experience and productivity. Export the project from here. Exporting Folders and Files from Jedox Report Designer Organize Your Reports: Ensure your reports are systematically organized within the Jedox Report Designer for exporting. Export Data to Modeler: Utilize the ETL Integrator to transfer folders and file names as dimension elements to the Modeler. Check the project for the details. Creating a Dimension with File Paths as Attributes Set Up the Dimension: In the Modeler, create a new dimension with the exported file paths as attributes, allowing for a representation of the report structure. Configure Attribute Settings: Customize the attribute settings to ensure navigation and...

Charting New Horizons: Navigating Stock and Commodities Markets with Jedox 📈📊

August 25, 2023August 25, 2023 by Jedox 4 BeginnersNo Comments

Hello dear Jedox beginners, In this post, we will take an unusual path and instead of connecting to usual business tools, we will try to extract the commodity and stock data. To do that we will connect to free API at https://www.alphavantage.co/. Alpha Vantage is a financial data provider that offers a wide range of financial market data and services. It provides access to historical and real-time market data for various asset classes, including stocks, cryptocurrencies, forex (foreign exchange), and more. At this moment we will focus on commodity data. The connection will be Rest type and the extract will be from JSON. Technical details for commodities API Resource is: https://www.alphavantage.co/query?function=${Commodity}&interval=daily&apikey=${API} where API Parameters are ❚ Required: function The function of your choice. In this case, function=BRENT which is crude oil. A list of the commodities will come with the model ❚ Optional: interval By default, interval=monthly. Strings daily, weekly, and monthly are accepted. ❚ Optional: datatype By default, datatype=json. Strings json and csv are accepted with the following specifications: json returns the time series in JSON format; csv returns the time series as a CSV (comma-separated value) file. ❚...

Canvas KPI Cards in Jedox: A Comprehensive Guide

July 23, 2023August 8, 2023 by Jedox 4 Beginners1 Comment

Canvas KPI Cards in Jedox provide a powerful way to display summary measures from your data and assess the status of an action against a target or comparison value. They were introduced with version 2023.2 and expanded Canvas capabilities to another level. These visually engaging KPI Cards allow users to track and communicate progress toward measurable goals easily. In order to start using them you need to create a new Canvas type of report in the Report Manager. After that, from the left side, you will be able to see the Components section. Format Tab When you add a KPI Card to your Canvas, a dialogue box with two tabs appears on the right side of the screen. The Format tab allows you to customize properties such as name, width, padding, margin, background colour, and radius. Moreover, the Format tab's lower section allows you to personalize the font style and alignment of different sections within the KPI Card, such as Title, Value, and Comparison. Data...

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

Connect Jedox Cloud and Power BI

April 24, 2023November 20, 2024 by Jedox 4 Beginners4 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,...

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 use hyperlinks in Jedox?

August 21, 2022June 28, 2023 by Jedox 4 BeginnersNo Comments

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

Palo.ini standard configurations

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

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