AnalyticsCreator Docs
Getting Started User Guide Reference Tutorials Platform Support FAQ

Reference

  • User Interface
    • Toolbar
      • File
      • Sources
      • DWH
      • Data mart
      • ETL
      • Deployment
      • Options
      • Help
    • Navigation tree
      • Connectors
      • Layers
      • Packages
      • Indexes
      • Roles
      • Galaxies
      • Hierarchies
      • Partitions
      • Parameters
      • Macros
      • Object scripts
      • Filters
      • Predefined transformations
      • Snapshots
      • Deployments
      • Groups
      • Models
      • Transformations
    • Dataflow diagram
      • Search
      • Filters
      • Object groups
      • Layers
      • Source
      • Table
      • Transformation
      • Fact
      • Dimension
      • Import
      • Historization
      • Persisting
      • Export
    • Pages
      • Connector
      • Export
      • OLAP Hierarchy
      • Historization
      • Import
      • Index
      • Macro
      • Model Dimension
      • Model Fact
      • Table
      • Object script
      • Package
      • OLAP Partition
      • Persisting
      • Predefined transformation
      • Table reference
      • OLAP role
      • SQL Script
      • Snapshot group
      • Snapshot
      • Source
      • Star
      • Deployment
      • Source refererence
      • Transformation
      • Users in user group
    • Lists
      • Connectors
      • Datamart stars
      • Deploymens
      • Encrypted strings
      • Exports
      • Galaxies
      • Hierarchies
      • Historizations
      • Imports
      • Indexes
      • Layers
      • Macros
      • Models
      • Object group content
      • Object Scripts
      • OLAP roles
      • Packages
      • Parameters
      • Partitions
      • Predefined transformations
      • Schemas
      • Snapshot groups
      • Snapshots
      • Source references
      • Sources
      • SQL Script
      • Table references
      • Tables
      • Transformations
      • User groups
    • Dialogs
      • About
      • DWH settings
      • Error description
      • EULA
      • Input dialog
      • Input dialog with dropbox
      • Open/save in cloud
      • Preview source data
      • Upgrade repository
      • Refresh source metadata
      • Search
      • Tumbnail diagram
      • Source constraints
      • Synchronize DWH
      • Interface settings
      • Login
      • Object groups
    • Wizards
      • Create calendar dimension
      • Create DataVault object
      • Create export
      • Create historization
      • Create import
      • Create snapshot dimension
      • Create source
      • Create time dimension
      • Create transformation
      • DWH wizard
      • Hash keys
      • Persist transformation
      • Run object script
  • Entity types
    • Connector types
      • MSSQL
      • Oracle
      • Excel
      • CSV
      • Access
      • OLEDB
      • SAP
      • ODBC
      • Direct
      • OLEDB.NET
      • Azure BLOB
      • Odata
    • Source types
      • Table
      • Query
      • SAP_DELTAQ
      • SAP_ODP
      • VIEW
    • Table types
      • Import table
      • Historizised table
      • Persisting table
      • Dimension table
      • Externally filled table
      • Fact table
      • DataVault Hub
      • DataVault Link
      • DataVault Satellite
    • Transformation types
      • Regular transformation
      • Manual transformation
      • Script transformation
      • Direct-connector transformation
      • Datamart transformation
      • Union transformation
      • External transformation
    • Transformation historization types
      • FullHist
      • Snapshot
      • SnapshotHist
      • ActualOnly
      • None
    • Join historization types
      • None
      • Actual
      • Full
      • Historical_from
      • Historical_to
    • Package types
      • Import
      • Historization
      • Persisting
      • Workflow
      • Script
      • Exports
      • External
    • SQL Script types
      • Pre-creation
      • Post-creation
      • Pre-workflow
      • Post-workflow
      • Pre-deployment
      • Post-deployment
      • Repository extension
    • Schema types
      • Staging
      • Persisted staging
      • Transformation
      • Core
      • Datamart
  • Entities
    • Layer
    • Schema
    • Connector
    • Source
    • Table
    • Transformation
    • Package
    • Index
    • Partition
    • Hierarchy
    • Macro
    • SQL Script
    • Object script
    • Deployment
      • Table Compression Type
      • Index Compression Type
      • Deployment Do Not Drop Object Types
      • Deployment Create Subdirectory
      • DACPAC Model Storage Type
      • DWH Metadata In Extended Properties
    • Object group
    • Filter
    • Model
  • Parameters
    • Data Vault
      • Vault FK Field Name Pattern
      • Show Hub Deps
      • Data Vault 2 Create Hubs
    • SAP Connector
      • SAP SSIS Custom Function Name
      • SAP AC Custom Function Name
      • SAP Automatic Date Conversion
      • SAP Substitution Date Value
      • SAP Substitution Mindate Value
      • SAP Substitution Maxdate Value
      • SAP P Type Additional Length
      • SAP Deltaq Transfermode
      • SAP Deltaq Autosync
      • SAP Max Record Count
      • SAP Theobald Version
      • SAP Description Language
    • Source Refresh
      • Source Preview Rows
      • Source Preview Timeout
      • Source Refresh Del Missing Sources
      • Source Refresh Refresh Src Desc
      • Source Refresh Refresh Imp Cols
      • Source Refresh Del Missing Imp Cols
      • Source Refresh Refresh PK
      • Source Refresh Refresh Imp Desc
      • Source Refresh Existing Columns
      • Source Refresh References
    • DWH Wizard
      • DWH Wizard Table Name
      • DWH Wizard Imppackagename
      • DWH Wizard Histpackagename
      • DWH Wizard Transname
      • DWH Wizard Dimname
      • DWH Wizard Factname
      • DWH Wizard Tablesperpackage
      • DWH Wizard Hub Packagename
      • DWH Wizard Sat Packagename
      • DWH Wizard Link Packagename
      • DWH Wizard Hub Transname
      • DWH Wizard Sat Transname
      • DWH Wizard Link Transname
      • DWH Wizard Linksat Transname
      • DWH Wizard Hub Table Name
      • DWH Wizard Sat Table Name
      • DWH Wizard Link Table Name
      • DWH Wizard Dwhtype
      • DWH Wizard Snapshot
      • DWH Wizard Calendar
      • DWH Wizard Calendar Transname
      • DWH Wizard Calendar From
      • DWH Wizard Calendar To
      • DWH Wizard Fact
      • DWH Wizard Fact Calendar
      • DWH Wizard Vaultlinksat
      • DWH Wizard Predefined Transformations
      • DWH Wizard SAP Tables
      • DWH Wizard SAP Deltaq
      • DWH Wizard SAP ODP
    • Transformations
      • Transformation Unknown Members
      • Transformation Key Null To Zero
      • Transformation Hist ID Pattern
      • Transformation Calendar Fact Pattern
      • Transformations Createviews
      • Default Calendar Macro
      • Trans Default Use Relations
      • Trans Friendly Names As Column Names
      • Trans Field Alias
      • Trans Column Alias
      • Trans Alias Alias
      • Trans Use No Lock
    • SSIS Packages
      • SSIS Replace Decimal Separator
      • SSIS Command Timeout
      • SSIS Imp Default Buffer Max Rows
      • SSIS Imp Default Buffer Size
      • SSIS Imp Fastload Max Insert Commit Size
      • SSIS Imp Fastload Keep Identity
      • SSIS Imp Fastload Keep Nulls
      • SSIS Imp Fastload Table Lock
      • SSIS Imp Fastload Check Constraints
      • SSIS Imp Fastload Rows Per Batch
      • SSIS Export Default Buffer Max Rows
      • SSIS Export Default Buffer Size
      • SSIS Export Fastload Max Insert Commit Size
      • SSIS Export Fastload Keep Identity
      • SSIS Export Fastload Keep Nulls
      • SSIS Export Fastload Table Lock
      • SSIS Export Fastload Check Constraints
      • SSIS Export Fastload Rows Per Batch
      • SSIS Export Bulk Insert
      • SSIS Hist Default Buffer Max Rows
      • SSIS Hist Default Buffer Size
      • SSIS Hist Fastload Max Insert Commit Size
      • SSIS Hist Fastload Keep Identity
      • SSIS Hist Fastload Keep Nulls
      • SSIS Hist Fastload Table Lock
      • SSIS Hist Fastload Check Constraints
      • SSIS Hist Fastload Rows Per Batch
      • SSIS Delay Connection Validation
      • SSIS Not Store Connection Strings In Package
    • CSV Import
      • CSV Scan Rows
      • CSV Empty String Length
      • CSV Min String Length
    • Synchronization
      • Sync Timeout
      • Synchronize Num Attempts
      • Synchronization Fix Repo
      • Synchronization Renew Relations
      • Synchronization Update Descriptions
      • Synchronization Update Friendly Names
      • Synchronization Update Anonymization
      • Synchronization Update Column Dependencies
      • Synchronization Update Object Groups
      • Synchronization Update OLAP References
      • Synchronization Update Test Cases
      • Synchronization Sync
      • Synchronization Refresh
    • Engine Timeout
      • Objectscript Timeout
    • Deployment
      • Table Compression Type
      • Index Compression Type
      • Deployment Do Not Drop Object Types
      • Deployment Create Subdirectory
      • DACPAC Model Storage Type
      • DWH Metadata In Extended Properties
    • Historization
      • Pers Default Part Switch
      • Hist Default Type
      • Hist Do Not Close
      • Hist Default Use Vaultid
      • Hist Valid To Mode
      • Hist Proc Use Hash Join
      • Hist Proc Use No Lock
      • Persist Num Attempts
      • Persist Pause Between Attempts
      • Persist Use Transactions
      • Hist Empty Record Field Name
    • Diagrams
      • Thumbnail Diagram Show
      • Thumbnail Diagram Width
      • Thumbnail Diagram Height
      • Thumbnail Diagram Left
      • Thumbnail Diagram Top
      • Thumbnail Diagram Dock
      • Thumbnail Diagram Margin
      • Diagram To Picture Scale
    • Governance
      • Force Anonymization Inheritance
      • Force Friendlynames Inheritance
      • Force Display Folder Inheritance
      • Columns Anonymization Types
    • Naming & Metadata
      • Diagram Name Pattern