Welcome, Jedox enthusiasts! In today's tutorial, we'll dive into file compression and extraction using Jedox, specifically, the powerful FILE.unzip function. As a prerequisite, we will need to create some folders in our backend which will be used for testing purposes.
Connect to your backend with some tool like WinSCP.
If you don't have your credentials check the cloud console.
If you do not have access to the cloud console - contact cloud support.
Once you are connected create 2 folders in /etl_data/files/etl_data/files/For Zipping/etl_data/files/For Unzipping
In "For Zipping" folder add Excel files 1,2,3.
In the "For Unzipping" folder add two zipped files "ZippedWithoutPass" and "ZippedWithPass".
The password for unzipping is in the file pass. (Download the whole project at the bottom of the page)
At the same time we need to create some directory and file locations in Jedox which will be used as a path for the following scenarios:
Scenario 1: Compressing a File into a Zip Folder
The first scenario we'll explore is the basic compression of a...
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...
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,...
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...
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...
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...
Are you new to Jedox and want to learn how to create eye-catching charts for your reports? Combo charts in Jedox are a great way to present data that combines different types of information, and they are especially helpful when you want to visualize data in a simple and engaging way. In this beginner's guide, we'll walk you through the steps to create a combo chart in Jedox, and we'll explore the types of reports where this chart can be particularly useful.
What is a Combo Chart?
A combo chart in Jedox combines two different types of charts in one visual representation. You can have one chart type, such as columns or bars, representing one set of data, and another chart type, like a line chart, representing a different set of data on the same graph. This combination allows you to compare data sets that might have different scales or units of measurement.
Creating a Combo Chart in Jedox
Prepare Your Data: Make sure...
The upcoming release of Jedox in 2023.3 is set to bring exciting advancements to the ETL (Extract, Transform, Load) process by introducing a seamless connection to Snowflake, one of the leading cloud data warehousing solutions. With this integration, users can enjoy efficient data handling with two authentication options, enhanced by considerations for roles, warehouses, and databases.
After choosing the connection there are certain credentials which need to be added.
Authentication Options:
Username and Password: This traditional method allows users to authenticate their access to Snowflake by providing their username and password. This secure authentication process ensures that only authorized individuals can access and manipulate data within Snowflake.
Private Key Configuration: For those seeking enhanced security, the new connection also supports private key authentication. Users can configure their Snowflake accounts to accept private key authentication, adding an extra layer of protection to their data.
The Jedox-Snowflake integration doesn't stop at authentication methods. It also provides valuable features to help manage roles, warehouses, and databases seamlessly:
Role: Users...
Hello dear Jedox beginners,
In this post, we will take an unusual path and instead of connecting to usual business tools, we will try to extract the commodity and stock data. To do that we will connect to free API at https://www.alphavantage.co/.
Alpha Vantage is a financial data provider that offers a wide range of financial market data and services. It provides access to historical and real-time market data for various asset classes, including stocks, cryptocurrencies, forex (foreign exchange), and more. At this moment we will focus on commodity data.
The connection will be Rest type and the extract will be from JSON.
Technical details for commodities API
Resource is: https://www.alphavantage.co/query?function=${Commodity}&interval=daily&apikey=${API} where API Parameters are
❚ Required: function
The function of your choice. In this case, function=BRENT which is crude oil. A list of the commodities will come with the model
❚ Optional: interval
By default, interval=monthly. Strings daily, weekly, and monthly are accepted.
❚ Optional: datatype
By default, datatype=json. Strings json and csv are accepted with the following specifications: json returns the time series in JSON format; csv returns the time series as a CSV (comma-separated value) file.
❚...
Hey there, fellow data enthusiasts!
After an intensive two-year endeavour, We are thrilled to reveal a visual solution for Jedox users worldwide. Presenting an inspiring colour palette exclusively designed for KPI cards across 10 diverse industries. This innovative palette isn't just about colours – it's a toolkit that promises to speed up your dashboard creation, aid in design decisions, and provide plenty of alternatives and examples. Say goodbye to hours spent deliberating over colours, fonts, and alignments – with our palette, you'll have the visual power you need to craft stunning, industry-specific KPI cards.
Elevate your data representation and navigate your dashboards forward! 🚀🎨📈
NOTE: This feature only works with Jedox 2023.2 versions and newer.
If you think some of these can fit your dashboards you can download them from here.
But if you like to support every donation would be appreciated....
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.
