How to create a top 10 list of a certain dimension?

How to create a top 10 list of a certain dimension?

by Jedox 4 BeginnersNo Comments
The crucial part of every dashboard is the top 10 list analysis. Many companies would like to see what are their best-selling products, best performing months, or perhaps top 10 customers. Like other reporting tools, Jedox has a specific way to deal with it. So in order to achieve that we will use subsets. There are 3 segments to pay attention to: PALO.DATA - to create top 10 of anything we need to decide which data need to be sorted PALO.SORT - to sort data based on the value PALO.HIERARCHY to select only base level The last step is in the General tab to select Layout - Flat In the end, the report should like something like this: More on segments of the Palo subset can be found here. Report with an example can be downloaded here....
Read More
Slowly Changing Dimensions

Slowly Changing Dimensions

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...
Read More
How to rename elements from Jedox ETL?

How to rename elements from Jedox ETL?

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 ....
Read More
Hide panel from the side when logging to Jedox.

Hide panel from the side when logging to Jedox.

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...
Read More
Conditional formatting in Jedox

Conditional formatting in Jedox

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...
Read More
How to create a model in Jedox?

How to create a model in Jedox?

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