IBM Support

Enable conditional formatting for all property types in iBase and Analyst's Notebook

How To


Summary

Trying to create a conditional format rule in an Analyst's Notebook environment that is connected to iBase, only bold values in the Property type field are eligible for selection. Choosing a property type that is not bold would result in a conditional format rule that does not apply to any items on the chart.

The bold values come from the Charting Schemes that are built in iBase. User can control what property types get pushed over to the chart and thus become available for use.

Objective

Apply conditional formatting to different property types.

Environment

iBase
Analyst's Notebook

Steps

1. In iBase, open the Charting Schemes section. We are using the Association Data charting scheme for this example.
charting scheme
2. Select the Person entity. Under Data Records, select "All". The default value may be "Assigned Only" which limits what fields may be used for conditional formatting.
Data records
3. Now in Analyst's Notebook, change to the correct charting scheme that was just modified. The charting scheme can be changed from the iBase data sources Pane.
data sources
Association options
4. If an entity is now brought from iBase to the Analyst's Notebook chart, it is possible to view which properties are available by opening up the record on the chart.
item properties
5. A new conditional formatting specification in Analyst's Notebook will have these property types eligible for use.
properties
6. Now we run the specification. For this example, we want to change the icon frame to orange for any Person records that have a last name property.
gene

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXUXD","label":"i2 Analyst\u0027s Notebook"},"ARM Category":[{"code":"a8m50000000Ci9HAAS","label":"i2 iBase and i2 Analyst\u0027s WorkStation-\u003ECharting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

Document Information

Modified date:
09 December 2021

UID

ibm16524980