Editing a Data Store

Edit an existing Data Store to update its configurations, fields, or query. The editing process may vary based on the Data Source category (e.g., RDBMS, API).

Prerequisites:

• You have access to the Data Center → Data Stores.

• You have permission to view/edit the target Data Store.

Steps to Edit a Data Store

1. Navigate to the Data Stores List Go to Data Center → Data Stores.

2. Select the Data Store From the list, select the Data Store you wish to edit.

3. Enter Edit Mode Click the View/Edit icon next to the Data Store. Result: The selected Data Store opens in editable format.

4. Edit Data Store Details

   • Modify fields or configurations as required:

     • Name

     • Description

     • SQL query

     • Dimensions, Measures, Time fields

     • Data Type Definitions

     • Hierarchy settings

   • Next: Click Next to proceed through the steps for editing.

5. Complete Configuration

   • Continue editing details in subsequent steps (e.g., Data Restrictions, Schedule Refresh).

   • Review all configuration pages until the final step.

6. Finish Editing Once you’ve completed the required changes, click Finish. Result: A confirmation message appears, and the selected Data Store is updated.

Important Notes & Tips:

• The steps required to create/edit a Data Store may vary depending on the Data Source (e.g., RDBMS, API, File).

• Validation Required for Database Data Stores: For Database-based Data Stores, ensure to validate the query and fields before saving.

• Validate early: For RDBMS-based Data Stores, always click Validate after editing the query or structure to ensure it runs correctly.

• Step-by-step editing: Don’t skip over any intermediate steps like Dimensions, Measures, or Time—they affect your data model.

Troubleshooting

• Save button disabled: Ensure you've completed all required fields in the current step and validated the data for Database-based Data Stores.

• Unexpected changes after save: Recheck previous steps for missing field changes or unsaved modifications.

• Query not working: If the query fails during validation, check for syntax errors, missing fields, or incorrect data types.