Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Is there a way to show OTM data in OTBI?
Hi All,
We have an requirement to show OTM related data in OTBI reports.
Answers
-
Hi, What is OTM? Oracle Transportation Management (OTM)?
Is this a module that is part of Oracle Fusion Cloud Applications? Is OTM in SCM?
OTBI is for Oracle Fusion Cloud Applications https://docs.oracle.com/en/cloud/saas/index.html.
If you go to the following page you get the list of subject areas at the bottom analytics/saw.dll?PrivilegeAdmin
And if you go to your user guide for each application you can read about each one For example, SCM
subject areas
application database tables and views
and data lineage
0 -
Hi Nathan,
Yes, OTM - Mean Oracle Transportation Management. Heard that for OTM we has it's own database . Can we build reports using OTBI?
0 -
Hi Yes that was why I posted the 3 links.
If a subject area exists you can build an analysis in OTBI (or a report in OTBI using bi as a data source).
If the tables and views exist in one of the data sources in your data model then you can build a report in OTBI.
If you know the table or view but need to know if a subject area exists that reads it then look in the data lineage.
0 -
Thanks for the update.
As per the oracle documentation, we don't have any prebuilt data models /subject areas available in SCM.
In some of the oracle blogs, it was mentioned that we have to use FTI(Fusion Transactional Intelligence) to build transactional reports in OTM.
Hence, trying to understand if we can call the reports that are built in FTI to OTBI
0 -
Hi, OTBI is "Oracle Transactional Business Intellignece" part of "Oracle Fusion Cloud Applications". OTBI = the patform "Oracle Business Intelligence (OBI) suite (Enterprise Edition EE)" + inside OBI our prebuilt analytics and reports and subject areas in the metadata repository database for each application.
I have never heard of FTI? Is this perhaps a blogger making a mistake with an abmigous reference mixing up some of the words from to OTBI and Fusion? When I google FTI I only hit OTBI? https://www.google.com/search?q=Fusion+Transactional+Intelligence
0 -
hi Sorry, My bad it is Fusion Transportation Intelligence.
0
