Toad World® Forums

Oracle Business Intelligence Standard

This suite is extra modest, very affordable for SMBs. includes everything you need to take a quick time running in business Intelligence device. it’s if everything has been hooked up on a server, and this should be a windows Server.
The license does not permit using more than CPU’s the server and allows simplest different source of direct records apart from the BD includes. The obligatory licensing per person is nominal, and may be certified among 5 and 50 customers.
installation is carried out easily and in a unmarried processor installed inside the server database, ETL tool Oracle Warehouse Builder (basic model), the BI server and different packages.
The BI server lets in get admission to to net analytical reporting tool and dashboards, for layout to operation. The whole surroundings is the purchase of Siebel and Oracle made some time ago, and its previous name become Siebel Analytics.
BI environment is a very whole and easy to apply, but does not use systems of OLAP, works immediately at the relational version of database.

The suite includes tools which might be:
Oracle BI Server: Centralized get entry to to information and calculation engine that relies on a logical model of common employer records (stage of abstraction of the metadata)
Oracle BI Server Administrator: advent of metadata and stages of abstraction
Oracle BI solutions: Self-carrier ad-hoc that lets in end users to easily create charts, pivot tables, reviews and dashboards, and drill skills navigate up / down.
Oracle BI Interactive Dashboards: interactive dashboards for checking out environments.
Oracle BI publisher (también conocido como XML writer): Reporting commercial enterprise operational and distribution of stories with first-rate detail.
Oracle Database general version One: Database
Oracle Warehouse Builder (middle ETL): layout of database and extract, rework and cargo (ETL) that enables manage the lifecycle of records and metadata

The simple technique as a way to create analytical reports and dashboards with this suite would be:
ETL design and production of systems on tables with OWB dimensional
Definition of metadata and bodily layers, the enterprise and introduction to Oracle BI Server Administrator
growing reviews and dashboards with BI solutions and Interactive Dashboards
To create and distribute operational reports can be used independently BI writer.

The reviews are designed using Microsoft phrase or Adobe Acrobat (installing an upload-in) after which also can put up and edit internet server thru WebDav.
This software, despite the fact that the portal is integrated with BI Dashboards for Oracle’s own, and is a chunk more bulky to use. it’s miles rarely used until there are specific needs that cannot be solved with BI solutions.