Skip to main content
Skip table of contents

DATA

Basic Overview

Description

Reference a DataTable directly from the operation. The result contains all values from the DataTable.

An optional Unit can be supplied. If no Unit is supplied, the resulting Unit of the function is the columnMetaUnit set on the measure. If none is set, 'Any' is assumed as a Unit.

Signature

DATA(DataSourceNameTableNameMeasureName [, Unit ])

Parameters

  • DataSourceName: Name of the ExternalDataSource in double quotes (e.g. "Model Data")
  • TableName: Name of the DataTable in double quotes (e.g. "Gross_Sales"). If data source is an Excel Workbook, it is the sheet name.
  • MeasureName: Name of the measure DataTableColumn in double quotes (e.g. "Price")
  • Unit: Name of the Unit or ratio combination of two units. Each Unit name is wrapped in single quotes and the full Unit then in double quotes (e.g. "'EUR'" or "'EUR'/'Case'")

Using the connect data button at the formula ribbon, you can now select the data you want to use using a drop-down menu of all your available data sources. 

Example

Assuming the following Excel Workbook has been uploaded to the System in a Data Source with name "Example", and the Example dimensions have been imported.

(See Example Excel Sheets for Downloads)

The function:

DATA("Example","UploadExampleNormal","Volume") will lead to the following data. (The order may differ)

ExampleProductExampleChannelYearVolume
Product AOnline201810
Product BOffline201820
Product AOnline201940
Product BOffline201930




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.