---
title: Snippets Setup (Formally Business Functions)
description: "#### Overview Snippets contain predefined calculations that can be used in projects. This article explains the steps required to download and install them into the [Jet Data Manager](https://globaldata365.com/jet-data-manager-training/). You will also see how one would use them within a project…"
url: "https://globaldata365.com/helpcenter/snippets-setup-formally-business-functions/"
updated: "2026-10-25"
category: Jet Analytics
tags:
  - jet analytics
  - Jet data manager
---

# Snippets Setup (Formally Business Functions)

#### Overview

Snippets contain predefined calculations that can be used in projects. This article explains the steps required to download and install them into the [Jet Data Manager](https://globaldata365.com/jet-data-manager-training/). You will also see how one would use them within a project and how to view the results.

 

### **Download Snippets**

 

**1.** To download them, go to the [insightsoftware download page](https://insightsoftware.com/downloads).

 

**2.**Click **Download Jet Analytics**.

 

**3.**Once your download has completed, navigate to the** Jet Analytics - REQUIRED**folder.

![snippets](https://globaldata365.com/wp-content/uploads/2023/06/image-42.png)

Export the Snippet Library XML to a location on your machine.

![snippets](https://globaldata365.com/wp-content/uploads/2023/06/image-44.png)

 

### **Installing Snippets**

 

**1.**Open the Jet Data Manager and Navigate to the **Tools **Tab → **Snippets.**

![snippets](https://globaldata365.com/wp-content/uploads/2023/06/1.png)

**2.**In the[Server](https://globaldata365.com/helpcenter/server-hardware-sizing-recommendations/) windows, click on the **Import **in the lower left-hand corner.

![Jet Data Manager Server](https://globaldata365.com/wp-content/uploads/2023/06/image-45.png)

**3.**Locate the Snippet Library XML file and click **Open**.

![](https://globaldata365.com/wp-content/uploads/2023/06/image-44.png)

**4.**Locate the Snippet Library XML file and click **Open**.

![Jet Data Manager Server](https://globaldata365.com/wp-content/uploads/2023/06/image-46.png)

**5.**Once back at the window, you should see your imported Snippets. Click **Close**.

![Jet Data Manager Server](https://globaldata365.com/wp-content/uploads/2023/06/image-47.png)

 **Want to turn raw ERP data into powerful business insights?**
[👉 Join our Jet Analytics Training](https://globaldata365.com/jet-analytics-training/) and master building data warehouses, cubes, and advanced dashboards.

## **Using a Snippet**

 

Each Snippet is used differently depending on the application. For example, there are Snippets that calculate percentages, time periods, inventory etc. Particular use of it will depend on the needs and requirements of the business.

In this example we will create a Snippet that returns the sum for a given period.

 

**1.**In the Cubes tab, navigate to the cube you would like to add your Snippet to → Right Click **Measures** → **Add Snippet** → **Time** → **Periods to Date (XTD)**

![snippets](https://globaldata365.com/wp-content/uploads/2023/06/image-49.png)

**2.**The** Measure Dialog** will open. Provide a name in the Name field.

In the description box you can explain what the business function does.

![Jet Data Manager Server](https://globaldata365.com/wp-content/uploads/2023/06/image-50.png)

**3)**In the **Format String **field add **#,#. **This will round to the nearest whole number.

![](https://globaldata365.com/wp-content/uploads/2023/06/image-53.png)

 Entering #,#.00 will format your string to add 2 decimals.

 

**4.**In the **Associated Measure Group **choose the measure group that the business function will belong to. In this example we will choose **Sales Posted Transactions **.

![snippets](https://globaldata365.com/wp-content/uploads/2023/06/image-52.png)

**5.**In the Parameters section under the **Value **field select your **Hierarchy ****Level****.** In this example we will select **Year **because we want to look at the quantity by month. Next Select your Measure. In this example select **Sales. **Click **OK **to save your changes.

![snippets](https://globaldata365.com/wp-content/uploads/2023/06/image-54.png)

**6.**Deploy and execute your cube to put the changes into effect.

 

### **Viewing the Results in Excel**

 

Open a connection to your cube. In this example we will connect to the **Sales **Cube. Under the Posted Sales Transaction measure group select **Sales **and **Sales YTD.**

![](https://globaldata365.com/wp-content/uploads/2023/06/image-55.png)

Next, we will select our dimensions. Select **Posting** **Date.Date YQMD **and **by Line Type**.

![](https://globaldata365.com/wp-content/uploads/2023/06/image-56.png)

Finally, you can view Sales and Sales YTD by Posting Date and Line Type.

![](https://globaldata365.com/wp-content/uploads/2023/06/1-4.png)

#### If You Need Any Help, [Contact us](https://globaldata365.com/contact/) Now!

###### Still have Questions?

Ask us anything about this article – we’ll get backto you shortly.