Display No Access to non access elements instead of #Value
When we setup a security at dimension level, some users are set as N to prevent an access. In report spreadsheet, the element is displayed in a single cell (not using dynarange). But when non eligible user open the report, the particular element t...
in #_GROUP_DIMENSION_ cube this is really complex to know what is the right for a certain group since it can be inherited from upper levels, for instance:
Europe N
West
France R
this would be great to be able to see that, say using a "flag" t...
Currently rules are calculated in the moment when the user queries the data.
It would be great to have the option to shift the timing to the point when the user changes data. So the result of the calculation would be stored/persisted when the use...
Hi Jedox team,
currently we only have a comment section to add additional information to a rule.
But especially for automated processing of rules via ETL it would be great to be able to mark/flag certain rules in a more structured way.
In the fi...
If a user is restricted by #_GROUP_DIMENSION_DATA_* to a specific area he will usually get a #VALUE error for everything else (in Web as well as Excel). Sometimes it would be more beneficial to treat these #VALUE errors as 0s, so that the user exp...
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...