Adding a Data Source for Formulas

Learn how to create more flexible reports without having to use table-based structures.
December 27, 2023


Adding data sources for formulas in your workbook enables you to generate versatile and well-formatted reports, enhancing tables with calculations or designing layouts that depart from the typical table-based structure. However, when adding a data source for formulas, no table is inserted in the sheet. Instead, you’ll find an optimized formula panel displaying the data source name, data source alias, and filter area, without the builder panel with rows and columns.

Add a Data Source


Select a cell in the Excel sheet.


Click Add Data Source for Formulas in the Designer panel.


You could also choose Add Function > Add Data Source for Formulas – found within the Excel ribbon.


In the pop-up, choose the connection for where your data source is located.


Choose a folder from the list and then choose a model.


Click Open to insert the data source for formulas.


You could also use the search field to find a particular model.


The GETDATA formula is automatically placed within the cell you initially selected in step 1 based on the chosen data source.


An alias is automatically assigned to the data source you just inserted (DS_1).  Subsequent data sources added will also be assigned an alias (e.g., DS_2, DS_3, etc.).

Designer Panel

You can use the Designer Panel to view the data source’s name, alias, as well as the applied filter(s).


If you include more than one data source, you can use the drop-down menu to view and select each data source.

Please refer to the article on how to work with filters to learn how to define which subset of data will appear within the analysis.

Additional Options

Once the data source has been added, you can perform additional actions, including:

  • Changing formula definition (e.g., adding additional formula arguments)
  • Adding other formulas
  • Removing a data source for formulas

Learning Path

Enroll Today!

This learning path would be a great starting place if you want to learn more about the topics covered in this article.

Learning Path Thumbnail


Next Article


Previous Article

See What's New

Featured Articles

Our most recent and proudest works, ready to make your life a little bit easier.

SAP Analytics Cloud

SAC Key Features & Capabilities

Let’s learn about the key features and capabilities of SAP Analytics Cloud.


Creating a Space

Spaces are the areas where all data is retrieved, prepared and modeled. This article will walk you through creating a space in Datasphere.

SAP Analytics Cloud

Adding a Table (Datasphere Dataset)

Learn how to insert a table based on an existing SAP Datasphere dataset.

Curated For You

Article Recommendations

Here are some articles handpicked by our experts to help you continue your learning journey.

SAP Analytics Cloud

Adding a Table (SAP Analytics Cloud Model)

Learn how to insert a table based on an existing SAC model.

SAP Analytics Cloud

Getting and Installing the Add-in

Learn how to install the SAC Add-in for MS Office.

SAP Analytics Cloud

Tables Overview

Learn the basics about how data is displayed as tables in the SAC Add-in for MS Office.

Contact Us

Reach out if you have any questions or to see how we can create a custom training solution for your organization!

Contact Form Pop-Up - General Use

Custom Training Solution

Fill out and submit the form below, and we’ll reach out to you to discuss how we can work toward achieving your training goals in a way that works best for you and your team.

Contact Form - Custom Training