Dash Board Set Up

[cool_brat]

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]

Re: Dash Board Set Up

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]

Re: Dash Board Set Up

Thanks, Nick

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

Regards
Vipin

[bkirchmeyer]

Re: Dash Board Set Up

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

[nick.polites]

Re: Dash Board Set Up

For that change to take, it would require the restart of the OTM app and web servers, but I would also restart OBI/FTI as well.

[bkirchmeyer]

Re: Dash Board Set Up

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

Quick question:
Should this update be done on the Primary database (not the ROD)?

[nick.polites]

Re: Dash Board Set Up

On the primary.

[raghulakshman]

Re: Dash Board Set Up

Hi Nick,

We are facing the same issue and getting the below error. As suggested by you we have verified values in F_BASE_UOM table and has only one value for "VOLUME" which is CU FT. Could you suggest possible root cause for this issue?

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"."Shipment Date", "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", "Source Geography"."Source XID", "Transport Mode"."Mode XID", 1, Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Shipment Details"."AA Shipment GID",Position(''.'' IN "- Shipment Details"."AA Shipment GID")+1,length("- Shipment Details"."AA Shipment GID")) FROM "Fusion Transportation Intelligence"')}


SQL Issued: SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Shipment Date", "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", "Source Geography"."Source XID", "Transport Mode"."Mode XID", 1, Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Shipment Details"."AA Shipment GID",Position('.' IN "- Shipment Details"."AA Shipment GID")+1,length("- Shipment Details"."AA Shipment GID")) FROM "Fusion Transportation Intelligence"

Thanks,
Raghu Lakshman

[Kristof Stevens]

Re: Dash Board Set Up

We have following issue :

Connection between OTM and FTI is working fine and users are able to use the dashboard....

For an unknown reason the Oracle BI Javahost / SAW Server is loosing his connection (randomly) and we have to run this script ./run-saw.sh stop/start again
to solve the issue. Any idea why? :

On /oraclebi/OracleBIData/web/log/javahost.out.log :

Sep 16, 2009 11:20:21 AM MessageProcessorImpl processMessage
WARNING: Unexpected exception. Connection will be closed
java.io.EOFException
at com.siebel.analytics.web.sawconnect.sawprotocol.SA WProtocol.readInt(SAWProtocol.java:167)
at com.siebel.analytics.javahost.MessageProcessorImpl .processMessage(MessageProcessorImpl.java:133)
at com.siebel.analytics.javahost.Listener$Job.run(Lis tener.java:223)
at com.siebel.analytics.javahost.standalone.SAJobMana gerImpl.threadMain(SAJobManagerImpl.java:205)
at com.siebel.analytics.javahost.standalone.SAJobMana gerImpl$1.run(SAJobManagerImpl.java:153)
at java.lang.Thread.run(Thread.java:619)

Thx in advance,

Kristof Stevens

[l_kator]

Re: Dash Board Set Up

Try:
1.You mast install Oracle BI client on Windiws mashin(if necessary)
2. Open Oracle BI Administration tools (start/program/oracle business inelligence/Administaration )
3. Open online(if BI Server on this computer) or offline (If BI Server run on other computer) repository Advanced_analytics
4. Check repository variable WEB_SERVER(Manage/Variables/Dynamic/WEB_SERVER)
5. Set Default Initializer to 'http://OTMhost:OTMport/GC3' and press Check IN Changes (in my company it 'http://oas.ebs:85/GC3' )
If repository was opened offline, you mast restart all BI sevices

[Kristof Stevens]

Re: Dash Board Set Up

We installed Oracle BI Server on Red Hat Linux.

[l_kator]

Re: Dash Board Set Up

copy OracleBI\server\Repository\advanced_analytics.rpd from linux to Windows
install BI client on windows
(If you cannot install client, you can send me a file, I will make changes and I will send to you back)
Make change in repository offline
Copy changed .rep file back to Linux and restart all BI Services
Still to be necessary for you the client for modification of a repository

[Kristof Stevens]

Re: Dash Board Set Up

It's the default advanced_analytics.rpd from OTM 5.5 CU5 RUP6.
Where can I post this file?

[l_kator]

Re: Dash Board Set Up

elenskaya(@)ebspartners.biz
delete ()
and write in mail you OTM address (host and port)