November 2023 - Jedox for beginners

Data Synchronization in Jedox: A Practical Guide

November 26, 2023November 26, 2023 by Jedox 4 BeginnersNo Comments

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

Jedox Drill Features: Making Data Analysis Easy

November 18, 2023January 26, 2024 by Jedox 4 BeginnersNo Comments

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

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

November 4, 2023November 4, 2023 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...