How to Create Bubble Chart in Jedox: A Beginner’s Guide!

How to Create Bubble Chart in Jedox: A Beginner’s Guide!

Bubble charts are powerful visualization tools that can effectively represent three data dimensions simultaneously: the x-axis, y-axis, and the size of the bubbles. In Jedox, creating a bubble chart is a straightforward process that allows users to gain insights into their data relationships with ease. In this guide, we'll walk through the steps to create compelling bubble charts in Jedox, catering specifically to beginners. Understanding Bubble Charts: Before diving into the creation process, it's essential to understand the fundamental components of a bubble chart. Unlike traditional charts like line or bar graphs, bubble charts utilize bubbles to represent data points. The x and y-axes denote two dimensions of data, while the size of the bubbles indicates a third dimension. This unique representation enables users to visualize complex data relationships intuitively. Getting Started with Jedox: To create a bubble chart in Jedox, you'll need to access the Jedox Web interface. Once logged in, navigate to the Jedox Web Reports module to begin building your chart. Step...
Read More
HTML custom meter bar in Jedox

HTML custom meter bar in Jedox

Jedox is a powerful tool for spreadsheet-based planning, analysis, and reporting. One of its features is the ability to customize spreadsheets using HTML and CSS, allowing users to create visually appealing and interactive dashboards directly within their Jedox environment. In this beginner's guide, we'll walk you through the process of integrating HTML and CSS code into your Jedox spreadsheets, enabling you to design stunning visualizations and enhance the user experience. Step 1: Setting Up Your Jedox Spreadsheet First, open your Jedox environment and navigate to the spreadsheet where you want to implement custom styling. Create a new worksheet or open an existing one where you'd like to add visual elements. Step 2: Adding HTML and CSS Code Once you've selected your worksheet, you can start adding HTML and CSS code to customize its appearance. For example, let's say you want to create a meter bar to track project completion or budget consumption %. You can use the following code: <style> meter { ...
Read More
Subsets, Lists and Virtual Dimensions in Jedox

Subsets, Lists and Virtual Dimensions in Jedox

In the realm of Jedox, manoeuvring through different data structures such as subsets, virtual dimensions, and lists can feel like finding your way through a maze. Each of these possibilities has its unique function, and knowing how and when to utilize them can greatly improve your Jedox usage. This guide will explore subsets, virtual dimensions, and lists in-depth, covering their uses, benefits, drawbacks, and the optimal situations for integrating them into your Jedox endeavours. Subsets Subsets in Jedox act as filtered views of dimensions, allowing users to focus on specific elements within a dimension. They are useful for simplifying data analysis and report generation by narrowing the scope of data to relevant subsets. They can be static or dynamic, meaning they can either have fixed elements or dynamically adjust based on specified criteria. Within Jedox subsets, users can filter elements by including or excluding specific ones, applying dynamic criteria like numerical, text, or date ranges, leveraging hierarchical relationships to select entire branches...
Read More
Loading GPS Coordinates – Jedox XML Connection

Loading GPS Coordinates – Jedox XML Connection

Happy New Year, fellow Jedox enthusiasts! In today's article, we'll be delving into an interesting use case: extracting GPS coordinates in XML format from the OpenStreetMap Nominatim API (https://nominatim.openstreetmap.org/). This adventure will involve using a constant table as a source for countries and cities, interacting with the Nominatim API to retrieve latitude and longitude data, and finally looping and storing this valuable information in the Jedox database. This type of use case is often visible when our cube contains a Geography dimension and then we would like to enhance attribute collection by additional parameters like latitude and longitude. These are very useful in case you would like to create a widget map. Something similar can be found: https://jedox4beginners.com/geocharts-visualisation-in-jedox/ Let us follow the next 4 Steps. Step 1: The Constant Table: In Jedox, we'll create a constant table containing a list of countries and cities. This table will serve as our foundation for the XML extraction process. Think of it as a map guiding us...
Read More
Mastering File Compression and Extraction in Jedox

Mastering File Compression and Extraction in Jedox

Welcome, Jedox enthusiasts! In today's tutorial, we'll dive into file compression and extraction using Jedox, specifically, the powerful FILE.unzip function. As a prerequisite, we will need to create some folders in our backend which will be used for testing purposes. Connect to your backend with some tool like WinSCP. If you don't have your credentials check the cloud console. If you do not have access to the cloud console - contact cloud support. Once you are connected create 2 folders in /etl_data/files/etl_data/files/For Zipping/etl_data/files/For Unzipping In "For Zipping" folder add Excel files 1,2,3. In the "For Unzipping" folder add two zipped files "ZippedWithoutPass" and "ZippedWithPass". The password for unzipping is in the file pass. (Download the whole project at the bottom of the page) At the same time we need to create some directory and file locations in Jedox which will be used as a path for the following scenarios: Scenario 1: Compressing a File into a Zip Folder The first scenario we'll explore is the basic compression of a...
Read More
Data Synchronization in Jedox: A Practical Guide

Data Synchronization in Jedox: A Practical Guide

In today's tech-driven world, keeping your development and testing instances in sync with your live instance is crucial. This ensures that your data is up to date and reflects the latest changes. Synchronization, and in this guide, we'll explore how to make the most of it. From Hours to Clicks - Simplifying Server Synchronization with Jedox In the old days, syncing instances was slower and users needed to understand navigating a labyrinth of steps, consuming valuable hours. Usually, it looked something like this: Step 1: Exporting and Uploading Reports Traditionally, exporting all reports in pb format from one instance and uploading them to another was the go-to method. It worked, but the time invested was significant. Step 2: Database Dilemma Downloading databases one by one or employing scripts was another strategy. Dealing with gigantic databases often meant resorting to backend uploads via tools like WinSCP, followed by the not-so-fun task of restarting services. However, user headaches emerged. Uploading the System Database after the second step led...
Read More
Jedox Drill Features: Making Data Analysis Easy

Jedox Drill Features: Making Data Analysis Easy

In the world of data analysis, Jedox brings some handy tools to the table - Data Drillthrough and Drill Anywhere. Let’s break down what they do and why they matter to you. What's Data Drillthrough? Data Drillthrough in Jedox lets you quickly access extra info without jumping around different reports. For example, if you're checking out Orders by Product and want to know more about the Customers for each product, Drillthrough has your back. Using it is a breeze. In Jedox Views, just right-click on a number, choose Drillthrough, and bam! You get a new table with more details. You can customize it to show just what you need.And if you're using Web Spreadsheets, you can export the data as a CSV or XLSX file. One thing to keep in mind – the CSV file sticks to English number formatting, even if your language settings are different. Just import it into Excel, and you’re good to go. Here's a quick tip: in Drillthrough results,...
Read More
How to Create Success Charts in Jedox: A Beginner’s Guide!

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

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

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 🔵🔴🟢 🟡

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