Skip to main content
Solved

Users cannot save cube views in Windows GUI

L
Rookie
Forum|alt.badge.img

We are using the Windows GUI (2 tier). Recently users reported a problem that they cannot save their own created or changed cube views. Users can make the changes and save their cube views with no errors or messages showing, but afterwards the change has not been applied or saved to the IAM database (MS SQL server). As a admin user myself i can save the cube views with no problems as i have more rights on the database itself.

We also recently upgraded our environment from 2023.1 to 2025.1. I suspect this has to do with the change in cube view preferences where cube views are split into cube views and cube view classic preferences. Also a change has been done in the upgrade where public rights have been revoked and assigned to specific roles. 

Our users have the end_user role. I have checked execute rights have been granted on below procedures and the task_delete_usr_pref_classic_cube_view. This is the case.

 

Also the rights on the underlying tabels i have set to inserted, update, delete to see if it makes a difference, but that doesn't help. That should be unnecessary because execute rights on the procedure should suffice.

Does anyone experience the same or have an idea what the problem could be.

Best answer by Mark Jongeling

The fix has been released as hotfix for the affected platform versions. Please note that users do need (at least) End user and Public rights on the IAM database in order to write back user preferences in the 2-tier architecture with Windows GUI. Any application using the Universal GUI is unaffected by this.

View original
    Did this topic help you find an answer to your question?

    E
    Moderator
    Forum|alt.badge.img+17

    If you run the windows gui in developer mode You can get the stored procedure code from the debug menu. 

    If you run the “EXEC set_gui_up_cube_view” from the debugger on the SQL database directly does it then insert the cube view? 

    L
    Rookie
    Forum|alt.badge.img
    • Ling WuRookie
    • Rookie
    • July 8, 2025

    If i as a developer run it, it works. Both in the windows GUI as directly on the database as i am member of the db_owner role. The user is member of end_user (and some root_administration) role. Both experience the same problem that they cannot save or change the cube view preference.

    I have one user who is by accident also member of the db_owner group and he can save the user cube preferences. Unformtunately i cannot or do not have permission to simulate another user on the database or change my own memberships.

    E
    Moderator
    Forum|alt.badge.img+17

    I am able to reproduce this. Can you please report this as a ticket? I will then forward this to our development team for further analysis. As a workaround you can make the user db_owner on the iam database. 

    Mark Jongeling
    Administrator
    Forum|alt.badge.img+23

    We have found an issue that indeed interferes with saving a cube view. It will be addressed and solved as soon as possible.

    "Wake me up before you low-code"
    Mark Jongeling
    Administrator
    Forum|alt.badge.img+23

    The fix has been released as hotfix for the affected platform versions. Please note that users do need (at least) End user and Public rights on the IAM database in order to write back user preferences in the 2-tier architecture with Windows GUI. Any application using the Universal GUI is unaffected by this.

    "Wake me up before you low-code"

    Reply


    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings