R13 21D Financials OTBI database mapping with ViewObjects A view selector is a drop-down list from which users can select a specific view of the results from among the saved views. Any idea where I can find the latest one? Before you can create an Oracle BI Publisher data model using a view object, you must first create the view object in your application following the guidelines in Developer's Guide for Oracle Business Intelligence Publisher. You can use this sheet to search for a reporting column by subject area or to . Displays the results as a ticker or marquee, similar in style to the stock tickers that run across many financial and news sites on the Internet. Applications content. Customers can use these spreadsheets to search for subject area reporting content or trace the corresponding View Object, database table and column for a subject area reporting field. Expand Facts Human Resources Workforce Deployment > Workforce Deployment Facts. Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); This site uses Akismet to reduce spam. Open the Data Sync UI, clickConnectionsbutton on the top, and then click on the New icon button to createa new Data Sync connection usingOracle BI Connector. [Release 1.0] Information in this document applies to any platform. Symptoms. Learn SQL and use BI Publisher. This table describes the view types that you can use to present your data (if you have the required privileges). Therefore, physical SQLs are more flexible and capable than logical SQLs in terms of data visibility and incremental load ability. The Select Visualization dialog box is displayed. XML. Use the information in the spreadsheet to search for a View Object, the corresponding Database Table and Database Column. R12 HCM OTBI subject area database table mapping spreadsheet