PALO.DATA.SOURCE Identify rule-based values/cells
Function to identify, if a value is calculated or stored in the database.
This enables dynamic reports where a conditional formatting opens cells for data entry ONLY if they are actually stored an...
Add paging in reports for Legal Entities (including the ones listed for workflow)
Sometimes, there are many Legal Entities at customers, paging function would be needed in reports: "Scope of consolidation", "Data collection", "Consolidation Manager", "Consolidated Financial Statement".
When using a Cell Reference (range) in an Action, for example as source for some value, this range reference will not be automatically updated if the cell is moved (e.g. if a row or column is inserted). The user has to update the cell references m...
Jedox provides a set of icons which can be utilized in Web report cells using the SHOWPICT() function. However, these icons can not directly be used on form elements; they can also not be inserted as "floating" images in a report. The user would h...
Hatched fillings for bar charts would allow distinguishing between scenarios without relying on a chart legend or different colors. The IBCS also recommends this. It is also a functionality provided in Excel and it would enrich Web Reporting.
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 ...
It would be helpful, if one can duplicate user roles in Jedox. Thus, it is easy to create new roles with just a few adjustments by using existing roles as templates.