Business Intelligence Cookbook：A Project Lifecycle Approach Using Oracle Technology

Enabling Virtual Private Database in OBIEE

Configuring OBIEE catalog security

Configuring OBIEE privileges

Creating and configuring OBIEE roles

Integrating Microsoft Active Directory into OBIEE

Configuring OBIEE for multiple security providers

Creating Virtual Private application context

Creating a column-level Virtual Private Database

Creating a row-level Virtual Private Database (VPD)

Creating an APEX custom authentication procedure

Introduction

Chapter 14. Security

Enabling multi-language for the shared captions

Enabling dynamic descriptions

Enabling dynamic column headings

Consolidating reports using the column selector

Creating multi-table hierarchies

Developing level-based hierarchies

Abstracting your tables using aliases

Developing your standards and guidelines

Introduction

Chapter 13. Optimizing the Access

Creating the Upload interface

Defining the APEX Upload application

Defining the audit triggers

Developing the journal tables to track changes

Creating your application tables

Creating your application schema

Introduction

Chapter 12. Enhancing the Data

Designing a notification routine

Designing ETL data reconciliation routines

Designing ETL error trapping and detection routines

Adding additional columns to facilitate error trapping and correction

Separating your extraction from your loading and transforming routines

Abstracting your source system

Introduction

Chapter 11. Defining the ETL/ELT

Creating your enterprise data models

How to forward engineer your logical data model to a relational data model

Adding Standard columns to your data model

Creating your glossary

Creating your domains

How to reverse engineer your relational data model to a logical data model

How to import data models

Synchronizing data model changes with Subversion

Checkout data models from Subversion

Importing data models into Subversion

Connecting Oracle SQL Data Modeler to Subversion

Introduction

Chapter 10. Constructing the Data Model

Building automated data profiling with Oracle Warehouse Builder

Building changing information data profiling scripts

Building significant columns data profiling scripts

Building data lengths data profiling scripts

Building hierarchy data profiling scripts

Building density data profiling scripts

Building record count profiling scripts

Building domain/distinct values profiling

Building high and low data profiling scripts

Introduction

Chapter 9. Analyzing the Data

Defining the detailed transformations

Developing the data lineage

Creating a source matrix

Creating a report requirements matrix

Creating a business process matrix

Validating and enhancing a conceptual data model

Introduction

Chapter 8. Analyzing the Sources

Selecting the Third Normal Form or a Dimensional model

Defining your database layout

Choosing your database type

Introduction

Chapter 7. Architecture and Design

Defining your data retention requirements

Defining your security requirements

Defining your data dictionary

Adding metrics to your semantic data model

Adding hierarchies to your semantic data model

Prioritizing the business requirements

Categorizing the business requirements by business drivers

Defining the business rules

Decomposing the reports and requirements

Introduction

Chapter 6. Analyzing the Requirements

Building the blueprint

Identifying your source of record for your business entities

Developing your semantic data model

Decomposing your analysis and reports to define business entities

Categorizing your metrics analysis and reports within the business process

Outlining your business processes

Introduction

Chapter 5. The Blueprint

Creating a constant feedback and communications loop

Building a continuous development capability for enhancements

Creating script artifacts

Creating ODI code artifacts

Creating APEX code artifacts

Creating OBIEE code artifacts

Creating OWB code artifacts

Introduction

Chapter 4. Wrapping Up the Project

Installing client tools for a collaborative environment

Setting up a collaborative environment

Creating a cyclical build and test process

Creating a defect and enhancement register

Creating an effective issue management register

Creating an effective risk register

Requirements Traceability Matrix

Introduction

Chapter 3. Controlling the Project

Creating your estimation tool

Identifying and quantifying the effort drivers

Building a standard work breakdown structure

Creating Production work practice

Creating Promote work practice

Creating Testing work practice

Creating Development work practice

Creating Data Discovery work practice

Creating Definition work practice

Introduction

Chapter 2. Establishing the Project

Organizing your project team

Assessing your project team

Adapting your project delivery methodology

Mapping your business culture

Program or a project

Introduction

Chapter 1. Defining a Program

Customer support

Reader feedback

Conventions

Who this book is for

What you need for this book

What this book covers

Preface

