Announcement

Collapse
No announcement yet.

Dash Board Set Up

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • Dash Board Set Up

    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.

  • #2
    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'
    If my post was helpful please click on the Thanks! button

    MavenWire Hosting Admin
    15 years of OTM experience

    Comment


    • #3
      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

      Comment


      • #4
        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

        Comment


        • #5
          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.
          If my post was helpful please click on the Thanks! button

          MavenWire Hosting Admin
          15 years of OTM experience

          Comment


          • #6
            Re: Dash Board Set Up

            Originally posted by nick.polites


            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)?

            Comment


            • #7
              Re: Dash Board Set Up

              On the primary.
              If my post was helpful please click on the Thanks! button

              MavenWire Hosting Admin
              15 years of OTM experience

              Comment


              • #8
                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

                Comment


                • #9
                  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

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      Re: Dash Board Set Up

                      We installed Oracle BI Server on Red Hat Linux.

                      Comment


                      • #12
                        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

                        Comment


                        • #13
                          Re: Dash Board Set Up

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

                          Comment


                          • #14
                            Re: Dash Board Set Up

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

                            Comment

                            Working...
                            X
                            😀
                            🥰
                            🤢
                            😎
                            😡
                            👍
                            👎