Rename and reorder database items
Make fast, in-context updates to your database and see results immediately, without needing to rebuild it.
User permissions:
Non-administrators: Data > Edit databases
Administrators: Administration > Databases and Sync
If you have the Data > Edit Databases user permission, or Designer 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.
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:
At the bottom of the dimension list, click Edit dimensions.
Click Properties > Edit properties.
Click Measures > Edit measures.
Click Streams > Edit streams.
You can edit all item types from the same menu by selecting the tabs at the top.
Edit database items
Changes apply immediately. Other active users might need to refresh their screens to see updates.
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.
Open the Edit database menu
Select the Dimensions, Properties, Measures, or Streams tab.
Select the item you want to rename.
Enter a new name in the title box.
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.
Open the Edit database menu.
Select the item you want to move.
Drag the Move handle to the new position.
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.
Open the Edit database menu.
Select the Measures tab.
Select the calculated measure.
Update the title and/or expression.
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.
Open the Edit database menu.
Select the Measures tab.
Click the + button next to the search box.
Enter a title.
Define the calculation using existing measures.
Click Save.
The new calculated measure is available in the Measures dropdown menu.
Last updated