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 cycle usually starts with the future months, it is good to mark historical ones. We don’t want some actuals to be overwritten.
There might be a chance that for base elements some of the products are plannable and some not. In order to distinguish, we could create a separate cube [small control cube, product vs year] or we could simply use attribute if it is the general rule. So, here attribute plannable is added for Product dimension.
All the examples are possible to import in your own Jedox instances. Database and report can be downloaded here.