Hi,
Could some one let me know if there is any documentation available for the FTI dash board set up,
I have tried to add a few KPI's to My Dash board section, but when I open the dash board, I receive this error:
" View Display Error Odbc driver returned an error (SQLExecDirectW).
Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 23013] An error occurred when extracting the metadata definition for the Attribute '"Fusion Transportation Intelligence"."D_SHIPMENT"."SHIPMENT_GID_LINK"'. [nQSError: 23005] The repository variable, WEB_SERVER, has no value definition. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Start Time", "- Stop Delivery Details"."Actual Arrival", "- Stop Delivery Details"."Planned Arrival", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Stop Delivery Details"."AA Shipment GID" ,Position(''.'' IN "- Stop Delivery Details"."AA Shipment GID")+1,length("- Stop Delivery Details"."AA Shipment GID" )), sum("- Stop Delivery Fact"."Total On Time Count")*100/sum("- Stop Delivery Fact"."Total Stops") FROM "Fusion Transportation Intelligence"')}
SQL Issued: SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Start Time", "- Stop Delivery Details"."Actual Arrival", "- Stop Delivery Details"."Planned Arrival", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Stop Delivery Details"."AA Shipment GID" ,Position('.' IN "- Stop Delivery Details"."AA Shipment GID")+1,length("- Stop Delivery Details"."AA Shipment GID" )), sum("- Stop Delivery Fact"."Total On Time Count")*100/sum("- Stop Delivery Fact"."Total Stops") FROM "Fusion Transportation Intelligence"
"
Please let me know If I am missing something in the setups.
Could some one let me know if there is any documentation available for the FTI dash board set up,
I have tried to add a few KPI's to My Dash board section, but when I open the dash board, I receive this error:
" View Display Error Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 23013] An error occurred when extracting the metadata definition for the Attribute '"Fusion Transportation Intelligence"."D_SHIPMENT"."SHIPMENT_GID_LINK"'. [nQSError: 23005] The repository variable, WEB_SERVER, has no value definition. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Start Time", "- Stop Delivery Details"."Actual Arrival", "- Stop Delivery Details"."Planned Arrival", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Stop Delivery Details"."AA Shipment GID" ,Position(''.'' IN "- Stop Delivery Details"."AA Shipment GID")+1,length("- Stop Delivery Details"."AA Shipment GID" )), sum("- Stop Delivery Fact"."Total On Time Count")*100/sum("- Stop Delivery Fact"."Total Stops") FROM "Fusion Transportation Intelligence"')}
SQL Issued: SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Start Time", "- Stop Delivery Details"."Actual Arrival", "- Stop Delivery Details"."Planned Arrival", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Stop Delivery Details"."AA Shipment GID" ,Position('.' IN "- Stop Delivery Details"."AA Shipment GID")+1,length("- Stop Delivery Details"."AA Shipment GID" )), sum("- Stop Delivery Fact"."Total On Time Count")*100/sum("- Stop Delivery Fact"."Total Stops") FROM "Fusion Transportation Intelligence"
"
Please let me know If I am missing something in the setups.
Comment