QUESTION: 25

The Expression shortcut "Cumulative Sum" uses which expression?

A)

B)

C)

D)

Option A
Option B
Option C
Option D

Answer(s): C

Explanation:

The expression shortcut "Cumulative Sum" uses the expression Sum([Column]) THEN Sum([Value]) OVER (AllPrevious([Axis.X])). This expression calculates the sum of the values in a column, and then calculates the cumulative sum of those values over all previous values on the X-axis. This is equivalent to option C in the image you sent1.

Reference:

Cumulative Sum

Reveal Solution Next Question

QUESTION: 26

Which function category contains node navigation functions?

OVER Functions
Statistical Functions
Binning functions
Spatial Functions

Answer(s): A

Explanation:

Node navigation functions are used to reference specific records or groups of records in a hierarchy or an axis. They are part of the OVER category of functions, which are used to group data in calculations. Some examples of node navigation functions are All(), Previous(), Next(), Parent(), and Intersect()12. The other function categories do not contain node navigation functions. Statistical functions are used to perform statistical tests and calculations, such as Corr(), TTest(), and Anova()3. Binning functions are used to create bins or groups of values, such as BinByCount(), BinByDateTime(), and BinBySize()4. Spatial functions are used to perform spatial calculations and operations, such as ST_Area(), ST_Contains(), and ST_Distance()5.

Reference:

1: Node navigation - TIBCO Software1, 2: Using Node Navigation in Spotfire » The Analytics Corner2, 3: Statistical

Functions - TIBCO Software, 4: Binning Functions - TIBCO Software, 5: Spatial Functions - TIBCO Software

Reveal Solution Next Question

QUESTION: 27

Which variable can be used along with THEN keyword to pick out a node of interest in an expression?

[Axis.Color]
[Categorylndex.X]
[Axis.X]
[X.LevelName]

Answer(s): B

Explanation:

The variable [CategoryIndex.X] can be used along with the THEN keyword to pick out a node of interest in an expression. This variable represents the index of the node on the X axis, starting from zero. For example, to get the value from node number five on the X axis and put it on all other nodes, you could use an expression like this:
Sum ( [Sales]) THEN Sum (if ( [CategoryIndex.X]=4, [Value],0)) OVER (All ( [Axis.X])) The other variables, [Axis.Color], [Axis.X], and [X.LevelName], are not used to pick out a specific node, but rather to refer to the color, value, or level name of the node, respectively1.

Reference:

Using Expressions on Aggregated Data (the THEN Keyword)

Reveal Solution Next Question

QUESTION: 28

Where are Information Links saved?

Spotfire Web Player
Spotfire Analyst Client
Spotfire Library
Spotfire Data Source

Answer(s): C

Explanation:

Information links are predefined database queries, specifying the columns to be loaded into the internal data engine of TIBCO Spotfire, and any filters needed to reduce the size of the data table prior to visualization1. Information links are saved in the Spotfire Library, which is a central repository for storing and managing data sources, analyses, and other resources2. Users can access information links from the library and use them to open data in Spotfire clients, such as the Web Player or the Analyst Client3.

Reference:

Information Links - TIBCO Software, Library - TIBCO Software, Changes in Spotfire version 10: How to add an Information link to an existing analysis

Reveal Solution Next Question

Free TCP-SP Exam Braindumps (page: 7)

QUESTION: 25

Explanation:

Reference:

QUESTION: 26

Explanation:

Reference:

QUESTION: 27

Explanation:

Reference:

QUESTION: 28

Explanation:

Reference: