etl Archives - Page 2 of 2 - Jedox for beginners

Dynamic denormalization

January 2, 2022June 28, 2023 by Jedox 4 BeginnersNo Comments

One of the commonly used transformations in ETL is Table denormalization. Denormalization is the reverse of normalization. Row-based data with key-value pairs is transposed into column-based data. This allows an OLAP model with one measure in each row (with the measure name as a key) to be arranged into a relational model in which the measures are held in various columns. Jedox knowledge base In typical table denormalization, Measure fields are populated by the rows which we want to see in columns. Usually, it's enough to do it one by one but sometimes it happens that there are 30 or 50 elements that needed to be transposed into the columns. For that reason, we will use a little trick that can be found in Advanced settings. In case you are not familiar with this type of transformation here is the link that can help. Our file contains 3 columns and one of them contains data that should be denormalized. Instead of using static measures, we will introduce...

Audit in Jedox

December 30, 2021June 28, 2023 by Jedox 4 BeginnersNo Comments

When the cycle of planning starts it is important to track all inputs. One reason is for monitoring purposes [Who did when what and why] and the second is to keep the log of how data looked before that step. For that purpose, we will use Audit functionality. This functionality can be found in the Administration tab: By default, an audit is not started until the user enables it in Settings Panel. Auditing can be done for 1,7,30 or 365 days. Have in mind that a larger auditing period is selected, the file on your server will take more memory. Once you select the cube which should be monitored, add some value inside. In our case, we will add 400 Units for Handlebars inside Orders Cube which we previously enabled in Audit. After hitting that splash functionality new value is visible in the Audit section. Now, you can check why the values are appearing in the report since everybody claims it was not their...

How to rename elements from Jedox ETL?

October 5, 2015June 28, 2023 by Jedox 4 BeginnersNo Comments

Sometimes it could happen that there is a request to rename element in modeler outside of the spreahsheet or manual. For that puspose we could use ETL and more speciefically groovy job. In following example we will show how to rename element from User dimension using groovy job. API.executeLoad("Users_Load"); LOG.info("Start renaming elements"); source = API.initSource("Users_Extract","EA",0); String oldNames = "joe"; String newNames = "Martin"; OLAP.erename("olapsystem","#_USER_",oldNames as String,newNames as String); LOG.info("Finished renaming elements"); In the graph we could see that for this action we need: Extract from dimension Connection to dimension ETL is extracting all elements and then searching for joe and replacing it with Martin. ETL project could be downloaded on this link. Other PHP APIs could be found here ....