Book Image

Oracle Business Intelligence Enterprise Edition 12c - Second Edition

By : Adrian Ward, Christian Screen, Haroun Khan
Book Image

Oracle Business Intelligence Enterprise Edition 12c - Second Edition

By: Adrian Ward, Christian Screen, Haroun Khan

Overview of this book

Oracle Business Intelligence Enterprise Edition (OBIEE) 12c is packed full of features and has a fresh approach to information presentation, system management, and security. OBIEE can help any organization to understand its data, to make useful information from data, and to ensure decision-making is supported by facts. OBIEE can focus on information that needs action, alerting users when conditions are met. OBIEE can be used for data analysis, form production, dashoarding, and workflow processes. We will introduce you to OBIEE features and provide a step-by-step guide to build a complete system from scratch. With this guide, you will be equipped with a good basic understanding of what the product contains, how to install and configure it, and how to create effective Business Intelligence. This book contains the necessary information for a beginner to create a high-performance OBIEE 12c system. This book is also a guide that explains how to use an existing OBIEE 12c system, and shows end users how to create.
Table of Contents (24 chapters)
Oracle Business Intelligence Enterprise Edition 12c - second Edition
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Creating our first analysis


Time to get stuck into creating some content. We will now create a simple analysis.

  1. Log into OBIEE.

  2. Use the URL http://[servername]:[port]/analytics. In our case, this is http://obiee:9502/analytics/:

    After log in, you are taken to the Home page. In the left-hand panel, you will see the Create... section:

  3. Click on the word Analysis:

  4. Select a Subject Area by clicking on Sample Sales Lite:

    You are now presented with the designer window. On the left side, you will see all of the columns you can choose from in your analysis.

  5. Click on the arrowhead to the left of the Time folder:

  6. Double-click on the Per Name Year column (Note: You can also drag and drop the column into the right pane.)

  7. Expand the Base Facts folder.

  8. Double-click on the Revenue column:

  9. Now click on the Results tab.

  10. You can now see the Revenue by year:

    We can also add columns whilst in the Results view.

  11. Expand the Time folder.

  12. Drag the column Per Name Month over to the table, and place it to the left of...