October 2015 - Jedox for beginners

Locked Dimensions and Cubes

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

Technically speaking this is not a bug but a feature of Jedox software. Jedox has the possibility to lock a specific area of the cube in order to disable additional data entering. The majority of the time users click on this functionality by accident and then owners of the application break the head what went wrong. When the cube is locked, elements cannot be added or deleted. Etls cannot run import as well. The error usually displays the following message "M_EL1 - dimension is locked: dimension is used in a locked cube" One reason for the error could be the Hold functionality is triggered by the user as follows: A similar thing is with Enable Undo functionality as well. Both of this information could be found in modeler under Cube properties. Once both of the actions are released, an error will not appear anymore. After that users could continue adding the data or working on the architecture of the database. In case you try...

Slowly Changing Dimensions

October 5, 2015November 9, 2023 by Jedox 4 Beginners Comment Closed

Slowly Changing Dimensions are a recurring topic in Business Intelligence and Data Warehousing in general. Theterm describes the unpredictable change of dimensions over the life-cycle of a data model and the approachesused to capture and document historical data for future reference. Before: After: There are 4 ways to deal with them: Dimension Update Parallel Hierarchies Split information over different dimensions Attribute/Control Cube Dimension Update (Slowly Changing Dimensions) The first approach is the so-called “Update” approach. As the word “Update” suggests, this approach removes theold structure and replaces it with the new one. This approach has proven to be efficient, in the case when no historicalcomparison is required. The latest structural changes should simply be displayed in the respective dimension. Parallel Hierarchies (Slowly Changing Dimensions) An approach to preserve historical structures and information is to create so-called “parallel hierarchies”. Herebythe new structure is created under a new consolidated element in the respective dimension.Attention should be paid to how many parallel hierarchies are being set up as this method can quickly “clog” thedimensions...

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

Hide panel from the side when logging to Jedox.

October 5, 2015January 19, 2022 by Jedox 4 Beginners1 Comment

When we log in Jedox for the first time, we could see that on the left side panel is open by default. This is very usefull because developers of the application and other users with higher role could publish reports. On the other hand if the user is just a planner or a viewer he/she might get confused with the meaning of that panel. Most of the time customers do not even want to allow the users to see anything else except the report. So if you would like this panel to be hidden by default, the following setting needs to be applied to #_USER_USER_PROPERTIES cube. In case you are not sure where this cube can be found -> it is in the System database. Code to apply {"studio":{"reports":{"nav":{"width":350,"hidden":true}},"palo":{"nav":{"hidden":false,"width":350}},"etl":{"nav":{"width":350}},"home":{"view":"list"},"files":{"view":"thumbs","nav":{"width":350,"hidden":true}}}} After applying this setting when the user logs in for the first time* panel should be hidden. Hidden panel In order to apply this to all users, a simple ETL could be built which would input...

Conditional formatting in Jedox

October 5, 2015November 12, 2023 by Jedox 4 BeginnersNo Comments

The majority of reports developed in Jedox for analysis purposes use the tabular format. It is the easiest way to display the data and detect patterns. Like in Excel, Jedox can provide conditional formatting functionality. Since most of the users are familiar with the concept of conditional formatting, here are some examples of how you could combine it with some Jedox formulas. Fo the ones who are not please check the following link here. In the first example, we are going to show you how to format every second row. For this purpose, we will use the excel function ROW() and then detect if the row number is odd or even number. In the second example, we will show you how to color only base elements. Usually, this type of formatting is used when Bottom-UP planning is performed. Sometimes users would like to see MAX and MIN value elements in the same row. An example of that can be found below. Since the planning...

How to create a model in Jedox?

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

Jedox introduced the possibility to create a model from 2017. Many predefined models could be also downloaded from the Marketplace. Here we are going to show how to create one. "Models are predefined applications, consisting of files/reports, OLAP databases, Integrator jobs, scheduled tasks, and settings." That saying, models are logical unities that allow users to differentiate between applications. When the model is created following folders are predefined in Jedox: Integrator area folder Report Designer folder Reports folder The database could be created on its own. Below you can see how Jedox academy explains installation. In order to create a model, we need first to check our license. It is important that your license allows creating modes. Usually, you could see it in Administrations -> Licences - >Jedox Model Developer. In case you don't have it, then Create New model would not be visible]. If in case you have the license this is the place to start. Model Settings The name needs to contain the prefix com.jedox without any capital or irregular characters. More...