UI elements
This section documents the primary user interface components of AnalyticsCreator. These elements enable users to configure metadata, manage repository objects, and streamline project automation. The interface is divided into functional areas for configuration and wizard-based workflows.
Configuration
Configuration UI elements are used to manage all structural and logical components of a data warehouse project. This includes creating new metadata objects, editing their properties, and defining system behavior across environments.
Add / Edit Actions
Used to create or modify repository objects. These actions are accessible via toolbar commands, right-click menus, or context panels depending on the selected object.
- Add Schema: Define a new schema under a logical data layer (Staging, EDW, Semantic).
- Add Table / View: Insert new tables or views with full attribute-level metadata definition.
- Add Index: Apply index configuration for performance tuning on physical layers.
- Add Partition: Specify partition keys and ranges for large volume tables.
- Edit Macro: Open reusable macro definitions for modification or review.
- Edit Object Script: Edit custom logic tied to views, stored procedures, or transformations.
- Edit Relationships: Manage foreign key and reference relationships across tables.
List / Manage Actions
These UI panels list metadata objects by category and offer controls to modify, filter, or inspect dependencies.
- List Connectors: Shows all source and target system connections. Supports editing credentials and data source properties.
- List Layers: View logical layers of the solution with access to layer-specific settings and schema configuration.
- List Tables: Browse all defined tables in the model. Supports sorting, filtering, and tagging by system or function.
- List Views: Manage semantic and technical views used in Power BI or transformation logic.
- List Roles: Administer role-based access control at the model or environment level.
- List Dataflows: Display source-to-target transformations and associated ADF mappings.
- Dependency Tree: Visualize object relationships and impact analysis for schema changes.
System Settings & Configuration
System-level configuration defines behavior at the project or deployment level. These settings ensure consistent execution across development, test, and production environments.
- Project Settings: Configure naming conventions, object prefixes, metadata rules, and reusable flags.
- Environment Manager: Define connection profiles for each target environment (e.g., Dev, Test, Prod).
- Runtime Options: Specify SQL dialect, ADF template usage, Fabric SQL compatibility, and version control integration.
- Global Parameters: Declare reusable constants (e.g., load windows, thresholds) across macros and scripts.
- Semantic Model Settings: Control Power BI dataset deployment, relationships, and aggregations.
- Audit Configuration: Activate logging, auditing, and lineage capture for governance and monitoring.