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.
