How to Create Success Charts in Jedox: A Beginner’s Guide!

How to Create Success Charts in Jedox: A Beginner’s Guide!

by Jedox 4 BeginnersNo Comments
Hey there, it's been a while! Today, I want to discuss creating your own success or progress charts in Jedox. These charts help us understand how things are going, like how much we sell and how much we make. We'll use info from our BikerBest data and look at four areas: East, West, North, and South. The chart will show us how much things changed from one year to the next. If something is red, it means it's the minimum value for that product in all the areas. If it's green, it means it's the maximal. We can even use different things like bars, rockets, or hearts to show the info. Fun, right? So, let's jump right in and learn how to make our own special chart in Jedox. Don't worry, it's not hard! Just follow these steps: Steps for creating a success chart Pick the Numbers: Choose the things you want to show in your chart from the BikerBest data. Maybe it's...
Read More
Creating a Combo Chart in Jedox

Creating a Combo Chart in Jedox

by Jedox 4 BeginnersNo Comments
Are you new to Jedox and want to learn how to create eye-catching charts for your reports? Combo charts in Jedox are a great way to present data that combines different types of information, and they are especially helpful when you want to visualize data in a simple and engaging way. In this beginner's guide, we'll walk you through the steps to create a combo chart in Jedox, and we'll explore the types of reports where this chart can be particularly useful. What is a Combo Chart? A combo chart in Jedox combines two different types of charts in one visual representation. You can have one chart type, such as columns or bars, representing one set of data, and another chart type, like a line chart, representing a different set of data on the same graph. This combination allows you to compare data sets that might have different scales or units of measurement. Creating a Combo Chart in Jedox Prepare Your Data: Make sure...
Read More
VisualVibe 275 – Jedox KPI Cards πŸ”΅πŸ”΄πŸŸ’ 🟑

VisualVibe 275 – Jedox KPI Cards πŸ”΅πŸ”΄πŸŸ’ 🟑

by Jedox 4 BeginnersNo Comments
Hey there, fellow data enthusiasts! After an intensive two-year endeavour, We are thrilled to reveal a visual solution for Jedox users worldwide. Presenting an inspiring colour palette exclusively designed for KPI cards across 10 diverse industries. This innovative palette isn't just about colours – it's a toolkit that promises to speed up your dashboard creation, aid in design decisions, and provide plenty of alternatives and examples. Say goodbye to hours spent deliberating over colours, fonts, and alignments – with our palette, you'll have the visual power you need to craft stunning, industry-specific KPI cards. Elevate your data representation and navigate your dashboards forward! πŸš€πŸŽ¨πŸ“ˆ NOTE: This feature only works with Jedox 2023.2 versions and newer. If you think some of these can fit your dashboards you can buy them here for symbolical 3.99 euros. NOTE: Only PayPal payments are possible at the moment. ...
Read More
Canvas KPI Cards in Jedox: A Comprehensive Guide

Canvas KPI Cards in Jedox: A Comprehensive Guide

by Jedox 4 BeginnersNo Comments
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...
Read More
Jedox ComboBox: Presenting Future Dates with Ease

Jedox ComboBox: Presenting Future Dates with Ease

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...
Read More
Utilizing Multi-Selection Elements from Listbox

Utilizing Multi-Selection Elements from Listbox

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....
Read More
Geocharts visualisation in Jedox

Geocharts visualisation in Jedox

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,...
Read More
Bridging the Gap: Integrating Jedox with ChatGPT for Enhanced Analytics

Bridging the Gap: Integrating Jedox with ChatGPT for Enhanced Analytics

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...
Read More
Jedox Datepicker 101: Creating Flexible Dynamic Ranges for Data Analysis

Jedox Datepicker 101: Creating Flexible Dynamic Ranges for Data Analysis

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...
Read More
Connect Jedox Cloud and Power BI

Connect Jedox Cloud and Power BI

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,...
Read More