Home› User Guide› Wizards

Wizards

Use AnalyticsCreator wizards to collect the inputs needed to create warehouse definitions. Choose a wizard by the object or outcome you need.

When to use this section

Use a wizard overview to understand its inputs and purpose. Follow the linked task guides for the procedure and consult Reference for field descriptions.

Choose a wizard for your task

  • DWH Wizard

    DWH Wizard creates warehouse definitions from selected source metadata. Review its purpose and available settings, then choose the metadata-reading guide for your project.

  • Snapshot transformation wizard

    The Snapshot transformation wizard creates a snapshot dimension for use by analytical structures. Review the overview before selecting the dates and assignments required by your model.

  • Import wizard

    Import wizard collects the source, target, and package settings for an import definition. Review the overview to understand the inputs before creating the definition.

  • Source Wizard

    Source Wizard creates a Source definition within the project. Review the overview and the source settings used to describe the external object.

  • Time transformation wizard

    The Time transformation wizard creates a time dimension for analytical use. Review the period and naming settings before creating the definition.

  • Historization wizard

    Historization wizard collects the input, target, package, and history settings for a new historization definition.

  • Persisting wizard

    Persisting wizard creates a definition for storing the result of a selected input. Review its purpose and the required target settings.

  • Transformation wizard

    Transformation wizard creates a Transformation definition for the selected inputs and transformation type. Review the overview before choosing the creation guide for your task.

  • Calendar transformation wizard

    The Calendar transformation wizard creates a calendar dimension with the required date range and naming settings.

Working in this area

The Wizards in AnalyticsCreator provide a guided and efficient way to perform various tasks related to building and managing a data warehouse. Below is an overview of the eight available wizards and their core functions.

DWH Wizard

The DWH Wizard is designed to quickly create a semi-ready data warehouse. It is especially useful when the data source contains defined table relationships or manually maintained references.

  • Supports multiple architectures: Classic (Kimball), Data Vault 1.0 & 2.0, or mixed.
  • Automatically creates imports, dimensions, facts, hubs, satellites, and links.
  • Customizable field naming, calendar dimensions, and SAP DeltaQ integration.

Source Wizard

The Source Wizard adds new data sources to the repository.

  • Supports source types: Table or Query.
  • Retrieves table relationships and SAP-specific metadata.
  • Allows query testing and schema/table filtering.

Import Wizard

The Import Wizard defines and manages the import of external data into the warehouse.

  • Configures source, target schema, table name, and SSIS package.
  • Allows additional attributes and parameters.

Historization Wizard

The Historization Wizard manages how tables or transformations are historized.

  • Supports SCD types: 0, 1, and 2.
  • Configures empty record behavior and Vault ID usage.
  • Supports SSIS-based or stored procedure historization.

Transformation Wizard

The Transformation Wizard creates and manages data transformations.

  • Supports Regular, Manual, Script, and External transformation types.
  • Handles both historized and non-historized data.
  • Configures joins, fields, persistence, and metadata settings.

Calendar Transformation Wizard

The Calendar Transformation Wizard creates calendar transformations used in reporting and time-based models.

  • Configures schema, name, start/end dates, and date-to-ID macros.
  • Assigns transformations to specific data mart stars.

Time Transformation Wizard

The Time Transformation Wizard creates time dimensions to support time-based analytics.

  • Configures schema, name, time period, and time-to-ID macros.
  • Assigns transformations to specific data mart stars.

Snapshot Transformation Wizard

The Snapshot Transformation Wizard creates snapshot dimensions for snapshot-based analysis.

  • Allows creation of one snapshot dimension per data warehouse.
  • Configures schema, name, and data mart star assignment.

By using these eight wizards, AnalyticsCreator simplifies complex tasks, ensures consistency, and accelerates the creation and management of enterprise data warehouse solutions.