---
title: How to Create Cube Data Source in Jet Reports?
description: "Before you can connect [Jet Reports](https://globaldata365.com/jet-reports/) to your Cube data, make sure you have everything ready. Here’s a quick step-by-step guide to get you started with creating cube data source in jet reports!   ### **What You Need First** Before…"
url: "https://globaldata365.com/helpcenter/how-to-create-cube-data-source-in-jet-reports/"
updated: "2026-07-01"
category: Jet Reports
---

# How to Create Cube Data Source in Jet Reports?

Before you can connect [Jet Reports](https://globaldata365.com/jet-reports/) to your Cube data, make sure you have everything ready. Here’s a quick step-by-step guide to get you started with creating cube data source in jet reports!

 

### **What You Need First**

Before diving in, ensure you have the following:

- **Jet Excel Add-In**
  Download and[install the Jet Excel Add-in](https://globaldata365.com/helpcenter/how-to-install-jet-reports-excel-add-in/) from the [insightsoftware website](https://insightsoftware.com/).
- **OLAP Cube Database**
  Your Cube database must already be created using Jet Data Manager. If you don’t have it yet, ask your system admin.
- **Login Access**
  You’ll need permission to access the Cube database.
- **Jet License Activation Code**
  Make sure your license includes the Universal Connector.
- **Database Info**
  Have your server name or IP address and database name handy.

 

### **How to Connect Jet Reports to Your Cube Data**

Let’s walk through the process in simple steps to create cube data source in jet reports:

1. **Open Jet in Excel**
   In Excel, go to the Jet ribbon and click Settings > Data Source Settings. ![create cube data source in jet reports](https://globaldata365.com/wp-content/uploads/2025/07/1-300x105.webp)
2. **Add a New Data Source**
   In the window that opens, click the **Add** button. ![create cube data source in jet reports](https://globaldata365.com/wp-content/uploads/2025/07/2-300x75.webp)
3. **Set Up the Data Source**

   - Give your data source a name.
   - Select **Cube** as the data source type.
   - Click **OK**. ![add data source as cube](https://globaldata365.com/wp-content/uploads/2025/07/3-300x282.webp)
4. **Choose Your Login Method**

   - On the **Authentication** tab, select how Jet will log in to the Cube.
   - If your current Windows login has access, choose **Current User**.
   - If you need to log in with another account, you'll need to set up an **Internet-Based connection**. ![](https://globaldata365.com/wp-content/uploads/2025/07/4-300x298.webp)
5. **Enter Connection Details**

   - Go to the **Connection** tab.
   - Enter your **server name** where the OLAP database is hosted.
   - Use the dropdown to select your **database name**.
   - If the database doesn't show up, your login might not have permission. Check with your admin. ![select data source settings](https://globaldata365.com/wp-content/uploads/2025/07/5-300x298.webp)
6. **Test the Connection**

   - Click **Test Connection**.
   - If everything is correct, you’ll see **Test Connection Succeeded**. ![test connection for data source](https://globaldata365.com/wp-content/uploads/2025/07/6-300x73.webp)
7. **Save and Set Default (Optional)**

   - Click **OK** to save your settings.
   - If you want to use this connection every time by default, click **Set Default**. ![](https://globaldata365.com/wp-content/uploads/2025/07/7-300x36.webp)

 **Looking to simplify financial reporting in Excel?**
[👉 Join our Jet Reports Training](https://globaldata365.com/jet-reports-training-austin-tx/) and learn to create real-time, dynamic reports with confidence.

### **Start Using Your Cube Data**

Once your Cube [data source](https://globaldata365.com/helpcenter/create-an-azure-sql-data-source-in-jet-reports/) is set up, you’ll see the Pivot Table button available in the Jet ribbon.

You’re now ready to start building reports directly from your [OLAP Cube](https://globaldata365.com/helpcenter/how-to-connect-power-bi-with-olap-cubes/) using Jet Reports!

 

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