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....
Jedox spreedshets are powerfull place for your analysis. Since it is based on Excel funcionality some side effects can occure as well. One of this sideeffects is extra space in the report which cause higher memory usage.
It could be identified if the report size is unusally high and performance while opening is extremelly low. (Example 250kb.)
In order to fix it and decrease the size / increase the performance you will need to do the following set of actions:
Click on the row under which it is nothing developed. (In this case 30th)
Select A30:IV65356 and hit ENTER
Delete all selected lines
Tadaaaa!!!
the new report is now of the proper size.
More about Jedox Reports....
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 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...
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 ....
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...
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...
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...
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.