Jet from insightsoftware

Using Azure Analysis Services
Using Azure Analysis ServicesPrerequisites Create an Analysis Services Resource in Azure Create an App Registration Assign the App Registration as Analysis Services Admin Add Semantic Model Endpoint Enable use with Azure SQL Managed Instance Provide Users Access to the Model Prerequisites If you created your own application server (not from the Azure Marketplace Template), t...
Show Data Types on Fields
Show Data Types on Fields Overview You can show the data type of fields in the project tree, which can be useful in many cases. Process To enable this, click on View menu in the toolbar in the ribbon, and then click on Data Types ensuring that the check appears next to it. You will receive a message that states that the project tree needs to be refreshed after you turn ...
SQL Database Cleanup Wizard
SQL Database Cleanup Wizard Overview To prevent accidental data loss, deleting a table in project within the Jet Data Manager does not delete the physical table in the SQL Server database.  The downside is that tables deleted in the JDM application will still take up space in the database.  A tool has been added in Jet Enterprise 2016 to provide the ability to identify tables left behind by...
External Business Units
External Business Units Overview External Business Units can be added to a project that allows objects from another project in the repository to be added to the current project.  This can be very useful when it is desirable to maintain separate projects from a development perspective but the need exists to ultimately combine everything into a single project. A common example would be...
Using the +1 button
Using the +1 button Overview When adding a new table to your project, you typically want to add a number of fields. To quickly add several fields without having to repetitiously click, you can take advantage of the +1 button. Clicking the +1 button will commit the current field and clear the dialog window so that another field can immediately be created. The +1 button exists on a ...
Date Table
Date Table Overview Within the Jet Data Manager a user can change the default date settings to reflect the needs of the organization. How-To Video Changing the Default Date Settings This video demonstrates how to access and change the default date settings Process To edit an existing date table right-click on the table and click Edit Date Table and follow t...
Adding NAV/Business Central Extension (SIFT) Tables
Adding NAV/Business Central Extension (SIFT) Tables This article will outline how to add Dynamics NAV/Business Central extension tables to a Jet Data Manager project. In your Business Unit right-click on your NAV or Business Central data source and select Edit Dynamics Business Central (NAV) Adapter . Check the box next to the Read Aggregation Tables - SIFT ...
Supernatural Keys
Supernatural Keys The information applies to Jet Data Manager 17.12 and higher Overview In dimensional modeling it can be very useful to have a durable supernatural key for each record. In contrast to natural keys that come from the source system a supernatural key is stable over time and can be the same for records from different sources (ex. if you have customers in multiple system...
Changing the name of a data source table
Changing the name of a data source table Scenario In certain situations, it may be necessary to use a different table from your source database but to still maintain all customization's applied within the staging database.  This assumes that you've already begun building a project that uses one table for it's data, but that you need the source of this table to be from a different ...
Setting up Proxy Connectivity in Jet Analytics
Setting up Proxy Connectivity in Jet Analytics Proxy settings can be configured for Jet Analytics web traffic. In some locked-down server environments all web traffic must pass through a proxy server.  With the proliferation of web-based data sources, more of our customers are likely to be using proxy servers.  This also works for the connection to the license server which makes it po...
Using SQL and Business Function (OLAP) Snippets
Using SQL and Business Function (OLAP) Snippets Overview In the Jet Data Manager, you can create commonly used pieces of SQL code and parameterize them as SQL Snippets.  This allows frequently used pieces of functionality to be saved once and then easily deployed across different tables or fields without recreating all of the SQL functionality. SQL Snippets can be used with: ...
Feature Deprecation in the Jet Data Manager
Feature Deprecation in the Jet Data Manager Overview Over time, some features in the Jet Data Manager will have lived out their usefulness and continue to exist in the product solely for backwards compatibility.  While backwards compatibility is a high priority for us, developing and testing for outdated features takes time that we could otherwise spend on new useful features.  For this...
Using SQL Snippets - JDM 2016.1 and earlier
Using SQL Snippets - JDM 2016.1 and earlier This information refers to Jet Data Manager version 2016 and earlier. For current versions of the JDM, see How to Use SQL and Business Function (OLAP) Snippets Overview In the Jet Data Manager you can create commonly used pieces of SQL code and parameterize them as SQL Snippets. This allows frequently used pieces of functional...
Reuse Data Source Selections
Reuse Data Source Selections Overview The process of selecting tables and fields from at data source, adding primary keys, and setting up incremental load can be a time-consuming task. Selection templates contain information about the selected tables and fields, primary keys, incremental selection rules and incrementally loaded tables on a data source.  They are exported as XML files ...
Simple Mode
Simple Mode Overview Jet Data Manager is a powerful tool that can transform and validate data any way you like.  Sometimes, however, you just need to get data copied into the staging database 1:1 as quickly as possible and all of those features are not required.  For situations like these we have created Simple Mode which is optimized for speed. When using it, all advanced feature...
Replicating Data Sources
Replicating Data Sources Overview Replicate Data Sources allows a user to easily connect multiple data sources that have an identical data structure.  After the data sources have been connected, the user can then add fields or tables, and these changes will be incorporated across all of the data sources that have been enabled as a template data source. Enabling Replicate Data Sources ...
Limit Concurrent Transfers on Data Sources
Limit Concurrent Transfers on Data Sources Overview It is possible to put a limit on the number of concurrent transfers from a specific data source. Some data sources can only handle a certain number of connections before adding more connections will actually slow down the overall performance of the transfer rather than speed it up. This setting enables you to prevent the execution engine i...
Project Variables
Project Variables Overview Project variables allow a user to save information in project-wide variables for use in custom transformations, scripts actions, custom views, customized code and selection rules. For example, this feature can be used to set up an environment specific selection rule that limits the amount of data loaded for testing purposes in a development environment, while all d...
Table Visualization in the Jet Data Manager
Table Visualization in the Jet Data Manager Overview The existing Trace Up and Trace Down feature has been improved to give the user better results. As a result of this the feature now provides everything that would be expected for Data Lineage and Impact Analysis and the feature has been renamed accordingly. The Data Lineage trace can answer the question about where the content ...
Project Perspectives in Jet Analytics
Project Perspectives in Jet Analytics Overview The purpose of Project Perspectives is to make it easier to work with large projects. Working in one big project can make it hard to maintain a good overview and find an individual object quickly. The idea is that a user can create different perspectives on a project. A perspective is a subset of the objects within the project that relat...
Using the Jet Analytics Query Tool
Using the Jet Analytics Query Tool Overview The Query Tool is a powerful supplement to the Preview Table feature of the Jet Data Manager that gives the user more flexibility in exploring the content of a table. This allows the user to execute any SQL query to see the data the way that they wish to see it. As the Query Tool can be used with ANY DATABASE, extreme care should be t...
Renaming Measure Groups
Renaming Measure Groups The name of the measure group is displayed in the front end, but the default names can be renamed using the Jet Data Manager. Rename Measure Groups 1. Right-click a cube, and select Edit Cube 2. Specify a new name for the measure group that you want to rename. Click OK . 3. Deploy and execute the cube 4. Verify the chang...
Synchronize and Override Data Types
Synchronize and Override Data Types Overview When using the Jet Data Manager to connect a data source to a pre-built Data Warehouse structure or change a data source connection, some of the data types might not match up.  This can result in errors during execution or data being truncated / left out of the data warehouse table. Note: Extreme care should be taken in over...
NAV Advanced Dimension Editor
NAV Advanced Dimension Editor Overview The Advanced Dimension Editor for Dynamics NAV data sources allows users to quickly and easily incorporate any number of NAV Advanced Dimensions into their project. This functionality will automatically add the necessary tables, create links between tables, and add the dimensions to the OLAP cubes. Note: The Advanced Dimension Editor will only work ...
Display Unused Fields
Display Unused Fields Overview The Jet Data Manager has the ability to display all unused fields in the project. This feature is useful to remove unnecessary objects from the project to decrease clutter and improve performance. Note that this feature does not impact which fields are available for reporting purposes. How to Display Unused Fields 1. From the Data ...
Browsing Cubes in the Jet Data Manager
Browsing Cubes in the Jet Data Manager Overview The Cube Browser (while not meant to replace a full-featured front-end tool such as Excel) provides both a graphical interface and enhanced usability options that provide an easy way to browse the cube structure without having to navigate away from the Jet Data Manager. How to Launch the Cube Browser Locate the cube that will...
Legacy Transformations
Legacy Transformations Overview Modern versions of the Jet Data Manager use Set Based Transformations . Should you need to use Scalar-Valued User Defined Functions , the following demonstrates how to enable this legacy feature. Process Right click on a table and select Advanced → Advanced Settings → Performance Check the box to use Legacy Transfo...
Adding Custom Views In Jet Analytics
Adding Custom Views In Jet Analytics Overview There will be certain cases where it will be desirable to create a custom SQL view to be used in either the staging database or the data warehouse. This article will outline the steps needed to add the custom view into the Jet Data Manager Process First, the desired SELECT statement for the view must be created.  This will most com...
Enabling and Using Team Development
Enabling and Using Team Development Overview The Jet Data Manager offers functionality that supports multiple users working on a project concurrently. Without this functionality only one user at a time can be in the project. In addition, features have been added to allow more detailed tracking of changes through the use of Version Notes and functionality to allow other members of the team t...
Using Field Validations in the Jet Data Manager
Using Field Validations in the Jet Data Manager Overview The Jet Data Manager has built-in functionality that allows users to validate data as it comes over from the data source. This will allow the user to see which records in the source database are not conforming to applicable business rules and allows the users the option of whether these records should be flagged for further review...
First Page
Back
For an optimal Community experience, Please view on Desktop