Aggregation issue with dynamic members and security
Summary:
Hi,
We are experiencing an unexpected behaviour from the system.
There are 6 security dimensions, all of them are dynamic and all members aggregate on parents in addition. Data is therefore only stored on level zero members.
Users' access on each element/node is centrally defined by assigned securities on all 6 dimensions.
Under "Settings" functionality, we set "Default Ancestor Access" as Read, to allow users seeing the whole hierarchy with respect to their lower level access.
Problem is, when users with specific view see total amounts and then zoom in on them, the total amount does not equal the some of the zoommed in members.
Tagged:
0