Support files eBooks discount offers and more

www.PacktPub.com

About the Reviewers

Acknowledgement

About the Author

Credits

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

coverpage

coverpage

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Support files eBooks discount offers and more

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Chapter 1. Defining a Program

Introduction

Program or a project

Mapping your business culture

Adapting your project delivery methodology

Assessing your project team

Organizing your project team

Chapter 2. Establishing the Project

Introduction

Creating Definition work practice

Creating Data Discovery work practice

Creating Development work practice

Creating Testing work practice

Creating Promote work practice

Creating Production work practice

Building a standard work breakdown structure

Identifying and quantifying the effort drivers

Creating your estimation tool

Chapter 3. Controlling the Project

Introduction

Requirements Traceability Matrix

Creating an effective risk register

Creating an effective issue management register

Creating a defect and enhancement register

Creating a cyclical build and test process

Setting up a collaborative environment

Installing client tools for a collaborative environment

Chapter 4. Wrapping Up the Project

Introduction

Creating OWB code artifacts

Creating OBIEE code artifacts

Creating APEX code artifacts

Creating ODI code artifacts

Creating script artifacts

Building a continuous development capability for enhancements

Creating a constant feedback and communications loop

Chapter 5. The Blueprint

Introduction

Outlining your business processes

Categorizing your metrics analysis and reports within the business process

Decomposing your analysis and reports to define business entities

Developing your semantic data model

Identifying your source of record for your business entities

Building the blueprint

Chapter 6. Analyzing the Requirements

Introduction

Decomposing the reports and requirements

Defining the business rules

Categorizing the business requirements by business drivers

Prioritizing the business requirements

Adding hierarchies to your semantic data model

Adding metrics to your semantic data model

Defining your data dictionary

Defining your security requirements

Defining your data retention requirements

Chapter 7. Architecture and Design

Introduction

Choosing your database type

Defining your database layout

Selecting the Third Normal Form or a Dimensional model

Chapter 8. Analyzing the Sources

Introduction

Validating and enhancing a conceptual data model

Creating a business process matrix

Creating a report requirements matrix

Creating a source matrix

Developing the data lineage

Defining the detailed transformations

Chapter 9. Analyzing the Data

Introduction

Building high and low data profiling scripts

Building domain/distinct values profiling

Building record count profiling scripts

Building density data profiling scripts

Building hierarchy data profiling scripts

Building data lengths data profiling scripts

Building significant columns data profiling scripts

Building changing information data profiling scripts

Building automated data profiling with Oracle Warehouse Builder

Chapter 10. Constructing the Data Model

Introduction

Connecting Oracle SQL Data Modeler to Subversion

Importing data models into Subversion

Checkout data models from Subversion

Synchronizing data model changes with Subversion

How to import data models

How to reverse engineer your relational data model to a logical data model

Creating your domains

Creating your glossary

Adding Standard columns to your data model

How to forward engineer your logical data model to a relational data model

Creating your enterprise data models

Chapter 11. Defining the ETL/ELT

Introduction

Abstracting your source system

Separating your extraction from your loading and transforming routines

Adding additional columns to facilitate error trapping and correction

Designing ETL error trapping and detection routines

Designing ETL data reconciliation routines

Designing a notification routine

Chapter 12. Enhancing the Data

Introduction

Creating your application schema

Creating your application tables

Developing the journal tables to track changes

Defining the audit triggers

Defining the APEX Upload application

Creating the Upload interface

Chapter 13. Optimizing the Access

Introduction

Developing your standards and guidelines

Abstracting your tables using aliases

Developing level-based hierarchies

Creating multi-table hierarchies

Consolidating reports using the column selector

Enabling dynamic column headings

Enabling dynamic descriptions

Enabling multi-language for the shared captions

Chapter 14. Security

Introduction

Creating an APEX custom authentication procedure

Creating a row-level Virtual Private Database (VPD)

Creating a column-level Virtual Private Database

Creating Virtual Private application context

Configuring OBIEE for multiple security providers

Integrating Microsoft Active Directory into OBIEE

Creating and configuring OBIEE roles

Configuring OBIEE privileges

Configuring OBIEE catalog security

Enabling Virtual Private Database in OBIEE