Working with Cubes in Spotfire®

Custom value presentation

For characteristics and hierarchies from SAP BW, you can select how to display the characteristic in Spotfire. A characteristic in SAP BW can have many types of metadata, such as attributes and technical names.

In this dialog, you can define a custom value presentation for a SAP BW characteristic or hierarchy. You can combine available technical names and attributes to your liking, and customize the presentation with other characters.

OptionDescription
Available technical names and attributes Lists all the available attributes and technical names for the characteristic or hierarchy.
Name The name of the attribute or technical name.
Identifier The identifier used to reference the attribute or technical name in the Value presentation expression.
Insert Click to insert the selected attribute or technical name in the Value presentation expression.

Note that you can also quickly insert attributes or technical names in the expression by double-clicking items in the list.

Value presentation expression The expression describing the custom value presentation.

You reference attributes and technical names with their respective Identifier string.

You can enter other characters in the expression, for example as separators to make the values display the way you want.

Example

In the example in the image, we are creating a custom value presentation for a characteristic with currency information. We want to display the characteristic with the technical name Key and the attribute Medium Name , separated by an en dash.

The technical name Key contains a three-letter abbreviation for the currency, for example 'USD'. The attribute Medium Name contains the full name of the currency, for example 'United States Dollar'.

The expression looks like this:
 {Key} - {[0CURRENCY]}.{[50CURRENCY]}
The expression results in a custom value presentation where values in the currency characteristic are displayed like this:
USD - United States Dollar
GBP - Pound Sterling