How to get parameter mapping to work between LiveView Web and Spotfire Server

How to get parameter mapping to work between LiveView Web and Spotfire Server

book

Article ID: KB0083495

calendar_today

Updated On:

Products Versions
TIBCO Live Datamart 1.3.0 and later

Description

The TIBCO Community provides basic instructions for integrating LiveView Web with Spotfire Server:

https://community.tibco.com/wiki/integrating-tibco-liveview-web-tibco-spotfire

However, there are additional steps needed to get parameter mapping working, which allows LiveView Web query paramters to be mapped to column names in Spotfire data tables.

Issue/Introduction

This article describes the additional steps needed to configure mapping between a LiveView Web query parameter and a column name in a Spotfire data table.

Resolution

In Spotfire Analyst, create the LiveView Web visualization according to the instructions provided on TIBCO Community (https://community.tibco.com/wiki/integrating-tibco-liveview-web-tibco-spotfire).

Then click the properties button in the upper-right corner of the visualization.  This displays the JS Visualization Properties dialog.  From there, select 'Data' on the left, and click the Edit button for the data table.

In the Edit Data Configuration dialog, select the 'Column Definitions' tab.  In the 'Selected Column Expressions' tab, enter the expression..
 
First([SfColumn]) as [SfColumn]

..where 'SfColumn' is the column name in the Spotfire data table.

Finally, enable the parameter mapping in the LiveView Web Visualization.  In the JS Visualization Properties dialog, select 'Config Parameters' on the left, and edit the 'parameterMap' section.  For example:
 
"parameterMap": {
    "SfColumn": "QueryParam"
  }

..where 'QueryParam' is the LiveView Web query parameter being used in the query for this visualization.
 

Additional Information

https://community.tibco.com/wiki/integrating-tibco-liveview-web-tibco-spotfire