Jet from insightsoftware

Configure Multiple Environments Using the Development Toolkit
Configure Multiple Environments Using the Development Toolkit Overview A dedicated development environment enables developers to make project changes without affecting the production project. Once the project changes are tested and approved they can be easily transferred to the production environment. A development environment has several advantages: Less system downtime ...
Measure Format Strings
Measure Format Strings Overview To help with setting up format strings on measures, the Jet Data Manager presents a drop-down list for selecting measure format options. Process By default, the Jet Data Manager provides four formatting options: #,# #,0.00 0.00% #,0.00;(#,0.00) If other format strings are used in the project,...
Object Dependency Setup
Object Dependency Setup Overview When using managed thread execution the JDM will automatically prioritize when an object is ready to be executed. The execution order is calculated based on dependencies.  The JDM uses a dependency algorithm that considers the following structures in the project: Relations between tables (type Warning and Error) Conditional Lookup Fields ...
Guarding Tables and Data Sources
Guarding Tables and Data Sources Overview In the Jet Data Manager, it is possible to guard data sources and tables so that they will not be deployed and/or executed when the normal deployment and execution of the project is done. This can be useful in cases where the data in the table needs to be preserved. Examples include tables used to import data from Excel through the...
Parameterizing Custom Transformations
Parameterizing Custom Transformations Overview Parameters are now available for use in Custom Fields within a project.  Parameters closely coincide with other objects within the project.  For example, if there is a field named Sales Amount that is used in a custom field that is not a parameter, the custom field will cause an error if the Sales Amount field is renamed to someth...
Using Customized Code in the Jet Data Manager
Using Customized Code in the Jet Data Manager Overview The Jet Data Manager enables users to integrate "hand-written" code into a project by customizing the data cleansing procedure, transformation view and SSIS package on a given table. This gives the user the flexibility of traditional data warehouse coding together with the immense productivity-boost of Data Warehouse Automation. ...
Managing CData Providers
Managing CData Providers Moderate The Jet Data Manager can connect to a wide variety of data sources through CDATA connectors .  This article will outline how to add and manage CData connectors in the Jet Data Manager. Add a new provider To open the CData providers window go to Tools, then select Manage CData Providers. Once the window opens, c...
Dynamic Data Selection Rules
Dynamic Data Selection Rules Expert Overview This article will go over how to create a Dynamic Data Selection Rule using a Project Variable. Please see our KB on Project Variables for more information and how to create them here . In this example we will be showing you how to create a Dynamic Data Selection Rule for Posting Date in the Value Entry tab...
Configure the Record Load Date on History-enabled Tables
Configure the Record Load Date on History-enabled Tables Overview When history is enabled for a table, Jet Analytics keeps track of when a certain instance of a table is valid. (In previous versions, Jet Analytics would always assume that the first instance of a record had “always” been the valid record – or at least since 1900-01-01, which would be set as the “valid from” date. Th...
Data Tagging
Data Tagging To comply with regulations such as the General Data Protection Regulation (GDPR) you need to know your data and, more specifically, need to be able to categorize your data. Jet Data Manager enables you to tag individual fields, they can then be used in project perspectives or in data impact documentation, which it shows you where fields with selected tags are...
Constraint Suggestions in the Jet Data Manager
Constraint Suggestions in the Jet Data Manager Overview Adding primary keys and relations to tables in a project enables Jet Data Manager to check primary and foreign key constraints to maintain data integrity. Sometimes information about the tables’ primary keys and relations can be found as metadata in the data source and read by Jet Data Manager. Process Constraint suggest...
Using Partial Deployment in Multiple Environment Transfer
Using Partial Deployment in Multiple Environment Transfer This Expert-Level process should only be attempted by experienced administrators This information applies to Jet Analytics 2016 and higher Overview When using multiple environments, you can use the Multiple Environments feature of Jet Analytics to deploy only specific parts of a project in a differen...
Guarding OLAP Cubes
Guarding OLAP Cubes This feature is *not* compatible with High Availability Cubes nor when performing a full deploy. Contact insightsoftware Technical Support for assistance. With this feature, you can prevent deployment and execution of specific cubes or dimensions. To prevent deployment and execution of an OLAP object: select Guard on the ...
Creating OLAP Snippets
Creating OLAP Snippets Overview OLAP Snippets are utilized to create a single snippet of MDX code that can be parameterized and reused throughout the project. Multidimensional Expressions (MDX) is a query syntax used specifically for querying and extracting data from OLAP cubes. Users can create their own OLAP Snippets in addition to using the OLAP Snippets provided by Jet Reports that...
Entering and Exporting Translations
Entering and Exporting Translations Overview The Jet Data Manager supports the input of multiple display languages.  These display languages can be used by front-end tools to display captions in the user's language.  In order for these display languages to be used they must be entered into the project.  This article details the process of entering these translations and then exporting the t...
Changing the Cube Date Format
Changing the Cube Date Format Overview The projects that are available for download from the CubeStore have a default date format set in the cubes of "MM/DD/YY". This can be easily changed in the project to accommodate various regional preferences. Process To alter the default date format, change the Date table in the staging database. The table will have a clock icon next to...
Null Processing Property
Null Processing Property Overview The Null Processing property specifies which action Analysis Services takes when it encounters a Null value. Process The NullProcessing Property on Measures can now be changed from the Edit Measure dialogue: The possible Null Processing settings are: Setting Description Automatic (Default) Null values...
Custom OLAP Drill Through Actions
Custom OLAP Drill Through Actions Overview Drill through actions are very useful when the end users want to see the details behind the numbers in a pivot table. The default drill through action that can be used in Excel shows only measure fields and dimension key fields. In a drill through action the user can select exactly what information that should be displayed and in which order. ...
Renaming the "Unknown" Member
Renaming the "Unknown" Member Overview When Analysis Services processes a dimension, it attempts to match each dimension foreign key in the fact table with the corresponding dimension member's primary key in the dimension table. When no join exists (eg., when a value exists in the fact table but not in the dimension table) then Analysis Services will use "Unknown" in its place. The "...
Special Characters in Jet Analytics
Special Characters in Jet Analytics Overview For databases that use special characters (e.g., Asian characters) it will be necessary to make modifications to the standard Jet Analytics project in order for the characters to be displayed properly in the data warehouse and staging databases. Setting up the Assembly and Function Copy the following...
Configure Multiple Environments Manually
Configure Multiple Environments Manually Overview A Development Environment enables users to work within non-production environments. This is useful when an organization needs to ensure that the production environment is always available for end users. For example, the organization could have an environment called “ development ” where changes are made, dimensions are up...
First Page
Back
For an optimal Community experience, Please view on Desktop