Supercharge Dashboard 2.1 Lookups

Supercharge Dashboard 2.1 Lookups

Below is an example of an outbound EDI 856 ruleset where we capture the PSN (Pick Slip Number), JDEdwards EDOC, and date. We are capturing these values for access in EXTOL Dashboard 2.1

  • SQL Access - Insert Reference("env.var.Log_of_Message_id", "EDOC","rls.var.varEDOC_str")
  • SQL Access - Insert Reference("env.var.Log_of_Message_id", "PSN","rls.var.varPSN_str")
  • SQL Access - Insert Reference("env.var.Log_of_Message_id", "ASNDate","sys.var.Current_Date")
  • Move (with Trim Left & Right): "rls.var.varEDOC_str" ==> "env.var.User_Reference_1"
  • Move (with Trim Left & Right): "rls.var.varPSN_str" ==> "env.var.User_Reference_2"
  • Move (with Trim Left & Right): "sys.var.Current_Date" ==> "env.var.User_Reference_3"

We have found that we were able to access the same data much, much faster when we access via User_Reference


By: on
A free web counter provided by GoStats.