Security cube visibility with Vertical Layout
Hello all,
We have detected a problem concerning the application of “cube visibility security” and “vertical layout” combined with an “Algorithm”.
Here's a simplified case:
Entity: “Version” with members (Version1; Version2; Version_Final)
Cube: “VERSION-LOCK” dimensioned by Version and with a 1 on “Version_Final”.
Cube: “SALES” dimensioned by Month x Version
On the Security Database part, we have in parameters on “Cube Visibility” of cube “SALES” a locking condition on writing following cube “VERSION-LOCK”.
On a screen, when we display a layout with the configuration :
block a = Cube “SALES” with data entry
block b = Algorithm (equal to a) with reverse dataentry (a=b)
Axes : Month and Version.
And a layout configuration = VERTICAL
The layout allows to make a data entry on algorithm and therefore modify the value of the “SALES” cube, which shouldn't happen as we've blocked the “Database security” setting.
Note that the problem only appears when the layout is in Vertical mode --> when it's in Horizontal mode, blocking input on the algorithm works correctly.
Best regards
Amir ABED