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
Create Dynamic Organizational Charts with Jedox

Create Dynamic Organizational Charts with Jedox

by Jedox 4 BeginnersNo Comments
Organizational charts are essential tools for visualizing the structure of teams and organizations. They help to showcase relationships between different roles or departments, making it easier to understand the chain of command or responsibilities. Using Jedox, you can create a dynamic and interactive organizational chart that automatically updates with changes from your spreadsheet data. Why Use an Organizational Chart? Organizational charts can be used for: Visualizing Team Structures: Understand how teams and departments are organized. Presenting Hierarchies: Show the chain of command or reporting lines. Onboarding New Employees: Help new hires quickly familiarize themselves with the organization. How to Create a Dynamic Chart in Jedox With Jedox widgets, creating an organizational chart becomes an easy process. Widgets allow you to dynamically pass spreadsheet data into an HTML/JavaScript code snippet to render visualizations. Here’s an example: Spreadsheet Setup: Organize your data in a parent-child format. Usually, this is the data that comes from Dimension. For this example, we will copy bellow table into dimension "OrgStructure" which will be used in...
Read More