1 / 11

Oracle Business Intelligence Tips and Tricks

Oracle Business Intelligence Tips and Tricks. Diane Grace diane.grace@oracle.com.

emma-chambers
Download Presentation

Oracle Business Intelligence Tips and Tricks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Business Intelligence Tips and Tricks Diane Grace diane.grace@oracle.com

  2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  3. Agenda • Selection Steps • BI Composer • Metadata Dictionary • Sample Application

  4. What are Selection Steps? • Allows you to further filter/manipulate a result set returned by an Analysis • Are applied after the query is aggregated and affect only the displayed members, not the aggregated values. • Are per column and can not cross columns.

  5. When are Selection Steps made? • When you add a column to an analysis, a selection step is created automatically to start with all members, unless you explicitly add specific members. • As you drag and drop column members in the Results tab to add to the analysis, steps are also created automatically. • As you add groups and calculated items, steps are created automatically • When you use right-click interactions (such as Add Related or Keep Only) to refine the selection of data for a particular hierarchical column or attribute column, steps are created automatically. • You can create steps directly using the Selection Steps pane, to refine the selection of data for a particular hierarchical column or attribute column.

  6. BI Composer • Simple-to-use wizard that allows you to quickly and easily create, edit, or view analyses without the complexities of the "Analysis editor".

  7. Metadata Dictionary • Metadata information for subject areas, folders, columns, and hierarchy levels. • The metadata dictionary is a static set of XML documents. Each XML document describes a metadata object, such as a column, including its properties and relationships with other metadata objects.

  8. OBIEE Sample Application • A comprehensive collection of examples designed to demonstrate Oracle BI capabilities and design best practices • Available from http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

More Related