Home › Manage Objects › Common Operations › List

List

List Metadata Components

This page list all object types managed within the AnalyticsCreator repository. Each list represents a category of metadata used to define, build, deploy, and govern your Data warehouse. These components are organized to support a metadata-driven, scalable architecture that follows best practices in dimensional modeling and automation.

ID List actions Description
1 List Connectors Define reusable connections to external systems (e.g., SQL Server, SAP, REST). Used for Sources.
2 List Sources Register physical data sources such as tables or views. Each source is tied to a connector and describes its external schema.
3 List Source References Establish relationships between source tables. These are inherited into DWH tables during synchronization.
4 List Packages Organize ETL tasks into packages such as Import, Historization, Persisting, Script, or Workflow. Each handles specific automation steps.
5 List Indexes Define database indexes on DWH tables to optimize read performance during querying and reporting.
6 List Roles Define user access rights for stars and dimensions, enabling row-level security in semantic models or OLAP cubes.
7 List Galaxies Logical containers that group related stars (subject areas). Galaxies reflect enterprise-level domains in a conformed model.
8 List Stars Star schemas that contain fact and dimension relationships. Each star maps to a data mart and can generate a cube or tabular model.
9 List Hierarchies Define parent-child relationships within dimensions (e.g., Country > Region > City). Used for drilling in reports.
10 List Partitions Partition large fact or dimension tables by keys (e.g., Date, Region) to improve performance and manageability.
11 List Parameters Global settings or toggles used in transformations, scripts, and deployments. Parameters help generalize logic across environments.
12 List Macros Reusable code blocks written in T-SQL or SSIS. Macros support placeholders like :1, :2 for dynamic substitution.
13 List Pre-Creation Scripts SQL code executed before DWH table creation. Often used to prepare the environment or drop old objects.
14 List Post-Creation Scripts Scripts executed after table creation. Used to add indexes, constraints, or metadata auditing.
15 List Pre-Deployment Scripts SQL logic that runs before a deployment begins. Useful for staging or validation setup.
16 List Post-Deployment Scripts Scripts executed after deployment completion. Often used for verification, logging, or downstream triggers.
17 List Pre-Workflow Scripts Logic executed before the main workflow package runs. Can be used for precondition checks or cleanup.
18 List Post-Workflow Scripts Executed after workflow execution finishes. Ideal for finalization tasks or audit trail logging.
19 List Repository Extension Scripts Direct modifications to the repository metadata structure, used with caution for advanced use cases.
20 List Object Scripts Scripts bound to individual metadata objects (e.g., rename fields in bulk). Helps automate repeatable logic.
21 List Predefined Transformations Common transformations applied automatically based on data type (e.g., trimming VARCHAR fields).
22 List Snapshots Define time-stamped checkpoints used for historization, slowly changing facts, or temporal analysis.
23 List Snapshot Groups Logical grouping of multiple snapshots to support versioning or multi-date analysis logic.
24 List Deployments Manage deployment configurations for different environments. Includes options for DACPAC generation and build output.
25 List Groups [create page] Logical folders to organize objects for better navigation, execution control, and project structuring.
26 List Objects [create page] Unified view of all metadata objects in the repository. Use this to browse or search across object types.
27 List Models Dimensional models made of facts and dimensions. Models define semantic layers for Power BI or Fabric Tabular.