PALO.EPARENT and PALO.ELEVEL relative to specific root element (parallel hierarchies)
PALO.EPARENT and PALO.ELEVEL work well if you have only 1 hierarchy within a dimension.
But if you have more than one hierarchy it would be great to give a certain root element as parameter and get the parent and or the level in exactly this sp...
Macro Events: AfterPaloUpdate to start a macro after Dynarange-Update
Macros assigned to filter-comboboxes (to set dynarange-variables) are executed BEFORE data is updated.
A function similar to __open() that is triggered after palo-data has been changed, e.g. in dynaranges, would allow macro-treatment of the ne...
This would be great to be able to deactivate filters in Extracts. For instance, Extract cube, I have 3 rows, and I want to remove the 2nd temporarily. At the present time I have to delete it, I would like to be able to deactivate it only.
Sometimes you have very granular rights for users in place or bug reports which need to be tested from the users perspective. Since you don't know their password you have to copy their groups into a test user first and log-in with the test user. T...
Loads with insertParallel on sub-trees (boundaries)
If one uses a load with insertParallel mode, the ETL will unconsolidate duplicates of elements in every Top-Element. This behavior is documented but not always wanted - sometimes you only want to load a certain Top Element (Tree) to be loaded with...
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...
Abstract: User rights on OLAP objects in a database should not be influenced by user groups that are disabled for this database. Case: As you probably know one can limit user rights to certain databases via cube System/#_GROUP_DATABASE_DATA. A use...