jedox Archives - Jedox for beginners

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

August 23, 2024August 23, 2024 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,...

Refreshing Rules in Jedox: A Step-by-Step Guide

August 9, 2024August 9, 2024 by Jedox 4 BeginnersNo Comments

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

Welcome to the UEFA 2024 Prediction Game! ⚽⚽⚽

June 5, 2024June 17, 2024 by Jedox 4 BeginnersNo Comments

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...

How to Connect Amazon S3 and Jedox via REST Connection

April 4, 2024April 4, 2024 by Jedox 4 Beginners1 Comment

In today's data-driven world, integrating various systems and services is essential for efficient data management and analysis. Connecting Amazon S3, a powerful cloud storage service, with Jedox, a leading enterprise planning and analytics platform, can streamline data workflows and enhance decision-making processes. In this tutorial, we'll guide you through the process of setting up a REST connection between Amazon S3 and Jedox. Prerequisites Before we begin, make sure you have the following prerequisites: Amazon Account Creation: If you haven't already, sign up for an Amazon Web Services (AWS) account here. Creating an S3 Bucket: Log in to the AWS Management Console and create a bucket in Amazon S3 to store your data. Generating a Policy: Generate a policy in AWS Identity and Access Management (IAM) to define permissions for accessing the S3 bucket. Uploading a File to the Bucket: Upload a file to the S3 bucket to test the connection. Creating a Role: Create an IAM role to grant access to AWS resources. Creating a REST API: Set...

Subsets, Lists and Virtual Dimensions in Jedox

February 3, 2024February 3, 2024 by Jedox 4 BeginnersNo Comments

In the realm of Jedox, manoeuvring through different data structures such as subsets, virtual dimensions, and lists can feel like finding your way through a maze. Each of these possibilities has its unique function, and knowing how and when to utilize them can greatly improve your Jedox usage. This guide will explore subsets, virtual dimensions, and lists in-depth, covering their uses, benefits, drawbacks, and the optimal situations for integrating them into your Jedox endeavours. Subsets Subsets in Jedox act as filtered views of dimensions, allowing users to focus on specific elements within a dimension. They are useful for simplifying data analysis and report generation by narrowing the scope of data to relevant subsets. They can be static or dynamic, meaning they can either have fixed elements or dynamically adjust based on specified criteria. Within Jedox subsets, users can filter elements by including or excluding specific ones, applying dynamic criteria like numerical, text, or date ranges, leveraging hierarchical relationships to select entire branches...

Data Synchronization in Jedox: A Practical Guide

November 26, 2023November 26, 2023 by Jedox 4 BeginnersNo Comments

In today's tech-driven world, keeping your development and testing instances in sync with your live instance is crucial. This ensures that your data is up to date and reflects the latest changes. Synchronization, and in this guide, we'll explore how to make the most of it. From Hours to Clicks - Simplifying Server Synchronization with Jedox In the old days, syncing instances was slower and users needed to understand navigating a labyrinth of steps, consuming valuable hours. Usually, it looked something like this: Step 1: Exporting and Uploading Reports Traditionally, exporting all reports in pb format from one instance and uploading them to another was the go-to method. It worked, but the time invested was significant. Step 2: Database Dilemma Downloading databases one by one or employing scripts was another strategy. Dealing with gigantic databases often meant resorting to backend uploads via tools like WinSCP, followed by the not-so-fun task of restarting services. However, user headaches emerged. Uploading the System Database after the second step led...

Jedox Drill Features: Making Data Analysis Easy

November 18, 2023January 26, 2024 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,...

How to Create Success Charts in Jedox: A Beginner’s Guide!

November 4, 2023November 4, 2023 by Jedox 4 BeginnersNo Comments

Hey there, it's been a while! Today, I want to discuss creating your own success or progress charts in Jedox. These charts help us understand how things are going, like how much we sell and how much we make. We'll use info from our BikerBest data and look at four areas: East, West, North, and South. The chart will show us how much things changed from one year to the next. If something is red, it means it's the minimum value for that product in all the areas. If it's green, it means it's the maximal. We can even use different things like bars, rockets, or hearts to show the info. Fun, right? So, let's jump right in and learn how to make our own special chart in Jedox. Don't worry, it's not hard! Just follow these steps: Steps for creating a success chart Pick the Numbers: Choose the things you want to show in your chart from the BikerBest data. Maybe it's...

ERROR: portal “C_1” does not exist

October 31, 2023December 18, 2023 by Jedox 4 BeginnersNo Comments

Sometimes while loading via Relational load you might stumble upon the following error: Cannot load data into table XXX: ERROR: portal "C_1" does not exist(load New Relational load) Although I am not sure for the real reason of this error, it is worth of looking and Fetch Modes for PostgreSQL. For a PostgreSQL database, you can adjust the fetch mode as follows:Buffered (default): the query result is returned with buffering. In this case, no parallel queries to the same PostgreSQL Server are possible.Full: PostgreSQL returns the query result in one block. This is potentially slower, with higher memory consumption. It should only be set if the connection is used in several components that are processed in parallel during a load, e.g. several PostgreSQL extracts that are joined in a transform, an extract, and a load on the same PostgreSQL connection or when using parallel jobs. (Note that in those cases, if the fetch mode is not set to "full" this might lead to an error...

Report Management in Jedox: Converting report paths to dimension elements

October 15, 2023November 20, 2023 by Jedox 4 Beginners4 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...