User Guide

Build your first Data Warehouse with Northwind, from SQL Server preparation to generated loading files and results.

Understand how repository metadata drives warehouse modeling, generation, deployment and execution.

Review operating system, network and SQL Server requirements before installing AnalyticsCreator.

Configure repository storage and SQL Server authentication, with optional backup paths and proxy settings.

Find editing, navigation and project management features, with links to interface settings and project save/load guides.

Read source metadata or reuse stored Source definitions, then review the warehouse objects to generate.

Configure connection settings for your source technology, then check and save the Connector definition.

Create historization definitions and review column policies, filters, variables and scripts for the required record history.

Create Regular or Manual transformations and configure expressions, dimensions, snapshots and datamart assignments.

Create a persisting definition, add its content and choose the replacement behavior required for the target data.

Create export definitions and review column mappings, target clearing, filters and scripts before execution.

Create schemas, assign them to warehouse layers and review layer sequence numbers and saved assignments.

Create and maintain OLAP partitions, reviewing their analytical tables, configuration and saved settings before downstream processing.

Define reusable Macros, specify expressions and arguments, and check calls between Macros.

Create lifecycle scripts and prepare the configuration for a Script transformation example.

Create an OLAP hierarchy and review its analytical table, columns and level order.

Configure table indexes and review the table names, columns, primary keys and Identity settings that support them.

Add calculated column expressions and inspect column dependencies before changing definitions or downstream use.

Configure datamart measures, friendly names, OLAP export settings, table references and DAX calculated columns.

Create and maintain named object groups, then assign project objects and review group membership.

Configure and save a deployment package definition for the intended target environment before running a deployment.

Find objects, apply and reuse diagram filters, and adjust the interface scale with Ctrl+Mousewheel.

Create user groups, maintain member assignments and verify the saved membership and rights.

Save and load project folders, work with Git, or use AnalyticsCreator cloud storage for saved repositories.

Adjust diagram, navigation tree, page and color settings, then check their effect on the interface.

Review and change common service-field names, then check project definitions affected by the naming changes.

Define relationships between Sources by selecting the related Sources, mapping their columns and saving the reference.

Create Data Vault definitions with DWH Wizard or Vault Wizard, and add or refresh hash keys.

Create or load Source definitions from connector metadata, then select and classify them in DWH Wizard.

Create table or query Sources, or configure an existing CSV or Excel Source to use matching files.

Create import definitions and packages, then configure field mappings, row filters, variables and scripts before execution.

Create encrypted-string entries and use their aliases in connector connection strings, then test and save the connection.

Change a parameter’s Custom value and verify the saved setting for the workflows that use it.

Create or maintain table references by reviewing table endpoints, matching conditions, relationship settings and affected transformations.

Run a configured test case, compare actual output with expected data, and inspect differences and logs.

Explore scripts, historization, parameters and Macros for customizing warehouse behavior.

Create warehouse definitions from source metadata, using a Connector or existing Source definitions.

Create a snapshot dimension and review its schema, name and datamart assignments.

Define an import by selecting the source, target table and package settings.

Add a Source definition from a table or query and review its metadata settings.

Create a time dimension with a chosen interval, naming settings and time-to-key mapping.

Choose source, target, package and history settings for a new historization definition.

Create a definition to store a transformation result in a table, with target and package settings.

Create a Transformation definition by choosing its type, input tables and configuration settings.

Create a calendar dimension with a date range, naming settings and datamart assignments.