User security and cubeview performance
I am trying to troubleshoot a performance issue when running cubeviews as a non-admin.
If a user is not in the "Administrators" group, then a simple cubeview might take a lot longer than it wou...
Forum Discussion
Sliced security should only be used if needed. That's the reason, you can control it by entity.
Another possibility is error messages. They can consume a lot of time.
If you have some row and column calculations that are creating error messages, it can slow down the cubeview a lot, e.g. when the cubeview tries to multiply "No Access" with 1.5. Then it writes an error message to every cell of the cubeview where the error occurs. But if you have suppress enable, the cubeview doesn't even show the error messages. But the cubeview is slow anyway.
My cubeviews aren't generating errors in the cells.
They are consuming a massive amount of memory on the app servers, however. Perhaps thrashing is slowing things down, but I would think that affects each user the same (whether admin or not).
The cubeviews are executed indirectly via REST->DashboardAdapter->BR->FDX