How to Use Drillthrough in Jedox with PostgreSQL

How to Use Drillthrough in Jedox with PostgreSQL

by Jedox 4 BeginnersNo Comments
Drillthrough is a very useful feature in Jedox that helps users get more detailed data directly from their cubes. For example, when analyzing aggregated data, you can right-click on a cell in your report and see the detailed information behind it. This can save a lot of time when you need deeper insights without creating complex new reports. In this article, I will explain: Why drillthroughs are used. What options do you have for setting up drillthrough. A step-by-step guide on how to use PostgreSQL as a drillthrough source in Jedox. A referral link to get started with a free PostgreSQL database on Aiven. Why Use Drillthrough? Drillthrough is commonly used in analytics to: Quickly check the source data behind aggregated values. Validate the data loaded into the cube. Provide more transparency to report users who want to see raw data. For example, if you have sales data aggregated by country, a drillthrough could show the transactions from individual stores or sales representatives in that country. Options for Drillthrough in Jedox In Jedox,...
Read More
Jedox Drill Features: Making Data Analysis Easy

Jedox Drill Features: Making Data Analysis Easy

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