Jet from insightsoftware

Connecting Power BI to OLAP Cubes
Connecting Power BI to OLAP Cubes Moderate Overview When using Power BI Desktop, it is possible to develop reports against your Jet Enterprise OLAP Cubes. This article outlines the steps required to connect to your Cubes through Power BI and what the various settings represent. This article assumes that you have the Power BI Desktop application installed. If this is incorr...
Configuring SMTP Settings in Jet Hub
Configuring SMTP Settings in Jet Hub Requires Administrator Access & Knowledge Overview Email notifications can be sent from several locations within Jet Hub. To use this feature, your organization's email system must support SMTP (Simplified Mail Transfer Protocol), and a system administrator must configure Jet Hub with the specific settings for that email system. Configuring Basic A...
Protecting a Pivot Table
Protecting a Pivot Table Overview In some circumstances an organization will want to restrict users from being able to change a pivot table based report.  This will include preventing things such as adding additional filters, slicers, fields, or changing the order of certain things in the report. They do, however, still want their users to be able to refresh the report and use existing filt...
Automatically Refresh Pivot Table Upon Opening
Automatically Refresh Pivot Table Upon Opening Overview Some users will want reports that contain pivot tables to be automatically refreshed and updated when the report itself is opened. This functionality exists natively in Excel and can be turn on by following the instructions below. Process First, the user should open the Excel file to be refreshed automatically.  Once ...
Changing the OLAP Locale Identifier in Excel to See Other Language Translations
Changing the OLAP Locale Identifier in Excel to See Other Language Translations Overview This article details the process of enabling translations from an OLAP server. Please Note: Excel does not use Windows locale settings when retrieving translations from an OLAP server, but instead uses the installation language for Office. This can be overridden on a single connection by sp...
Jet Basics Application Settings
Jet Basics Application SettingsJet Basics Help Topics... Overview The Application Settings are user preferences and other application-wide settings that affect the behavior of the Jet Basics add-in. General User Interface Language The Jet user interface language. Lookup Sample Value Limit The maximum number of sample values that will be retrieved when perform...
App Settings (Application Settings)
App Settings (Application Settings)Related Articles... Overview The App Settings are user preferences and other application-wide settings that affect the behavior of the Jet Excel add-in. General User Interface Language The supported language used in the Jet user interface (Czech, Danish, Dutch, English, Finnish, French, German, Greek, Hungarian, Icelan...
Batch Function Execution Optimization
Batch Function Execution Optimization Overview Jet Reports includes the Enable Batch Function Execution option. Background Certain Jet Reports functions are referred to as "Replicating" functions. The most common of these is the NL("Rows") function.  This function makes copies of itself (and everything else on that row) as it expands through the data it returns. I...
First Page
Back
For an optimal Community experience, Please view on Desktop