Reports and Reporting Components Archives - Page 4 of 4

How to return IP address from the Spreadsheet in Jedox

December 31, 2021June 28, 2023 by Jedox 4 BeginnersNo Comments

Here is the sample of the macro PHP code which can help you to return the IP address of the current server from the spreadsheet. It could be useful when reports contain download functionality which is the source on the server name. So in order not to have a hardcoded server DNS name you could use this funcionality. -------- function temp(){ $localIP = getHostByName(getHostName()); return __msgbox("myComplexVariable=".print_r($localIP , TRUE ), 'Test', 'Info'); } --------...

How to create paging in Jedox?

December 31, 2021November 12, 2023 by Jedox 4 BeginnersNo Comments

When crafting reports in Jedox, it's not uncommon to encounter scenarios where the large volume of rows becomes unwieldy. In such cases, the implementation of paging proves invaluable. Paging not only ensures a clear presentation of the table but also serves to optimize server resources during report access. In the example provided below, we illustrate a two-step approach to introduce a paging solution, leveraging the Jedox BikerBest database. Step 1: Create the Table of Elements The table, presented via Dyna-range, reveals an extensive list of elements that stretches to the bottom, posing navigation challenges. To address this, a subset of Dyna-range is strategically employed to showcase all base elements within the 'Product' dimension. Step 2: Limit the number of rows based on the variables and introduce paging It's common practice to incorporate external variables into the subset. StartPosition - > from which element we want to start [Inital 0]. NumberOfElements -> how many elements we want to see in the table [editable but set on 30 for...

Create slideshow widget in Jedox

December 31, 2021November 12, 2023 by Jedox 4 BeginnersNo Comments

Jedox provides many possibilities when creating a report or a dashboard. Apart from native components like buttons, combo, and checkboxes, lists and dynaranges Jedox allow developers to code their own widgets. One of them could be the slideshow widget. This widget can make your dashboard more interactive and interesting. Widgets in Jedox are coded via HTML and this is how you can create one. For our example, we will use Biker's best database whereas for dimension Product we will add attribute images. Value of attribute is the location of the image behind [ Example /pr/jedox/images/Bikes/Mountain Bikes.png ] Idea is to create an array of elements that could be used in the widget, which will contain: Product Name Product Image Data of selected Measure Measure That we will do with Dynarange and it should look something like this: Since coding behind the widget is a bit complex there will be a project available for download here. To learn more about widgets and what possibilities you can have with them check the...

Creating sudoku in Jedox

December 30, 2021November 12, 2023 by Jedox 4 BeginnersNo Comments

Primarily designed as a planning tool, Jedox offers a wide range of possibilities when it comes to development. If we forget for a second HR, cost center, or some financial consolidation model and let our creative mind flow, we could come to this kind of application. Sudoku is a game that is designed in matrix form where the goal is to fill the cells with numbers from 1 to 9 that are not repeating on any axes. For our little project, we will design a database that will keep scores of users and set up the Sudoku. Dimensions inside will be: User (Copied from System database) Day Version of Sudoku [Easy,Medium,Advanced] Measure [Duration] For the Sudoku setup itself, we would have two dimensions Xaxe and Uaxe. Series of conditional formatting values will be responsible for checking if the numbers are in the correct order. Here you can find the whole project. ...

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

December 30, 2021November 12, 2023 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....

Removing extra space in the Jedox report

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

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

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