In data analysis and business reporting, clarity is key. When presenting important insights or monitoring KPIs, unnecessary interface elements—such as toolbars, titles, and navigation tabs—can become distractions. By opening a Jedox report in full-screen or standalone mode, you can present your data in a clean, focused view.
This approach is especially useful for scenarios like executive presentations, live dashboards in conference rooms, or embedded displays in web applications where a streamlined, professional look is essential.
Steps to Open a Jedox Report in Standalone Mode
Navigate to the Report Properties
Go to the report you want to display in full-screen.
Right-click on the report and select Properties (or access it from the toolbar).
Switch to the “Link” Tab
In the Properties window, navigate to the Link tab to find options for sharing and customizing the report URL.
Set the Mode to Standalone
Under the Mode section, select Standalone. This removes the project navigation, creating a standalone display for the report.
Customize the Interface Elements
Uncheck the following options under the Interface...
A Waterfall Chart is an effective way to visualize the cumulative effect of sequential positive and negative values, especially when analyzing changes in financial data like profit and loss statements, sales figures, or expense breakdowns. In this article, we will guide you on how to create a Waterfall Chart using Jedox.
What is a Waterfall Chart?
Before we dive into the steps, it’s important to understand the basics of a Waterfall Chart. This type of chart shows how a value changes as positive and negative values are added to the initial starting point. Typically, a waterfall chart starts with a bar that represents the initial value, followed by bars that represent positive and negative changes, and ends with a final cumulative value.
Use Cases for Waterfall Charts:
Financial Reporting: Show breakdowns of revenue, costs, and profit changes over time.
Budgeting: Track actual versus budgeted performance, and isolate the factors driving the variance.
Sales Analysis: Display how individual deals contribute to the overall sales figure.
Steps to Create...
In today’s post, I’m excited to share an important update coming with Jedox 24.2: PGP decryption is now supported for file uploads, and it works with all major formats—Excel, CSV, JSON, Parquet and XML. This is a big step forward in helping you manage sensitive data securely within Jedox.
Why PGP Decryption Matters
If you’re handling sensitive or confidential data, security is key. PGP (Pretty Good Privacy) is a widely used encryption method that helps protect files from unauthorized access. With Jedox 24.2, you can now easily decrypt these PGP-encrypted files directly in the platform. This ensures your data stays secure while you work, without needing extra software.
Simple and Secure: Using the Jedox Key Vault
One of the great things about this new feature is its easy use. You can upload your private PGP keys to the Jedox secure key vault. This keeps your keys safe and ready to use whenever you need to decrypt files. Once your key is uploaded, the decryption...
Hello, dear readers! Today, I want to share with you an important use case that might be very useful in your daily work with Jedox. If you are working with Jedox Integrator and Report Designer, sometimes you need to automate processes to make your work easier and faster. One of these tasks might be copying a file from Report Designer, saving it to your file system, and then sending it as an email attachment. I will show you how to do this using a Groovy script. Let’s imagine a scenario where this might be necessary.
Business Scenario
Let’s say you are working in the finance department of a company, and every month you prepare financial reports using Jedox. These reports could be in different formats, like Excel (XLSX), CSV, or even images like PNG. After preparing these reports, you need to send them to your colleagues or your boss for review.
For example, you generate a monthly sales report in Excel format using...
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,...
Creating dynamic and visually engaging dashboards is crucial for effectively presenting financial data in Jedox. One way to add a dynamic visual element to your dashboard is by incorporating a scrolling widget. This guide will walk you through creating a simple marquee widget, which can display important announcements or highlights within your Jedox dashboard.
What is a Marquee?
It is a scrolling text effect that runs across a webpage. Although the HTML tag is outdated and not recommended for modern web development, it is still supported by many browsers and can be used for quick and simple effects like the one we are creating here.
Why Use a Marquee Widget?
Dynamic Content: It adds a dynamic element to your dashboard, making it visually appealing and drawing attention to important information.Ease of Use: Simple to implement and customize, a marquee widget can be quickly added to any dashboard.Highlight Important Information: Use a marquee to highlight important announcements, updates, or key financial metrics.
Adding the Marquee to...
Hi team, today we will talk about keeping your OLAP (Online Analytical Processing) rules up-to-date in a dynamic environment where data changes frequently. Jedox, a powerful platform for planning, analytics, and reporting, allows users to refresh or update rules easily from the spreadsheet server in case your business rules are set in that way. In this post, we'll dive into how you can use a simple PHP function to refresh rules for a specified database and cube.
Why Refresh Rules?
In Jedox, rules define how data is calculated within a cube. For instance, you might have rules that calculate 'Price' or 'Units' in a sales-related cube. When underlying data or logic changes, these ones need to be recalculated or refreshed to ensure the accuracy of your reports and dashboards.
The Code Explained
Here's a look at a simple function that makes the refresh in Jedox:
function _Refresh_Click(){ $host = $_JEDOX['OLAP_HOST']; $port = $_JEDOX['OLAP_PORT']; $conn = palo_init($host,...
We are thrilled to announce the launch of our UEFA2024 Prediction Game, built-in Jedox! This interactive and competitive game is designed to enhance your EURO 2024 experience, allowing you to predict match outcomes, identify top players, and ultimately challenge your football knowledge against fellow enthusiasts. Here’s everything you need to know to get started and make the most of this exciting application.
https://youtu.be/36MhQiqttSU
Key Features of the Prediction Game
Our application offers several user-friendly features designed to keep you engaged throughout the tournament:
Menu: The main hub where you can navigate to various sections of the game.
Input Screen: Submit your predictions for each game, including match winners and goal counts.
Leaderboard: Track your ranking and compare your performance with other players.
Top Scorer, MVP, and Champion Predictions: Make your picks for the tournament’s best player, top scorer, and the winning team.
Daily Player Predictions: Review and submit daily predictions, with opponent predictions revealed after kick-off to ensure fair play.
My Results: Check your past predictions and see how...
In today's fast-paced digital world, finding information quickly is crucial. At Jedox4Beginners.com, we are excited to introduce a powerful new feature to make your experience smoother: our interactive chatbot. This smart tool allows you to ask any question, and the bot will search our website to find the answers you need. Here’s how you can use our chatbot and the benefits it brings.
How to Use Our Chatbot
Using our chatbot is simple:
Access the Chatbot: Click the chat icon at the bottom right corner of our website.Ask Your Question: Type your question about Jedox, such as "How to create a new project in Jedox?".Receive Instant Answers: The bot quickly searches our website and provides relevant information.Follow-Up Questions: Continue the conversation if you need more details.1
https://youtu.be/cvwSsDlJvho
Benefits of Using the Chatbot
Time-SavingThe bot saves you time by providing instant answers, so you don't have to browse through multiple pages.
Enhanced User ExperienceIt makes navigating our website easier and more efficient, offering a pleasant and productive experience.
Discover...
Back in 2023, Jedox introduced the new component of Canvas. Year after, it is widely used by organizations and Jedox users. Apart from standard functionalities which we covered: https://jedox4beginners.com/canvas-kpi-cards-in-jedox-a-comprehensive-guide/ today we present a trick of how to hide combo boxes, labels, checkboxes and rows individually in a report for a smoother look and feel for the customer.
For this exercise, we will show how this combines with the reports coming from our BPA models. In case you want to learn more about them you can check it here. https://knowledgebase.jedox.com/models/accelerators/best-practice-accelerator.htm
You can hide a whole stack with one setting.
Happy canvassing!...
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
