Secured Dimensions
The Secured Dimensions tab enables you to change the secured setting for the Version and any custom dimensions. When a dimension is secure, the administrator can restrict access to its data on a user by user basis.
The Unit dimension is a secured dimension by default and cannot be changed.
Each additional secured dimension can impact application performance.
These are the options:
| Option | Description |
|---|---|
| CPM Model | List of CPM models. |
| Database Owner User ID | Shows the user ID of the database owner. |
| Database Owner Password | Specify the password for the database owner. |
| Connect | Connect to the selected model. |
| Disconnect | Disconnect from the model. |
| Save | Save any changes. |
| Refresh | Refresh the page to the last saved state. |
| Create SQL Script | Click to create a script. After the script is created, click Download to download the script to a location you select. The script is named model name_ModelChangeSecuredDimensions_database type.sql. For example: CTrain_ModelChangeSecuredDimensions_Oracle.sql or CTrain_ModelChangeSecuredDimensions_SqlServer.sql |
| Dimension | Shows the dimension name. |
| Setting | Select Secured or Unsecured. |
| Description | Shows a message indicating the state of the dimension. |