Dash Board Set Up

cool_brat · #1 (**permalink**) July 28th, 2008, 08:01

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.

nick.polites · #2 (**permalink**) July 28th, 2008, 12:23

This is one of two bugs that I found as part of the OBI install.

Here is my documentation of the issues. Make sure to restart OTM after you update these.

-Log into the database as hdowner and run the following select statement select * from f_base_uom. If more than one UOM_TYPE of volume is returned you must delete all but one. It is recommended that you keep the most common one which is “CU FT”.

-Via SQL Backdoor you’ll need to update the OTM_WEB_SERVER parameter which is found in the REPORT_COMMON_PROPERTIES table. The update statement should look something like:

update REPORT_COMMON_PROPERTIES set REPORT_COMMON_PROPERTY_VALUE = 'http://otm.oracle.com/GC3 where REPORT_COMMON_PROPERTY_GID='OTM_WEB_SERVER'

cool_brat · #3 (**permalink**) July 28th, 2008, 12:30

Thanks, Nick

I will have our technical team run these processes and get back in case we have further issues.

Regards
Vipin

bkirchmeyer · #4 (**permalink**) July 28th, 2008, 18:38

Nick,

Related to this issue, only "CUFT" exists for the UOM_TYPE of "VOLUME" in the f_base_uom table.

After the other update mentioned (to REPORT_COMMON_PROPERTIES) you mentioned a restart of OTM. Do we need to restart all servers/apps or just the FTI/OBIEE server?

Thanks,
Ben