Understanding the fundamental operations in AnalyticsCreator Desktop is essential for efficiently managing your data warehouse repository and ensuring accuracy in your projects. Below are key basic operations you can perform within the interface:

Edit Mode and Saving – Data Warehouse Editor

• Single Object Editing: In the Data Warehouse Repository, you can edit one object at a time. This ensures precision and reduces the risk of unintended changes across multiple objects.
• How to Edit: Double-click on any field within an object to enter edit mode. The selected field becomes editable, allowing you to make modifications.
• Save Prompt: If any changes are made, a prompt will appear, reminding you to save your modifications before exiting the edit mode. This safeguard prevents accidental loss of changes.
• Unsaved Changes: While edits are immediately reflected in the repository interface, they are not permanently saved until explicitly confirmed by clicking the Save button.

Accessing Views in Data Warehouse Explorer

• Layer-Specific Views: Each layer in the data warehouse contains views generated by AnalyticsCreator. These views provide insights into the underlying data structure and transformations applied at that layer.
• How to Access: Navigate to the Data Warehouse Explorer and click on the View tab for the desired layer. This displays the layer’s contents, including tables, fields, and transformations.

Adding and Deleting Objects

Adding New Objects:

1. Navigate to the appropriate section (e.g., Tables, Layers, or Connectors) in the navigation tree.
2. Right-click and select Add [Object Type] to create a new object.
3. Provide the necessary details, such as name, description, and configuration parameters.
4. Save the object.

Deleting Objects:

• Select the object in the navigation tree and right-click to choose Delete.
• Confirm the deletion when prompted.
  ⚠ Note: Deleting an object may affect dependent objects or configurations.

Filtering and Searching in Data Warehouse Explorer

• Filtering: Use filters to narrow down displayed objects by criteria such as name, type, or creation date.
• Searching: Enter keywords or phrases in the search bar to quickly locate objects.
• Benefits: These features enhance repository navigation and efficiency when working with large datasets.

Object Dependencies and Relationships

• Dependency View: For any selected object, view its dependencies and relationships with other objects by accessing the Dependencies tab.
• Impact Analysis: Analyze how changes to one object might affect other parts of the data warehouse.

Managing Scripts

• Predefined Scripts: Add scripts for common operations like data transformations or custom SQL queries.
• Edit and Run: Double-click a script in the navigation tree to modify it. Use Run Script to execute and view results.

Validating and Testing Changes

• Validation Tools: Use built-in tools to check for errors or inconsistencies in your repository.
• Evaluate Changes: Use the Evaluate button before saving or deploying to test functionality and ensure correctness.

Locking and Unlocking Objects

• Locking: Prevent simultaneous edits by locking objects, useful in team environments.
• Unlocking: Release locks once edits are complete to allow further modifications by others.

Exporting and Importing Data

Export:

• Export objects, scripts, or configurations for backup or sharing.
• Use the Export option in the toolbar or navigation tree.

Import:

• Import previously exported files to replicate configurations or restore backups.
• Use the Import option and follow the prompts to load the data.