> For the complete documentation index, see [llms.txt](https://docs.phocassoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.phocassoftware.com/basics/other-tools/rename-and-reorder-database-items.md). # Rename and reorder database items {% hint style="info" %} User permissions: * Non-administrators: Data > Edit databases * Administrators: Administration > Databases and Sync You also need to have access to all the items in the database. If you have any database restrictions, you won't be able to edit the database. {% endhint %} If you have the required user permissions and database access, you can update a database directly on the page and see the results immediately. You can rename and reorder dimensions, properties, measures, and streams. {% embed url="" %} Rename and reorder database items {% endembed %} With Designer access, you can also edit these items in the database design. However, editing items directly on the page gives you more context and saves time, as you do not need to rebuild the database. You can assign this permission to non-administrative users. This allows them to update database items without accessing the **Administration > Designer** module. ## Open the Edit database menu Use the **Edit database** menu to update dimensions, properties, measures, and streams in one place. When you're in a database, use one of these options: 1. At the bottom of the dimension list, click **Edit dimensions**. 2. Click **Properties** > **Edit properties**. 3. Click **Measures** > **Edit measures**. 4. Click **Streams** > **Edit streams**.

You can edit all item types from the same menu by selecting the tabs at the top.

## Edit database items {% hint style="info" %} Changes apply immediately. Other active users might need to refresh their screens to see updates. {% endhint %} ### Rename an item Rename dimensions, properties, measures, and streams to give them meaningful titles. Some items are locked because they are used in other modules. You cannot rename these items. Avoid using [reserved words and characters](/administration/reserved-words-and-characters.md). 1. Open the **Edit database** menu 2. Select the **Dimensions**, **Properties**, **Measures**, or **Streams** tab. 3. Select the item you want to rename. 4. Enter a new name in the title box. 5. Click **Save**. The change is applied immediately and is visible to all users with access to the database. ### Reorder items Change the order in which items appear in their menus. By default, items follow the order defined in the database design. 1. Open the **Edit database** menu. 2. Select the item you want to move. 3. Drag the **Move** handle to the new position. 4. Click **Save**. The list updates to reflect the new order. ### Create or edit calculated measures In addition to renaming and reordering measures, you can create or edit calculated measures by updating their expressions or defining new ones based on existing data. #### Edit a calculated measure You can update existing calculated measures by editing their expressions. Existing measures display as tags that you can use when modifying expressions. 1. Open the **Edit database** menu. 2. Select the **Measures** tab. 3. Select the calculated measure. 4. Update the title and/or expression. 5. Click **Save**. The updated calculated measure is available in the **Measures** dropdown menu.

#### Create a calculated measure You can also create new calculated measures to show more specific values based on your existing data. 1. Open the **Edit database** menu. 2. Select the **Measures** tab. 3. Click the **+** button next to the search box. 4. Enter a title. 5. Define the calculation using existing measures. 6. Click **Save**. The new calculated measure is available in the **Measures** dropdown menu.

*** ### Troubleshooting **I got a message saying I can't edit the database. Why is that?** To edit a database, you need both the required user permissions and unrestricted access to the database. If you see the message *"You can't edit this database because a dimension, stream, and/or measure is restricted"*, it means your user account has a database restriction applied. For example, you might have access to only specific dimensions, streams, measures, or properties within the database. Even if you have permission to edit databases, you can't edit a database when any restrictions are applied to your account. To resolve this issue: * Ask your administrator to remove the database restrictions from your user account. * Confirm that you have the appropriate permission (see top of this page). If not, ask your administrator to assign them to your user account. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.phocassoftware.com/basics/other-tools/rename-and-reorder-database-items.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.