Home› Reference› Entities

Entities

Entities are the concrete objects used in AnalyticsCreator projects. They represent the connectors, sources, schemas, tables, transformations, packages, models, scripts, and supporting objects that make up a generated data warehouse model.

Use this section when you need to understand what a specific object represents and how it fits into modeling, generation, deployment, or execution.

Entity groups

Connector

Represents a connection definition for a source system or external data provider.

  • Stores connection-related metadata
  • Groups source objects under a provider
  • Supports metadata import and source access

Open Connector

Source

Represents a source object that can be imported or used as input for generated warehouse logic.

  • Source tables, views, or queries
  • Input metadata for imports
  • Basis for staging structures

Open Source

Schema

Represents a database schema used to organize generated objects into warehouse layers.

  • Staging and persistent layers
  • Transformation and core layers
  • Datamart structures

Open Schema

Table

Represents a generated or managed table object in the warehouse model.

  • Import and historized tables
  • Persisting tables
  • Fact, dimension, and Data Vault tables

Open Table

Transformation

Represents transformation logic that shapes, combines, or prepares data for downstream use.

  • Generated transformation logic
  • Manual or script-based logic
  • Datamart-facing transformations

Open Transformation

Package

Represents an execution unit used to load, historize, persist, export, or orchestrate data processing.

  • Import and workflow execution
  • Historization and persisting execution
  • Script, export, and external processing

Open Package

Deployment

Represents deployment configuration and output used to move generated artifacts into a target environment.

  • Deployment package settings
  • Generated artifact delivery
  • Environment-specific release behavior

Open Deployment

Model

Represents an analytical model or model-related definition used for reporting-facing structures.

  • Model dimensions and facts
  • Consumption-oriented structures
  • Semantic or analytical organization

Open Model

Layer

Represents a logical warehouse layer used to organize objects by architectural purpose.

  • Source-oriented layers
  • Core transformation layers
  • Consumption layers

Open Layer

Filter

Represents reusable filtering logic that can restrict or shape selected data in a model.

  • Selection conditions
  • Reusable constraints
  • Model-specific filtering behavior

Open Filter

Index

Represents an index definition used to support database performance and generated object behavior.

  • Index metadata
  • Generated database support
  • Performance-oriented configuration

Open Index

Hierarchy

Represents hierarchical relationships used for analytical navigation and structured reporting.

  • Parent-child organization
  • Analytical drill paths
  • Dimension-related structure

Open Hierarchy

Partition

Represents partition-related metadata for analytical or database structures that are split into segments.

  • Partition definitions
  • OLAP or table segmentation
  • Processing and maintenance support

Open Partition

Macro

Represents reusable logic or text that can be applied across generated SQL or model definitions.

  • Reusable expressions
  • Shared generation logic
  • Template-style model support

Open Macro

SQL Script

Represents custom SQL logic that can run during creation, workflow execution, deployment, or repository extension.

  • Creation and deployment scripts
  • Workflow-related scripts
  • Repository extension logic

Open SQL Script

Object Script / Object Group

Represents script logic associated with AnalyticsCreator objects or object-level processing.

  • Object-specific execution
  • Custom processing steps
  • Advanced automation behavior

Open Object script

Object group

Represents a named group of objects used to organize, select, or process related model elements together.

  • Grouped model objects
  • Shared organization
  • Batch-oriented selection support

Open Object group

How to use this section

  • Use Connector, Source, Schema, and Table when reviewing source-to-warehouse structure
  • Use Transformation, Filter, Macro, and SQL Script when reviewing generated or custom logic
  • Use Package, Deployment, and Object Script / Object Group when reviewing execution and release behavior
  • Use Model, Hierarchy, Partition, and Object group when reviewing analytical organization and object grouping

Key takeaway

Entities are the concrete building blocks of an AnalyticsCreator project. They describe the objects that are modeled, generated, deployed, executed, and consumed across the data warehouse lifecycle.