Show Dimension-Name in palo.data-function in web reports
When one is inserting the palo.data-function in Excel, the function shows always the name of each dimension followed by the default element; so the user can easily identify the dimension to change the reference value. By inserting the palo.data-fu...
Translation: use default language in reports if system language not available for reports
Currenty if adding the feature multilanguages we has two possibilities: 1) Using the following formula: =PALO.DATAC(rngDB;"#__Translation";"Name";"1000130";rngLanguage) I translate the text in german and french. My default language is english. If ...
Support Conditional formatting in combination with DynaRanges (Parents below children setting)
Knowledgebase: Calculation of Conditional Formats on Cells covered by a DynaRange using the "Parents below children" setting is currently not fully supported and may lead to unexpected formatting results. As this would be a very helpful feature, w...
Global connections in Administration should be sortable / movable in the order
Since in some areas of Jedox the first available OLAP connection is automatically used - which should not necessarily be the main connection - there may be problems in displaying and calling these components. Therefore, there should be the possibi...
Beside selecting a date from the datepicker, the input field should also be filled manually without selecting from the datepicker. So the user can choose if he wants to select the date from the datepicker or if he wants to enter the date manually....
The rule editor is very powerful but hard to understand from a business user point of view. The user interface could be improved in terms of usability and structure.
A grouping of rules in a folder structure would help a lot here rather than havi...
In many reports I need to consider date intervals. for example beginning is
2012-11 and end is 2015-03
Calendar is
- All Years
- Year
- Quar.
- Month
So a macro calculates all needed Elements:
- 2011-11, 2011-12, 2012, 2013, 2014, 2015-Q1
This is...
In most BI Solutions there is a monitoring implemented that enables administrators to see the usage (e.g. clicks) on reports, starts of ETL-Jobs etc. It is highly suggested by BARC to do BI on BI by identifying unused reports to eliminate/hide the...
Since Jedox 2018.4 its possible to use labels. This is quite useful to layout a report since you dont have to stick to a grid of the spreadsheet (e.g. figures in tiles). But for some reason its not possible to interact or attach a macro to a label...