IBM Support

How can I do Date/Time analysis in Analyst's Notebook with data from the Information Store?

Question & Answer


Question

When I bring items from the Information Store onto an i2 Analyst's Notebook chart, I am not able to set the Date & Time properties to Controlling so I can plot them on a timeline.
image 7751
For example, on my chart I have two accounts with 123 transactions.  I would like to see the transactions on a timeline for a visual view of the activity.  However, the Date & Time properties are not available from the Transaction link even though they appear in the Record inspector field.
When I select all the items to move to a Timeline chart, I get a message:
"Date and time properties are not present on the items being
copied to the new chart. Without dates and time it is not
possible to arrange them into a timeline. Do you want to
continue anyway?"
image 7739
 How do I apply the transactions to a timeline?

Answer

In order to be able to perform date & time analysis of the items from the Information Store, you need to have the information for the dates and time shared from the Charting scheme.  Here is the link to the documentation explaining the importance of the Charting scheme:

Changing the displayed information

To add the Date and Time values to your Charting Scheme, open your i2 Enterprise Insight Analysis (EIA) schema file in "IBM i2 Analyze Schema Designer".

  1. Select File -> Open Schema
  2. Select your schema xml file from your toolkit configuration files.  For example, C:\IBM\i2Analyze\toolkit\configuration\fragments\common\WEB-INF\classes.  In my screen capture, I am editing the sample law-enforcement-schema.xml.
  3. Select File -> Edit Charting Schemes...
    image 7744
  4. For the Entity or Link that you want to add the time analysis, add the Date and Time properties. In my example, I am adding the Date and Time properties to the "Transaction" link.  Right mouse click Properties under Transaction and select "Insert Chart Item Property Type".
    image 7752
  5. Use the drop-down to select the Date property type.
    image 7755
  6. In the right side pane, select the item Property containing the Date value to use for time analysis.  In my example, the Transaction link contains a property "Date and Time"
    image 7756
  7. Repeat to add the Time property type and associate it with the item property containing the Time value.
    image 7758
  8. Click OK to save the Charting Scheme changes, then save the Schema before exiting.
  9. Redeploy according to the IBM Knowledge Center:  Modifying a deployed i2 Analyze schema
     
    setup -t stopLiberty
    setup -t updateInformationStoreSchema
    setup -t deployLiberty
    setup -t startLiberty
Exit i2 Analyst's Notebook (ANB), then start it again and log in to EIA to pick up the Schema and Charting Scheme changes. It is important to exit ANB since the schema and charting information is cached and a restart will force the changes to be refreshed after a new connection.
Do a search to add the items to your chart. You now see the Date and Time values appear in the link properties:
image 7760
 When all the items are added to a timeline, there is no warning message.  In the timeline, you see the Transaction link properties have the option to set the Order and Control of Date & Time to "Controlling"
image 7762

[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXVXZ","label":"IBM i2 Enterprise Insight Analysis"},"ARM Category":[{"code":"a8m0z000000cwjXAAQ","label":"i2 Enterprise Insight Analysis->Info Store"}],"ARM Case Number":"TS004557872","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU008","label":"Security"},"Product":{"code":"SSXVMQ","label":"i2 Analyst's Notebook Premium"},"ARM Category":[{"code":"a8m50000000CavpAAC","label":"i2 Analyst's Notebook and other i2 software->i2 Analyst's Notebook Premium->General"}],"Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Version(s)"}]

Product Synonym

ANBP; EIA, i2 Analyze

Document Information

Modified date:
08 January 2021

UID

ibm16381908