TIBCO Streaming is a comprehensive platform for developing and deploying real-time streaming analytics applications. The platform's core components are TIBCO StreamBase Server, the high-performance runtime engine that executes the streaming logic; TIBCO StreamBase Studio, an Eclipse-based integrated development environment (IDE) for building, debugging, and testing applications; and TIBCO LiveView Server, which provides a real-time, push-based data mart and dashboarding system for visualizing and interacting with the streaming data. These three products are bundled together to form the TIBCO Streaming platform.

A. TIBCO Spotfire Server: This is a separate TIBCO product for advanced data visualization and analytics. While it can integrate with TIBCO Streaming, it is not an included component of the TIBCO Streaming installation.

1. TIBCO Streaming 10.6.1 Documentation

Overview Guide

Chapter 1

"Introduction to TIBCO Streaming": This chapter explicitly describes the main components. It states

"TIBCO Streaming is a platform for building systems that analyze and act on streaming data. At its core is the TIBCO StreamBase Server... You develop applications for the server in TIBCO StreamBase Studio... TIBCO LiveView is a component of TIBCO Streaming that provides a real-time

push-based data warehouse and dashboarding system."

2. TIBCO Streaming 10.6.1 Documentation

Installation Guide

Chapter 2

"TIBCO Streaming Product Files": This section details the directory structure created by the installer

which includes distinct top-level directories for streambase (containing the server)

liveview (containing its server)

and studio

confirming they are the primary installed components.

3. TIBCO Streaming 10.6.1 Documentation

What Is TIBCO Streaming? page: The introductory page states

"TIBCO Streaming is the full-featured

enterprise-grade TIBCO solution for streaming analytics... TIBCO Streaming includes TIBCO StreamBase®

TIBCO LiveView™

and the TIBCO® Artifact Management Server." This confirms StreamBase and LiveView are the foundational product lines within the TIBCO Streaming offering.

In TIBCO Spotfire, functions that integrate with TIBCO Enterprise Runtime for R (TERR) are located within the "Statistical functions" category in the expression editor. This category houses functions for advanced analytics, such as correlation, regression models, and direct script execution via functions like TERRInteger, TERRReal, TERRString, and TERRBoolean. These functions allow users to embed R code directly into Spotfire expressions to perform complex statistical computations that are not available in other standard function categories.

A. Logical functions: This category contains functions for conditional logic and boolean operations (e.g., If(), Case(), And(), Or()), not for statistical computations using the TERR engine.

C. Math functions: This category includes basic arithmetic, trigonometric, and logarithmic functions (e.g., Abs(), Sin(), Log10()), which are distinct from the advanced statistical capabilities provided by TERR.

D. Binning functions: This category is dedicated to functions that group continuous data into discrete intervals or bins (e.g., BinByEvenIntervals()), a data preparation task unrelated to TERR's statistical engine.

1. TIBCO Spotfire® Analyst User's Guide (Version 12.0.3

March 2023): In the chapter "Working with Expressions"

the section "Functions" lists the available function categories. The "Statistical functions" category is described as containing functions for statistical calculations

and it explicitly lists the TERR functions (TERRBoolean

TERRInteger

etc.) as part of this group. (See section on "Statistical functions" within the Functions list).

2. TIBCO Spotfire® - A Comprehensive Primer (Second Edition) by B.S. Nandakumar (ISBN: 978-0128134910): While a book and not direct vendor documentation

it is authored by a TIBCO employee and serves as a de facto official guide. Chapter 7

"Advanced Analytics

" details the integration with TERR and shows examples where TERR functions are accessed from the "Statistical Functions" category in the Custom Expression dialog.

3. Official TIBCO Spotfire Documentation Portal: The online help for TIBCO Spotfire explicitly categorizes all TERR functions under "Statistical Functions". For example

the documentation page for the TERRReal function states its category is "Statistical". (Accessible via help.spotfire.com

navigating to the Functions reference for any recent version).

