Integrating Jedox Reports from Excel to PowerPoint

Integrating Jedox Reports from Excel to PowerPoint

by Jedox 4 BeginnersNo Comments
In this guide, we’ll walk you through the steps to integrate Jedox reports from Excel into PowerPoint presentations, allowing for dynamic and effortless updates. Step 1: Creating a Paste View with the Jedox Add-in for Excel Rescently, Jedox released a new Excel 365 Add-in which allows you to read and analyze data from your Jedox instance and store values and comments to the Jedox In-Memory Database while using Excel 365 desktop or browser, without requiring local installation, simplifying deployment and access to the latest features. So to begin, open Excel and ensure you have the Jedox Add-in installed. If you haven’t already installed it, you can find detailed instructions on how to do so here. Once the add-in is installed, navigate to the data you want to include in your PowerPoint presentation. With the Jedox Add-in, you can easily create a Paste View by selecting the desired area of your spreadsheet. This Paste View serves as a snapshot of your data that can...
Read More
Embed Power BI reports in the Jedox

Embed Power BI reports in the Jedox

by Jedox 4 BeginnersNo Comments
Last time we learned how to connect Jedox with Power BI via oData and how to utilize the Jedox planning capability in the Power BI Dashboard. https://jedox4beginners.com/connect-jedox-cloud-and-powerbi/ Today, we go another direction and present the case where we will show how to embed Power BI reports inside the Jedox. In the realm of business intelligence, using the power of multiple tools can lead to unparalleled insights. In this guide, we'll explore the integration of Power BI reports into Jedox, unlocking a synergy that amplifies your analytical capabilities. Follow these straightforward steps to embed a Power BI report into your Jedox environment: Step 1: Create a Power BI Dashboard Begin by logging into your Power BI account and crafting a comprehensive dashboard that encapsulates the data you wish to analyze. Ensure that the visuals and insights align with your business objectives, offering a clear representation of the information you aim to convey. Step 2: Embed the Power BI Report Once your Power BI dashboard is polished, navigate...
Read More
Loading GPS Coordinates – Jedox XML Connection

Loading GPS Coordinates – Jedox XML Connection

by Jedox 4 BeginnersNo Comments
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