How to Create Cube Data Source in Jet Reports?

Before you can connect 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 from the insightsoftware website.
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:

Open Jet in Excel
In Excel, go to the Jet ribbon and click Settings > Data Source Settings.
Add a New Data Source
In the window that opens, click the Add button.
Set Up the Data Source
- Give your data source a name.
- Select Cube as the data source type.
- Click OK.
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.
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.
Test the Connection
- Click Test Connection.
- If everything is correct, you’ll see Test Connection Succeeded.
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.