Error "The external data source does not support OVER expressions" when creating a calculated column using external data in Spotfire

book

Article ID: KB0070623

calendar_today

Updated On:

Products	Versions
Spotfire Connectors	All

Description

While creating a calculated column from a data table which is being populated through a connector, OVER functionality can not be used inside a calculated column if the data table is kept as external (In-Database). The following is the error message generated.

Error: The external data source does not support OVER expressions.

User-added image

Environment

All

Resolution

When working with connectors and keeping the data table external, you have to write OVER expressions as post-aggregation expressions (which uses the THEN keyword). Example:

Custom Expression Example: Avg([Customer_ID]) THEN Avg([Value]) OVER (All([Axis.X]))

Issue/Introduction

When using external (In-Database) data with Spotfire Connectors, you get the error "The external data source does not support OVER expressions" when creating a calculated column. For this to work, you must use a post-aggregation expression using the THEN keyword.

Additional Information

Using Expressions on Aggregated Data (Spotfire Analysts User's Guide)
- https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=ncfe%2Fncfe_using_expressions_on_aggregated_data_the_then_keyword.htm
Working with In-Database Data (Spotfire Analysts User's Guide)
- https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_working_with_in-database_data.htm

Feedback

thumb_up Yes

thumb_down No

Welcome to "KB Articles"