Discoverer Business Views Overview

kamlesh
Categories: ERP
What are Business Views that Oracle refers to within all the intelligence products like BIS, Discoverer for APPs and Daily Business Intelligence?
  • A Business View is a database view on top of Oracle Apps Tables
  • Logical view encapsulating key columns and extra information from Flex Fields (Key and Descriptive)
  • Easy and Efficient mechanism to reflect any Flex Field changes
  • Pre-built Security encoded within each Business views.
  • Security is defined based on Operating Unit, Inventory Organization and Business Groups
  • Pre-seeded EUL Folders use Business Views as their data source Business Views is comparable to Noetix views
Why do we need to Regenerate Business Views?
  • Oracle just provides the base skeleton of the view.
  • This skeleton view usually has a suffix of _FV (FV = Full View)
  • This skeleton view has all the required columns plus instructions on how to extract the Flex Field Columns
  • Sample instruction '_DF:PER:PER_GRADES:grd‘
  • Business View Generator Program reads the skeleton view definition and creates a complete _FG view (Full Generated)
  • EUL Folders point to the _FG views

Try MockupTiger to build Wireframes for your next software prototypes or initial Mockups when you are just iterating over ideas.


MockupTiger Wireframes builds instant wireframes for your Dashboards or Oracle Forms

6 Responses to “Discoverer Business Views Overview”

  1. Can you use Discoverer BIS views with Business Objects? says:
    August 28, 2006 at 4:40 pm

    [...] To use the pre-seeded BIS views you need Discoverer Administrator to install the eex files. [...]

  2. twlfmqcw says:
    October 3, 2006 at 11:54 am

    xkmaongwtb…

    mlgqhfzyilo lkorpmi mwsmnhsyxu nuhsabln …

  3. Siva says:
    April 2, 2007 at 6:29 pm

    How can I install the eex files? Would the eex files create the necessary joins?
    For example between AP_INVOICES and PO_VENDORS tables?
    Thank you

  4. muthyala says:
    April 13, 2007 at 4:11 am

    Hi
    I want smale information
    what is the implimentation…
    process in oracle financials

  5. somu sharma says:
    April 21, 2007 at 11:57 am

    How to define Oracle Project items in Oracle project module.. also what are the basic business cycles involved in this module

  6. saireddyk says:
    June 26, 2007 at 8:50 am

    Hi,
    my customer requirement is to create custom business view , can you please let me know hw to create it.

    Thanks
    KSR