Accessing Jedox Logs via API – A Simple Guide

Accessing Jedox Logs via API – A Simple Guide

by Jedox 4 BeginnersNo Comments
When working with Jedox Integrator, logs are your best friend for troubleshooting and monitoring. But did you know you can access these logs programmatically using the Jedox Logs API? This is super useful if you want to automate log checks, integrate them into external monitoring tools, or simply avoid clicking through the UI every time. In this post, I’ll show you how to: Understand the Logs API endpoints Access log data using REST calls Use filters to get exactly what you need Step 1: Why Use the Logs API? Normally, you check logs in Cloud Console→Server Logs. But if you’re building automated workflows or need logs for external dashboards, the API is the way to go. It gives you: Direct access to log entries (Integrator jobs, system events, etc.) Ability to filter by date, level, or component Integration with tools like Power BI, Databricks, or custom scripts Step 2: The API Endpoint The base endpoint is: GET /https://logs.${Instance}.cloud.jedox.com/logs Step 3: Authentication You’ll need your Token, which can be found in Cloud Console Settings. Add...
Read More
Connecting Jedox to Databricks: A Beginner’s Guide

Connecting Jedox to Databricks: A Beginner’s Guide

by Jedox 4 BeginnersNo Comments
If you’re working with large datasets and advanced analytics, Databricks is a powerful platform that combines data engineering, machine learning, and analytics in one place. But what if you want to bring that data into Jedox for planning and reporting? In this guide, we’ll walk through the basics of connecting to Databricks via its REST API and pulling data into Jedox. Step 1: Open Databricks and Understand the Structure Start by logging into Databricks. Once inside, you’ll see the Catalog section on the left-hand side. Here’s what the main components mean: Catalog: The top-level container for organizing data assets. Workspace: Your environment where notebooks, jobs, and data live. Database: A logical grouping of tables within a catalog. Table: The actual dataset you query. In our example, the table is orders_2_drillthrough. In the screenshot above, you can see: Catalog: main Workspace: default Database: default Table: orders_2_drillthrough This table contains columns like Year, Month, Products, Customers, and Measures—perfect for analysis in Jedox. Step 2: Generate a Bearer Token To access Databricks programmatically, you need an authentication...
Read More

Integrating DeepL with Jedox: Smarter Translations for Global Planning

by Jedox 4 BeginnersNo Comments
Introduction Jedox is a powerful platform for enterprise planning, but when teams span multiple languages, communication can become a challenge. That’s where DeepL, an AI-powered translation service, comes in. In this post, we’ll explore why integrating DeepL with Jedox makes sense, how to do it, and where it can add real value—especially in translating comments and user-generated content. Why DeepL? Accurate translations: DeepL is widely praised for its natural-sounding translations, especially in business contexts. Fast and scalable: Translate content instantly without leaving Jedox. Improved collaboration: Make dashboards and reports accessible to global teams. How to Integrate DeepL with Jedox Step 1: Get Your API Key Visit https://developers.deepl.com/docs/getting-started/intro and sign up for an API account. You’ll receive an auth_key to use in your requests. Step 2: Create a REST Connection in Jedox Integrator Go to Integrations > Connections Choose REST as the connection type Set the base URL:https://api.deepl.com/v2/translate Add parameters: Authorization=DeepL-Auth-Key [YOUR_API_KEY] Content-Type: application/json Accept: application/json text=YourText target_lang=EN (or any supported language code) Use Cases in Jedox 1. Translating Cell Comments Enable users to write comments in their native language and have them auto-translated for reviewers in other regions. 2. Multilingual Dashboards Use DeepL to translate...
Read More
Connection to Google BigQuery

Connection to Google BigQuery

by Jedox 4 BeginnersNo Comments
If you're working with data in Jedox and need to pull information from Google's BigQuery, you're in the right place! In this guide, we'll walk you through how to set up the REST connector in Jedox, authenticate using Google tokens, and pull data from BigQuery. Why Big Query Uses a Modified JSON Format Before we dive into the steps, it's good to know why BigQuery uses a slightly different version of JSON. BigQuery expects newline-delimited JSON (NDJSON), where each JSON object is on a separate line. This makes it easier to process large datasets efficiently. If you're preparing data for loading , make sure it's in this format. For example: {"id": 1, "name": "Alice"} {"id": 2, "name": "Bob"} This is why we can't just use standard JSON where everything is wrapped in one big array. Step 1: Get Your Google Token for Authentication To connect Jedox to BigQuery, you need to authenticate using a Google token. Here's how to get it: Go to the Google Cloud Console https://console.cloud.google.com/. Navigate...
Read More
Automating User Data Deletion with Jedox ETL – Compliance

