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 "f...
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 u...
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...