R is officially defined as a language and environment specifically designed for statistical computing and graphics. It is an integrated suite of software facilities for data manipulation, calculation, and graphical display. It includes a collection of tools for a wide variety of statistical techniques (such as linear and nonlinear modeling, classical statistical tests, time-series analysis, classification, and clustering) and advanced graphical capabilities. This specialization in statistical analysis is its core identity and primary purpose.

A. This describes HyperText Markup Language (HTML), the standard markup language for creating web pages and web applications.

B. This describes JavaScript, which is the most well-known implementation of the ECMAScript specification and is primarily used for client-side web development.

C. While R is an interpreted, high-level language, describing it as "general-purpose" is less accurate. Its design and ecosystem are heavily optimized for statistical analysis, not general application development.

1. The R Foundation. "What is R?". The R Project for Statistical Computing. Accessed October 26

2023. The official project website states in its opening sentence: "R is a language and environment for statistical computing and graphics."

2. TIBCO Software Inc. TIBCO® Enterprise Runtime for R - Language Reference

Version 1.7

September 2022. "Introduction

" p. 10. The document introduces the language by stating

"The R language is a programming language and environment for statistical computing and graphics."

3. Ihaka

R.

& Gentleman

R. (1996). "R: A Language for Data Analysis and Graphics." Journal of Computational and Graphical Statistics

5(3)

299-314. The abstract of the seminal paper by R's creators states: "We have implemented a language which is very similar to S... The new language

called R

is the basis for a data analysis system and a graphics environment." DOI: 10.2307/1390807.

The Pivot transformation in TIBCO Spotfire is used to restructure a data table from a "tall/narrow" format to a "wide/short" format. It accomplishes this by taking the unique values from a single categorical column and converting them into multiple new columns. The values for these new columns are populated from a separate value column, often using an aggregation method. This process effectively pivots data from a row-oriented structure to a column-oriented one.

B. Pivots column values into rows of data: This describes the function of the Unpivot transformation, which is the inverse of Pivot, converting a wide data format into a tall one.

C. Pivots row values to eliminate duplicates: While aggregation during a pivot can handle multiple values for a given intersection, the primary purpose is data restructuring, not duplicate elimination.

D. Pivots column values to summarize correlated data: This is an overly general and imprecise description. The core function of Pivot is a specific structural transformation, not just general summarization.

1. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Pivoting data" section: "Pivoting is a way to turn data from a 'tall/narrow' format to a 'wide/short' format. It is done by turning the unique values in one column into multiple new columns."

2. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Details on Pivot Data" dialog: This section details the configuration

requiring the user to specify "Columns to pass through"

"Column to pivot"

and "Columns to transfer and aggregate with"

confirming the mechanism of turning row values into new columns.

3. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Unpivoting data" section: "Unpivoting is a way to turn data from a 'wide/short' format to a 'tall/narrow' format... This can be seen as the reverse of a pivot transformation." This reference explicitly contrasts the two functions

confirming why option B is incorrect.

The "Input field" is the specific property control type in TIBCO Spotfire designed to add a text box to a Text Area. This control allows end-users to directly type a string or numeric value. The entered value is then assigned to the linked document, data table, or column property, enabling dynamic control over calculations, expressions, or other elements within the analysis.

B. Drop-down list: This control provides a predefined list of values for users to select from; it does not permit typing a new value.

C. Slider: This control allows users to select a numeric value from a continuous or discrete range by moving a slider, not by typing.

D. Labels: This control is used only to display the current value of a property and does not allow for user input or modification.

E. List box: Similar to a drop-down list, this control presents a list of predefined items for selection, not a field for text entry.

1. TIBCO Spotfire® Analyst 14.0 LTS User's Guide

"Details on Property Control".

Section/Page: Under the topic "Adding Controls to the Text Area"

the description for the "Input field" control explicitly states: "Adds an input field where you can type a value. The value you type will be passed to the specified document

data table

or column property." This directly confirms that the input field is the correct control for typing a new value. The same section describes the other controls (Drop-down list

Slider

Labels

List box) as selection or display mechanisms.