Automating User Data Deletion with Jedox ETL – Compliance

by Jedox 4 BeginnersNo Comments
In today's data-driven world, companies operating in Germany and across the EU must comply with strict data privacy regulations, such as the General Data Protection Regulation (GDPR) and other local laws. One key requirement in many industries is the removal of user behavior data after a certain period to protect user privacy. This can include deleting user accounts that have been inactive for a specific duration. The Problem: Removing Inactive Users Automatically Many businesses store user login data, but regulations may require them to delete users who have not logged in within a specific timeframe—for example, 90 days. Manually managing this process is inefficient and error-prone, especially for large organizations. To address this challenge, we can use Jedox ETL (Extract, Transform, Load) to automate the identification and deletion of inactive users. This ensures compliance while reducing manual effort. Solution: Using Jedox ETL to Identify and Delete Inactive Users Jedox ETL allows us to create a streamlined workflow to extract user login data, filter out inactive...
Read More
Create elements in Jedox ETL with Groovy

Create elements in Jedox ETL with Groovy

by Jedox 4 BeginnersNo Comments
In multidimensional databases like Jedox, managing dimensions and hierarchies effectively is crucial for accurate data analysis and reporting. Consolidations, which define parent-child relationships within dimensions, are an important part of this process. In this post, we’ll explore how to automate the creation of base and consolidated elements using Groovy scripting in Jedox ETL. We’ll also dive into a practical business use case to showcase the power of this approach. The Problem: Automating Dimension Hierarchies Managing dimension hierarchies manually can be time-consuming and prone to errors, especially when dealing with dynamic or frequently changing datasets. Using Groovy in Jedox ETL, we can automate the creation and management of elements and their consolidations. This makes the process faster, more reliable, and easier to maintain. Below is a Groovy script that demonstrates how to: Connect to a database and retrieve a dimension. Create base elements and a parent element. Add consolidations between the parent and its child elements. Java documentation here. The Script: Building Base and Consolidations in Jedox Here’s the...
Read More
Calendar Extract (Month, Year and Life To Date patterns) in Jedox

Calendar Extract (Month, Year and Life To Date patterns) in Jedox

by Jedox 4 BeginnersNo Comments
Understanding how to create and use Calendar Extracts in Jedox is crucial for effective time-based analysis. Calendar Extracts are essential for breaking down your data into manageable and meaningful periods, like months, years, or Life to Date (LTD) views. In this guide, we'll walk you through how to set up these patterns in Jedox and explore real-life scenarios where each pattern is most effective. What is a Calendar Extract in Jedox? A Calendar Extract in Jedox Integrator is a feature that allows you to filter and segment your data based on time periods such as months, years, or the cumulative period up to the current date (Life to Date). This is particularly useful for generating your Time dimensions and subsequently reports, dashboards, or performing time-series analysis. In this post, we will focus on 3 common use cases: Month Pattern - MTD captures data from the 1st of the month through to the most recent complete day.: Use Case: Monthly financial reporting, monitoring sales trends,...
Read More
Connection to OneDrive

Connection to OneDrive

by Jedox 4 Beginners1 Comment
This week we will talk about how can Jedox connect to OneDrive. OneDrive is a cloud storage service developed by Microsoft, allowing users to store files and photos securely online, accessible from any device with an internet connection. It integrates with Microsoft Office applications and offers collaboration features for sharing and editing documents in real time. We will showcase two ways of doing it, with a username and password and with a token connection. Connecting with Username and Password This method is less secure but allows users to simply access the files. Upload the file you would like to access from Jedox and specify the path: It is important to know your Azure application ID. you can request it from your IT department or in case you have access to your application Azure find it here: Now, if you test your connection to file it should be successful. Connecting via Token Connection As for the first case, you will need to have existing credentials to access the...
Read More
Mastering File Compression and Extraction in Jedox

Mastering File Compression and Extraction in Jedox

by Jedox 4 Beginners3 Comments
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
Report Management in Jedox: Converting report paths to dimension elements

Report Management in Jedox: Converting report paths to dimension elements

by Jedox 4 Beginners8 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...
Read More