ERROR: portal “C_1” does not exist

ERROR: portal “C_1” does not exist

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...
Read More
Report Management in Jedox: Converting report paths to dimension elements

Report Management in Jedox: Converting report paths to dimension elements

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...
Read More
Creating a Combo Chart in Jedox

Creating a Combo Chart in Jedox

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