Mastering Jedox Cell Locking: 5 Methods for Data Protection

Mastering Jedox Cell Locking: 5 Methods for Data Protection

Introduction In this guide, we'll explore five methods to automate cell locking and unlocking, catering to both manual and dynamic scenarios. Whether it's manual intervention, central control, or dependency on specific parameters, Jedox offers versatile solutions to meet your data protection needs. Let's start. Manual Lock and Unlock: Empowering Users with Control Learn how to manually lock and unlock cells directly from the spreadsheet interface, giving users immediate control over data access and modification permissions. Central Control Button: Streamlining Administrative Oversight Discover the central control button feature, enabling administrators to swiftly lock cells across reports, ensuring data integrity and enforcing security policies. By creating a central setting element, we can access this value from any other report section or control dashboard. In this example, we will keep it on the same page. Automatic Lock Based on Time Parameters: Explore the functionality to automatically lock cells based on time parameters such as month, day, or hour. By setting predefined schedules, ensure data confidentiality and prevent unauthorized modifications...
Read More
Locked Dimensions and Cubes

Locked Dimensions and Cubes

Technically speaking this is not a bug but a feature of Jedox software. Jedox has the possibility to lock a specific area of the cube in order to disable additional data entering. The majority of the time users click on this functionality by accident and then owners of the application break the head what went wrong. When the cube is locked, elements cannot be added or deleted. Etls cannot run import as well. The error usually displays the following message "M_EL1 - dimension is locked: dimension is used in a locked cube" One reason for the error could be the Hold functionality is triggered by the user as follows: A similar thing is with Enable Undo functionality as well. Both of this information could be found in modeler under Cube properties. Once both of the actions are released, an error will not appear anymore. After that users could continue adding the data or working on the architecture of the database. In case you try...
Read More