Jet Data Manager
First Steps
- Migrating Jet Analytics to Cloud Platform
- Add New Fields to a Jet Analytics Project
- Jet Data Manager User Guide
- Deployment and Execution Explained
- Creating Measures, Dimensions, and Cubes
- Conditional Lookups in the JDM
Project Configuration
- Configure Multiple Environments Using the Development Toolkit
- Measure Format Strings
- Object Dependency Setup
- Guarding Tables and Data Sources
- Parameterizing Custom Transformations
- Using Customized Code in the Jet Data Manager
Using the Jet Data Manager
- Using Azure Analysis Services
- Show Data Types on Fields
- SQL Database Cleanup Wizard
- External Business Units
- Using the +1 button
- Date Table
Dimensional Modeling
- Composite Dimension Key Level
- Table Relations and Relationship Types
- Physical Foreign Keys Setup in the JDM
- Advanced Dimensions (NAV 2013 and Newer) with the JDM
- Working with Option Values in the JDM
- Slowly Changing Dimensions (History)
Database Management
- Configuring Multiple Environments
- Migrating Jet Analytics to a New Server
- Enabling Data Warehouse Access through Windows Firewall
- Backing Up a SQL Database
- Locating SQL Server Version
- SQL Server Maximum Memory
Performance Optimization
- Incremental Loading Configuration
- High Availability Cube Processing
- Batch Data Cleansing
- Adding Indexes in the Jet Data Manager
- Table and Index Compression Control
- Data Partitions
Documentation
Execution Packages
- Creating an Execution Package
- Merge Steps property explained
- Default Execution Package
- Execution Logging and Statistics
- Executing External SSIS Packages
- Allow Data Source Failure During Execution