Integrating The BI Publisher in OTM

[gokul]

Hi Folks,

Is it Possible to integrate BI Publisher (Release 10.1.3.2.) in otm, if so can u plz provide me the details.

[chrisplough]

Re: Integrating The BI Publisher in OTM

OTM v5.5 CU3 now supports OBI EE (Oracle Business Intelligence Enterprise Edition) as the integrated analytics tool, which is officially called FTI (Fusion Transportation Intelligence).

This is a new technology for OTM (replacing Cognos - the 3rd party Analytics engine that G-Log had integrated into the product). Some quick notes:

• Since this is newly released - I would definitely expect installation, integration and usage issues -- though I'm sure they'll be resolved in upcoming patches (CUs and RUs)
• Oracle highly recommends running your analytics against an ROD (Replicated Operational Database), rather than your Operational database, because of performance implications.

You can find out more:

• Installation instructions -- within the OTM v5.5 Administration Guide
• Functional Overview -- checkout this post by Oracle Training, specifically how to access the TOIs:
  • http://www.otmfaq.com/forums/f31/ora...sentation-494/
• Usage -- within OTM's online help system

Thanks,
--Chris

[gokul]

Re: Integrating The BI Publisher in OTM

chris,

Thank u for ur valuable rep, then i have doubt chris, whether only otm v55 supports for BI or else all the otm versions supports for this.

[chrisplough]

Re: Integrating The BI Publisher in OTM

No problem -- only OTM v5.5 CU3 and higher will support BI. In addition, the older versions of OTM (and GC3) are being de-supported, so customers will want to migrate, regardless.

Thanks,
Chris

[gokul]

Re: Integrating The BI Publisher in OTM

chris,

Whether this integration step's will be available in the following pdf,
if not can u guide me on this, bcs this is the first time handling this job


Administration Guide
Release 5.5
doc id : B28768-04

[chrisplough]

Re: Integrating The BI Publisher in OTM

Yes, that should be the correct document -- you'll find the configuration settings in Chapter 4 - under "Installing Fusion Transportation Intelligence".

I'll do my best to help you out, though we have a couple of major client migrations and go-lives going on right now, which must take priority. I only mention this, as it may affect my ability to immediately respond.

My recommendation is to follow the manual and post whatever problems and solutions you encounter. That way the community can also benefit from your efforts and others will be able to learn more about FTI.

Thanks,
Chris

[rj5316]

Re: Integrating The BI Publisher in OTM

Hi Chris,

Thanks for your info on this subject.

Though I am aware that Oracle has brought in FTI as a new moudule in 5.5.3, would it still be possible to inetgrate the product with Cognos...( advanced analytics as in the earleir versions) .....though FTI may be a good dashboard to use .. our client would like to know if Cognos is integrateable / usable with OTM....

Our clients have not yet implemeneted OTM and hence I feel that this question might not be very important when they do implement OTM as they would surely have FTI... however we would be obliged if have some clarity on this from you....

Rgds--

[nick.polites]

Re: Integrating The BI Publisher in OTM

There is no Cognos support from within OTM so any integration (if it even would work) would have to be done by the customer and would be outside of the realm of support.

[rj5316]

Re: Integrating The BI Publisher in OTM

thanks nick...

rgds--

[snurani]

Re: Integrating The BI Publisher in OTM

Hi Folks,

Is it Possible to integrate BI Publisher (Release 10.1.3.2.) in otm, if so can u plz provide me the details.

Is there any documentation of Integration BI Publisher (not the FTI) with OTM 6.1 using weblogic server ?

[acuartero]

Re: Integrating The BI Publisher in OTM

The jar files for BIP 10g are part of the OTM App server installation. There is some information starting on page 8-18 of the 6.1 Admin Guide. Is there something specific you're looking for?

Thanks,
Alan

[snurani]

Re: Integrating The BI Publisher in OTM

My customer is trying to see the BOL report on screen and It is not working, and has tried different Report format .
If the delivery method Email is choosen then it works and system emails then report in PDF format but Once you click Submit it open new window with error message

File does not begin with '%PDF-'

[acuartero]

Re: Integrating The BI Publisher in OTM

They broke reports based on GID values in 6.1.1, I had a similar problem until I upgraded to 6.1.2. You may want to try applying that to see if it fixes your issue.

Thanks,
Alan

[snurani]

Re: Integrating The BI Publisher in OTM

We are able to generate the report properly in OTM , I find the PDF in /temp and able to open it after transferring to my desktop.

But, if i want to open the PDF from the browser, the below error is seen.
File does not begin with %PDF

Or if we save the PDF from broswer and try to open below error is seen
"Acrobat could not open '[file name]' because it is either not a supported file type or because the file has been damaged

Is any configuration of webserver for Adobe is additionally needed to display this HTTP Post output in browser?

They broke reports based on GID values in 6.1.1, I had a similar problem until I upgraded to 6.1.2. You may want to try applying that to see if it fixes your issue.

Thanks,
Alan