AnalyticsCreator Docs
User Guide Reference Tutorials Platform Support FAQ
Menu
  • User Guide
  • Reference
  • Tutorials
  • Platform Support
  • FAQ

User Guide

  • Getting Started
    • Quick Start Guide
      • Your first Data Warehouse
      • Set up or choose your SQL Server
      • Connect to SQL Server and prepare Northwind
      • Install AnalyticsCreator and start your data warehouse
      • Connect Northwind and build the model
      • Generate your warehouse, pipeline and Power BI project
      • Deploy
      • Explore your results in Power BI (optional)
    • Understanding AnalyticsCreator
    • Installation
    • System Requirements
    • Download and Installation
      • Launch AnalyticsCreator
    • Configuring AnalyticsCreator
  • Desktop Interface
  • Working with AnalyticsCreator
    • Using DWH Wizard
      • Read metadata from a Connector with DWH Wizard
      • Use existing Source metadata with DWH Wizard
    • Connectors
      • Configure a Microsoft SQL Server (MSSQL) Connector
      • Configure an Oracle Connector
      • Configure a CSV Connector
      • Configure an Excel Connector
      • Configure an SAP Connector
      • Configure an OData Connector
      • Configure a Direct Connector
      • Configure an OLEDB Connector
      • Configure an ODBC Connector
    • Historization
      • Create a historization with Historization Wizard
      • Configure historization columns, filters, variables, and scripts
      • How to set up historization using the DWH Wizard
    • Transformations
      • Create and save a Regular transformation
      • Create and save a Manual transformation
      • Create a Macro and use it in a Transformation statement
      • Create a calendar dimension
      • Choose a Transformation historization type and assign snapshots
      • Apply a Predefined transformation rule
      • Assign an existing Transformation to a datamart star
      • How to manage dependencies
      • How to manage dependencies
      • How to create a union transformation
      • Using calendar macro in transformation
    • Persisting
      • Create a persisting definition
      • Add persisting content and choose a replacement strategy
    • Export
      • Create an export definition with Export Wizard
      • Review export mappings, target clearing, filters, and scripts
    • Layers and Schemas
      • Manage schemas and their layer assignments
      • Layer sequence number
    • Partitions
      • Create an OLAP partition
      • Configure an existing OLAP partition
    • Macros
      • Create a reusable Macro
      • Call a Macro from another Macro
    • Scripts
      • Create a lifecycle script and prepare a Script transformation example
    • Hierarchies
      • Create and configure an OLAP hierarchy
    • Indexes
      • Create and configure a table index
      • Configure table names, columns, primary keys, and Identity
    • Table and Column Properties
      • Add a calculated column to a table
      • Inspect column dependencies
    • Datamart
      • Configure measures for an analytical table
      • Configure friendly names and OLAP export settings
      • Define OLAP table references and many-to-many cardinality
      • Define a Tabular OLAP DAX calculated column
    • Object Groups
      • Add objects to an object group
      • Create and manage object groups
    • Deployment
      • Configure and save a deployment package definition
    • Interface
      • Find an object on the diagram
      • Apply, store, and reuse diagram filters
      • How to scale the interface using Ctrl+Mousewheel
    • User Groups
      • Create a user group and manage membership
    • Save and Load
      • Save and load a Data Warehouse (DWH) project folder
      • Use with Git
      • How to save and load a project to the cloud
    • Interface Appearance
      • Change interface appearance and colors
    • DWH Settings
      • Change common Data Warehouse (DWH) naming settings
    • Source References
      • Add a source reference
      • Simple references, Complex references, Reference statement
    • Data Vault
      • Add or refresh hash keys
      • How to create a Data Vault model using the DWH Wizard
      • How to create Hubs using the Vault Wizard
      • How to create Satellites using the Vault Wizard
      • How to create Links and Link Satellites using the Vault Wizard
    • Meta-Connector
      • How to create meta-connector
      • How to load and use meta-connector
    • Sources
      • How to add a new source using the DWH Wizard
      • How to add a new table source using the Source Wizard
      • How to add a new query source using the Source Wizard
      • How to define many CSV files or subdirectories as one data source
      • How to define many Excel files/subdirectories as one data source
    • Import
      • How to import data using the DWH Wizard
      • How to import data using the Import Wizard
      • variables, filters, Pre- and PostScripts and so on
    • Encrypted Strings
      • How to use encrypted strings in connectors
    • Parameters
      • How to change parameters
    • Table References
      • How to add table references
      • Simple references, Complex references, Reference statement
    • Test cases
      • Run a test case and inspect differences
  • Advanced Features
  • Wizards
    • DWH Wizard
    • Snapshot transformation wizard
    • Import wizard