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.
Reaching this dialog:
When you select data for a connection to SAP BW in the Data Selection in Connection dialog, click to select a dimension or hierarchy.
In the Settings pane, under Value presentation, select Custom.
Click Edit....
Option |
Description |
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. Tip: 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 |