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

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

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,...
Read More
User settings and properties – language

User settings and properties – language

by Jedox 4 BeginnersNo Comments
In this article, we will explain how to change language via User properties and ways to do it. Usually, when creating a user in Jedox there are a few things you need to add in order to create it: All of this information is stored inside the System database and _USER_USER_PROPERTIES cube. Previously we talked about how to remove the panel from the side which uses appstate dimension element here. Today we are going to focus on how to change the language. Different users are coming from different regions and they would like to see their applications in regional languages. Sometimes it can happen that even decimal delimiters are important to them. For example, Germans use commas (,) for decimal delimiters and other dots (.). There are two ways to sort it: From the User Setting Panel. 2. From the Integrator. This method is much better for a large number of users. Before we start creating the ETL it's important to know where this property...
Read More