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...
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...
Warn a user if someone else is editing a designed file they're opening
Because designer files don't auto-save, and multiple users could access it, it's likely people save work overtop of one another changes by accident. It would be good to have a solution to this.
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 ...
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...