Getting Started With Oracle Fusion Application Business Intelligence

Getting Started With Oracle Fusion Application Business Intelligence [ID 1489938.1]T o BottomModif ied:Dec 22, 2012T ype:WHITE PAPER Status:PUBLISHED Priority:3Comments (0)In this DocumentAbstractHistoryDetailsEdit an Existing Report or AnalysisMyOracleSupport Note With Steps To Create a Analysis Oracle UniversityOnline DocumentationExamplesUse Reports&Analytics to create an OTBI AnalysisUse BI Answers to create an OTBI AnalysisCreate a simple BI Publisher reportIdentify Subject Area or Data Model CriteriaOTBI AnalysisBI PublisherThis document is intended as a "Getting Started" document to help our customers begin to use the reporting functionality in Oracle Fusion Applications.Created 10-SEP-2012 by Kari B. in SupportEdit an Existing Report or AnalysisAs per the Oracle® Fusion Applications Extensibility Guide,section8.2.1.2 What You Can Customize:If you intend to try to edit an existing report or analysis, Oracle recommends that you make a copy of the seeded report or analysis and edit the copy. If you need to edit the seeded report or analysis, Oracle strongly recommends that you keep a pre-customized version of the report or analysis. If your report or analysis has an error or problem, Oracle will ask that you run the uncustomized report or analysis to ascertain if the problem existed in the seeded report or analysis. Or, if the problem was introduced by the customization. We recommend that you create a new folder in the catalog and copy the items in to the new folder and edit them there.To make a copy of a report or analysis:∙Log in to BI Answers.∙Drill through the catalog to the folder that contains the report or analysis.∙Click More for the report or analysis.∙Click Copy from the short cut menu that appears.Then click to select the folder that contains your company's custom reports and analysis. With that selected, use the Paste icon that is in the tool bar directly above the Catalog contents.Note that Oracle strongly recommends against editing seeded data models. These are often used for reporting on processes in Fusion Applications. Editing the data model can cause problems with the report, which can then sometimes cause the process itself to end with error. If you need to change a seeded data model, you should always make a copy and edit the copy. MyOracleSupport Note With Steps To Create a AnalysisThere is a note in MyOracleSupport that contains steps to create and run a simple report. It was created to enable troubleshooting of reports and contains exact steps to create a report. This is Verify your Fusion Applications Business Intelligence environment with this simple technique (1469009.1).Oracle UniversityNOTE: Oracle Fusion Applications encapsulates functionality in OBIEE, OTBI, and BI Publisher. Most functionality available in these middleware products is available in Oracle Fusion Applications but not all of the functionality.1.There is an Oracle University ONLINE course titled, "Fusion 11g Release5 (11.1.5.0.0) TOI: SaaS Ad Hoc Reporting using OTBI" that containsgetting started information such as using "Reports and Analytics" tocreate or run a report.2.There are "Oracle By Example" tutorials available on OTN. Click here toview the list. These will help get started with the underlying OBIEE and BI Publisher functionality.3.Search Oracle University for related courses through this link. Oraclerecommends:1.OTBI and OBIA: Oracle BI 11g R1: Create Analyses andDashboards2.BI Publisher: Oracle BI Publisher 11g R1: FundamentalsOnline DocumentationConsult Oracle documentation. Links are in note Fusion Applications Technology: Master Note on Business Intelligence and Reporting (Doc ID 1327881.1).ExamplesThis section contains links to videos showing basic analysis/report creation. To view the video, click the appropriately named link. When the video begins to run, if it is sized incorrectly for your screen, double-click the window at the top. You will then be able to see the controls for things such as play and pause. 1. Use Reports&Analytics to create an OTBIAnalysis2. Use BI Answers to create an OTBI Analysis3. Create a simple BI Publisher reportIdentify Subject Area or Data Model CriteriaOTBI Analysisrmation about the OTBI Subject Areas can be found in theattachment to note 1514514.1.BI Publishere Query Builder. Currently there is a defect that causes Query Builderto error for some pillars. If it does not error, the list of items comes uplike the Subject Areas. You can start with the queries used and addcolumns, joins, and where clauses as required.2.Begin with OER. Information about the OER can be found in note1399910.1.1.The link is: https:///oer/index.jsp2.Click the Log in as Guest button.3.This information is not yet fully populated.3.Find table names using a database trace of operations in the userinterface (UI).1.Log in to Fusion Applications.2.Click Help / Troubleshooting / Troubleshooting Options.3.Click to select database (and if you want binds and waits). Thenclick Save and Close.4.Now perform your operation in the interface.5.When you have completed the operation, do Help /Troubleshooting / Troubleshooting Options.and uncheck allthe trace options and then click Save and Close. Do not forgetto turn off trace in a timely fashion or your trace file may be filledwith other data and it will be more difficult to find the steps youwere most concerned with.6.Request the log file by creating an SR to Oracle FusionApplications Toolkit / Cloud Operations.1.Include pod name.2.State that you need database trace files from the databaseserver.3.Note1386367.1 describes how to get your session cookiebecause that value is part of the trace file name for alltraces for your session. Or, you can only do it once per dayand specify the date/time you ran the trace. This is moredifficult for the person pulling the log files and they mighthave trouble. If you try this way, please remember toinclude the time zone in which the time was provided.7.The log files will come through as an attachment on the SR.。